But also take into consideration, that these are internal methods to coldfusion an may become obsolete or changed.
I was trying to recall what the delete row was, as I have used it before but couldn't recall where I had used itL Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charles Condon Sent: Thursday, 11 October 2007 3:16 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Is there a delete version of queryAddRow()? I came across this a while ago http://www.bennadel.com/blog/204-Using-ColdFusion-Query-s-Underlying-Java-Me thods-For-Query-Manipulation-And-Logic.htm On 10/11/07, Barry Beattie <[EMAIL PROTECTED]> wrote: Query'o;Query ohhhh how I hate this horrible hack for deletes and updates (but there's no choice) I've suggested this for the CF9 wish list - native SQL syntax to do this. and updates to (otherwise you delete then addRow with new values) feel free to do the same http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform <http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform> On 10/11/07, Seona Bellamy <[EMAIL PROTECTED]> wrote: Oh yeah! Thanks. :) *slaps forehead and walks away muttering about forests and trees* On 11/10/2007, Blair McKenzie < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: select * from yourquery where primarykey not in (list,of,items,to,remove) Blair On 10/11/07, Seona Bellamy < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Heya, Working with a large cached query here (it's used several different times on the page in several different ways, so we've cached the whole big query and then just perform QoQ's on it to get the various sub-sets we need). I've run into a situation where I want to be able to selectively remove certain records from the recordset under specific circumstances. Is this possible? I thought there might have been a function to do it, along the lines of queryAddRow(), but there doesn't seem to be. Anyone ever done this before? Any advice would be appreciated. Cheers, Seona. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
