2 single quotes

[BigBadDave]

Why does CF add in a second single quote to the following:

<cfscript>
  sql = &quot;SELECT * FROM students WHERE sid Is Not Null AND sname <> 'Byng' AND sname <> 'Burns' AND incs <> 'true'&quot;;
  if (IsDefined (&quot;o&quot;)) {
      sql = sql & &quot; AND paid = '#o#'&quot;;
  }
  sql = sql & &quot; ORDER BY sname, fname ASC&quot;;
  total = 10;
</cfscript>
<cfquery name=&quot;ema&quot; datasource=&quot;ema&quot;>
  #sql#
</cfquery>

It %*&%* up the SQL and dosn't work:

SQL SELECT * FROM students WHERE sid Is Not Null AND sname <> ''Byng'' AND sname <> ''Burns'' AND incs <> ''true'' AND paid = ''Y'' ORDER BY sname, fname ASC
DATASOURCE ema
VENDORERRORCODE 1064
SQLSTATE 42000 Regards
David Byng

http://www.byngdesigns.co.uk

davidbyng@hotmail.com

 

[BigBadDave]

Sorry! should have searched first found the answer from this thread: thread232-5650 Regards
David Byng

http://www.byngdesigns.co.uk

davidbyng@hotmail.com