I came across this a while ago http://www.bennadel.com/blog/204-Using-ColdFusion-Query-s-Underlying-Java-Methods-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 > > > > > > > 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]> wrote: > > > > > > select * from yourquery where primarykey not in > > > (list,of,items,to,remove) > > > > > > Blair > > > > > > On 10/11/07, Seona Bellamy < [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 -~----------~----~----~----~------~----~------~--~---