|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: How to remove single quote ? |
|
From: |
Fredrik Vestin |
|
Date: |
4/22/1999 3:22:41 PM |
|
IP: |
194.18.100.47 |
It is not possible to workaround this problem without doin parameter queries in Access for example. Consider the following SQL statement:
CONN.EXECUTE("SELECT * FROM TABLE WHERE FIELD = '" & userinput & "'")
where userinput is a string variable. Whenever a string with a single quote is passed it will result in an invalid SQL statement. You could replace the double quotes with single quotes and vice versa, but then you would run into the same problem when passing a string with double quotes. A string with both a single and a double quote character in it would't work in either case.
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
