Can you do me a favor?
Stick a <cfdump var="#thisID#"> before the cfquery and comment out the
cfquery.
In fact, do this:
<cfoutput>
> <CFLOOP index="thisID" list="#FORM.ProjID#">
Record for #thisID#:<br>
> FORM_NUM= '#evaluate("FORM.NUM_#thisID#")#',<br>
> DUE_DATE= '#evaluate("FORM.DUE_DATE_#thisID#")#',<br>
> COMMENTS= '#evaluate("FORM.COMMENTS_#thisID#")#'<br>
> <hr>
> </CFLOOP>
</cfoutput>
This will show you exactly what it's doing and when. Visually debug your
code. Btw, the <cfoutput>s in your original statement aren't needed.
~Todd
On Tue, 13 Aug 2002, Les Mizzell wrote:
> Whoops, typo!
>
> It's correct on the actual page.
>
> Actually, it only the comments field that's the problem - everything else is
> fine. The update is actually much larger than the example - probably 50
> fields. Query works great until somebody puts something like "I can't
> figure this" into the comments field...
>
> 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>
--
============================================================
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) |
============================================================
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
