« Previous Next »

Thread: Like query does not working in ASP with MS-Access

Last post 11-02-2008 5:07 PM by steve schofield. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

  • 11-02-2008, 1:42 PM

    Like query does not working in ASP with MS-Access

    I m using give below code to get record from ms access via asp.

    SELECT name FROM Tbl_PlayerList WHERE name Like '*raja*'

    But this query is not working.....but when i m running this query in ms access query window...there this query is running perfectly...but through ASP...it is not working why....

    Can any one help regarding this....i will be very thankful to him.

     

  • 11-02-2008, 5:07 PM In reply to

    Re: Like query does not working in ASP with MS-Access

    Try like '%raja%' with percentage signs vs. asteriks.

    Steve Schofield
    Windows Server MVP - IIS
    http://weblogs.asp.net/steveschofield


    http://www.IISLogs.com
    Log archival solution
    Install, Configure, Forget
Page 1 of 1 (2 items)
Microsoft Communities