Below is a piece of code that takes form input from the user (projectTradesNeeded) and checks it with the access database column (contractorservices), right now it is set "equals to" Id like to have it be LIKE with a wild card on the users input, but I don't know how to write the syntax for it using mysql and the example below..
would I put the "Request.Form("projectTradesNeeded") in parathesis and put "*" the wild cards around it? or would I put quotes?
any help or direction would be appreciated:)

thankyou

mySQL = "SELECT contractorsname, contractorID, contractorservices, address1, address2, city, state, island, zip, phone FROM contractor WHERE";
mySQL = mySQL + " contractorservices = '" + Request.Form("projectTradesNeeded") + "'";

You can try this

mySQL = mySQL + " contractorservices like '" + Trim(Request.Form("projectTradesNeeded")) + "%'";

-Ned

i got this run time error when i tried it:

Microsoft JScript runtime error '800a138f'
Object expected



i'm using access but the mysql syntax seems to work with every thing else.. ex: i'm using "+" instead of "&" to concatanate..
any ideas?

Hi there,

The problem of Object Expected is caused by the fact that the Trim method is VB Script ASP. AFAIK, JavaScript / JScript does not support the Trim method natively. This should work: If you still need to trim the QueryString, you may need to code some additional logic. Otherwise, just leave it out and it should work.

If you want to perform a true LIKE (where the search string can be anywhere in the column's value), you'll need to add an additional % before the Request.Form: BTW, you say MySQL.... Are you referring to the mySQL statement, or are you referring to the MySQL product??

Cheers,


Imar