Problem in the LIKE query

zaeem · October 2nd, 2003, 12:07 AM

I am new to ASP I am using the query
<sqlQuery="Select * from journal where title LIKE ' " &search&" '">.But it is not working. Can anybody guide me in this regard. PLease also tell me where to insert Percentage(%)sign.
I am waiting for your quick response.
Bye

Zaeem Sherazi

jorevil · October 2nd, 2003, 02:21 AM

Hi,

You need all the records thath contains "search" in the TITLE field

search = "ASP"
sql = "SELECT * FROM JOURNAL WHERE TITLE LIKE '%" & search & "%'"

( SELECT * FROM JOURNAL WHERE TITLE LIKE '%ASP%' )

Is this what wou need or I wrong?

Imar · October 2nd, 2003, 02:21 AM

Hi there,

When you're a using LIKE, you'll need a wildcard as well. The LIKE you have now, finds just exact matches of search.

Try this:

sqlQuery = "SELECT * FROM journal WHERE title LIKE '%" & search & "%'"

This will find all records that contain search somewhere. If your results should start or end with search, remove one of the two % characters.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

zaeem · October 2nd, 2003, 02:45 AM

Thanks for ur aooperation but SEARC variable is not the static one, it is coming from other page and then on the basis of search I'll make the select query.

Zaeem Sherazi

zaeem · October 2nd, 2003, 02:51 AM

Hello Imar thanks for ur quick response. Your suggested solution is working very well.
Thanks again.
Bye

Zaeem Sherazi

Imar · October 2nd, 2003, 03:16 AM

I think jorevil's solution does exactly the same as mine. All that was added was assigning a value to the search variable, so the code would run.

Since you only posted the SQL statement, it wasn't clear where search got its value from.....

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.