|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Single quote stops the query |
|
From: |
Toms |
|
Date: |
8/22/2000 2:45:20 PM |
|
IP: |
198.199.186.66 |
this works . . . .
<%
The following procedure handles single quotes in names ...ie DOmato
define a working variable
Dim tmpText2
populate our working variable
tmpText2 = request("SelectDetail")
replace each apostrophe with two apostrophes
tmpText2 = Replace(tmpText2,Chr(39),String(2,39))
use the fixed string in SQL Select
%> |
Previous Message
Follow Up - Re: Single quote stops the query - Pavan 9/18/2000 9:54:10 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
