[cfaussie] Re: Is there a delete version of queryAddRow()?
you can always wrap your usage of the internal method in your own library and then you only have to change it in one place On 10/11/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > > > > 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-Methods-For-Query-Manipulation-And-Logic.htm > > > > > On 10/11/07, Barry Beattie <[EMAIL PROTECTED]> wrote: > > Query'o;Query > > o 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. > > > > > > > > > > > > > > > > > > > > > > -- Zac Spitzer http://zacster.blogspot.com/ +61 405 847 168 (aussie moible) --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Is there a delete version of queryAddRow()?
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 o 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 -~--~~~~--~~--~--~---
[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-Methods-For-Query-Manipulation-And-Logic.htm On 10/11/07, Barry Beattie <[EMAIL PROTECTED]> wrote: > > Query'o;Query > > o 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Is there a delete version of queryAddRow()?
Query'o;Query o 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 -~--~~~~--~~--~--~---
[cfaussie] Re: Is there a delete version of queryAddRow()?
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 -~--~~~~--~~--~--~---
[cfaussie] Re: Is there a delete version of queryAddRow()?
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 -~--~~~~--~~--~--~---