|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 14th, 2002, 02:25 AM
|
|||
|
|||
|
SQL Parameters & passing variable info with single quotes (') / ADO help
Originally posted by : laser (laser@buckeye-express.com)In Foxpro, Access & RDO it used to be possible to pass variables that had single quotes in a SQL statement by doing the following:but for some reason this doesn't seem to work properly with data that has single quotes from an asp page.What is the secret to passing this information with SQL and ADO?
|
|
#2
July 17th, 2002, 03:47 PM
|
|||
|
|||
|
Originally posted by : Johnny Cabrera (john.m.cabrera@cnet.navy.mil)Declare a variable and put your string there, then using the function Replace(var, "'", "''") search your variable for single quotes and replace with two single quotes.------------laser at 2/14/2002 12:25:36 PMIn Foxpro, Access & RDO it used to be possible to pass variables that had single quotes in a SQL statement by doing the following:but for some reason this doesn't seem to work properly with data that has single quotes from an asp page.What is the secret to passing this information with SQL and ADO?
|
|
| Viewing: ASP Free Forums > Database > SQL Development > SQL Parameters & passing variable info with single quotes (') / ADO help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
