I don't think that cfqueryparam is the solution to this problem. Jim's approach is definitely the right way to go. If you're using it, the question is why does FORM.commentID#i# contain more than one number? Forget about updating the db for a bit and cfdump the form data out on screen. You should get sets of data ending in 1,2,3. E.g. commentactive1, commentid1, commentactive2, commentid2... and each should contain the value of ONE form field.
Are you getting that? Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 23, 2003 10:56 AM Subject: RE: Updating Multiple Records > Quoting Russ <[EMAIL PROTECTED]>: > > > > 12 : > > commentActive='#Evaluate("FORM.commentActive#i#")#' > > 13 : WHERE commentID=#Evaluate("FORM.commentID#i#")# > > 14 : </cfquery> > > 15 : </cfloop> > > Use cfqueryparam. > > Jochem > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
