Thanks for all that have replied so far. Still haven't gotten it fixed
though...
For my update multiple records problem with single quotes:
<CFOUTPUT>
<CFLOOP index="thisID" list="#FORM.ProjID#">
<CFQUERY NAME="update" datasource="creati610.data">
UPDATE INT_PROJECT
FORM_NUM= '#evaluate("FORM_NUM_#thisID#")#',
DUE_DATE= '#evaluate("FORM.DUE_DATE_#thisID#")#',
COMMENTS= '#evaluate("FORM.COMMENTS_#thisID#")#'
WHERE ID = #thisID#
</CFQUERY>
</CFLOOP>
</CFOUTPUT>
Attempted:
COMMENTS= '#FORM["COMMENTS_" & thisID]#'
and
COMMENTS= '#FORM["FORM.COMMENTS_" & thisID]#'
Generates a Syntax error (missing operator) in query expression ''comments
here'
Additionally,
COMV=Replace(Form["COMMENTS_#thisID#"], "'", "''", "all");
COMMENTS = '#PreserveSingleQuotes(COMV)#'
Generates the same error
Jezz, I didn't think this would be so difficult!
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
