well, ADO.NET has datasets in memory that you can update and they can still be in memory only. you then call the underlying database to update when you're ready but you don't have to.
as I said, I've done updates by deleting first then queryAddRow(), querySetCell()'s the values. cumblesome but it worked. Damn! I should have suggested this for the CF8 wish list since I spent so long doing this hacky QofQ stuff. Maybe a feature for CF9? On 8/15/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > I am no QoQ expert, however the QoQ is done against a dataset held in memory > and not against the Database, so the answer would be NO. > > Your best bet for complex queries would be a View, that way you can update > what you want to do into the database. > > But even with a QoQ, you have certain info that you could use to update > against the Database anyway. > > I am not sure why you would have tried to update the QoQ, as it is a memory > held object (Dataset) anwyay. > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > -----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 -~----------~----~----~----~------~----~------~--~---
