SQL Search problem

来源: iamdumb 于 2004-06-23 11:50:50 [] [旧帖] [给我悄悄话] 阅读数 : (556 bytes)

Everytime when the search word contain a ' (ex. Child's)
my search page cause a problem like:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '%'.
search.asp line 103


the following is my code:

SearchFor = TRIM ( Request("searchFor") )
.
.
.
open_statement = "SELECT * from User where Name like '%" & searchFor & "%' "



How can I fix the problem? Thanks so much for your help.

所有跟帖： 

• i just figure it out -iamdumb- ♀ 给 iamdumb 发送悄悄话 (115 bytes) () 06/23/2004 postreply 12:00:51

• Suggest use search procedure -DBDB- ♀ 给 DBDB 发送悄悄话 (885 bytes) () 06/23/2004 postreply 13:32:52

请您先登陆，再发跟帖！