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
> 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,
2 matches
Mail list logo