2 Replies Latest reply on Aug 16, 2008 9:43 AM by BKBK

    problems with quotations marks

    RodrigoRysdyk Level 1
      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?