Question
problems with quotations marks
Hi,
I got some problems with quotations marks in my queries.
I am trying to do something like this:
<cfset Variables.sqlAux = "select * from customer where name='Rodrigo' ">
<cfquery>
#Variables.sqlAux#
</cfquery>
Coldfusion returns this error messagem:
Incorrect syntax near 'Rodrigo'.
Some one can help?
I got some problems with quotations marks in my queries.
I am trying to do something like this:
<cfset Variables.sqlAux = "select * from customer where name='Rodrigo' ">
<cfquery>
#Variables.sqlAux#
</cfquery>
Coldfusion returns this error messagem:
Incorrect syntax near 'Rodrigo'.
Some one can help?
AdChoices