problems with quotations marks

[Guest]

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?

[Dan_Bracuk]

Use the PreserveSingleQuotes function.

[BKBK]

I should also expect this to work:

<cfquery>
#toString(Variables.sqlAux)#
</cfquery>