|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: SELECT query error |
|
From: |
David Beal |
|
Date: |
7/2/2001 4:49:27 PM |
|
IP: |
64.162.117.152 |
Because you're using single quotes to out enclose your data the single quote will terminate the value you're trying to give it. I think this will do it;
<%
SearchValue = replace(query=query & filedvalue,"'","' + CHR(39) + '")
query="SELECT * FROM dbname WHERE fieldname='"
& SearchValue & "'"
%>
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
