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 -~----------~----~----~----~------~----~------~--~---
