RE: quot problem

2001-01-15 Thread Russel Madere
I have done this before. For the SQL statement I replace all single quotes with ''. To get a selected string to display properly in HTML, I replace double quotes with " and amperstands with &. This eliminates most problems I have had with

RE: quot problem

2001-01-15 Thread Philip Arnold - ASP
> Is anybody have problem about using sql statement with quot( " ) > and single > quot( ' ) insert or query from database and for retrieve and display in > coldfusion. It's a mixture between a SQL and a ColdFusion problem - to use single quotes you have to escape it,