FORM_NUM= '#evaluate("FORM_NUM_#thisID#")#',
Should be:
FORM_NUM= '#evaluate("FORM.NUM_#thisID#")#',
?
On Tue, 13 Aug 2002, Les Mizzell wrote:
> 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!
--
============================================================
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion |
http://www.macromedia.com/support/forums/team_macromedia/ |
http://www.flashCFM.com/ - webRat (Moderator) |
http://www.ultrashock.com/ - webRat (Back-end Moderator) |
============================================================
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
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
