Yes I did that, but was wondering if my original statement was formatted
wrong or just not possible.
why do something in two steps if its possible in one.
-----Original Message-----
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 10:30 AM
To: CF-Talk
Subject: RE: using PreserveSingleQuotes
Have you tried evaluating the value outside of the PSQ function...
<CFSET myVarWithQuotes = Trim(EVALUATE("#columnname#_#recordnumber#"))>
<CFQUERY name="qname">
UPDATE tbltable
SET tblfield = '#PreserveSingleQuotes(myVarWithQuotes)#'
</CFQUERY>
-----Original Message-----
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 2:08 PM
To: CF-Talk
Subject: using PreserveSingleQuotes
Help
What am I doing wrong here? I get a "just in time compilation
error".
<CFQUERY name="qname">
UPDATE tbltable
SET tblfield =
'#PreserveSingleQuotes(Trim(EVALUATE("#columnname#_#recordnumber#")))#'
</CFQUERY>
its erring on the ( before EVALUATE.
if I take Trim out then it gives same error for ( after EVALUATE.
Can "PreserveSingleQuotes" contain other expressions or will I need
to do the EVALUATE and Trim before the SET.
Thanks
Rodney
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
