[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-23 Thread Zac Spitzer
[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

[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Seona Bellamy
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,

[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Blair McKenzie
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

[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Barry Beattie
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

[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Charles Condon
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

[cfaussie] Re: Is there a delete version of queryAddRow()?

2007-10-10 Thread Andrew Scott
. 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