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?

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?