<cfset querySetCell(oldquery , "thiscolumn", sidequery.thisvalue, sidequery.thisIndex) />
Just do that -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Wednesday, 15 August 2007 1:21 PM To: cfaussie Subject: [cfaussie] Can QofQ do updates? I'm having a problem with a Query of a Query, and it suddenly hit me - maybe QofQ can't actually DO an update, and that's why I'm getting the error! Can anyone please confirm that it IS indeed a supported function in Qof Q?? (we're talking CF7 here) If not, how would you go about running this code if you can't use query of queries: <cfloop query="sidequery"> <cfquery name="newquery" dbtype="query"> UPDATE oldquery set thiscolumn = '#sidequery.thisvalue#' WHERE index = '#sidequery.thisIndex#' </cfquery> </cfloop> (I've already decided that using the original SQLQuery to do all this in one step is too hard for a whole host of reasons) Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
