Database search

[voidmain]

hi,

I have an application that searches database for a numerical field. Lately, i have been learning Ajax and I want to write a sql statement to search based on keys entered.

For eg,

SELECT * from tbldata where productNumber LIKE '" & value_from_querystring &"'%", dbconn, 3, 3

But when i run this statement, it gives me an error, saying there's a problem with syntax near ','.

I am confused.

[jhardman]

try:

query = "SELECT * from tbldata where productNumber LIKE %" & value_from_querystring &"%", dbconn, 3, 3

(I took out the single quotes and put the percent on both sides)

Jared