Well, you couldn't have any joins in the query... that's one issue right off the bat.
Make your case. This is the second person to ask for this... why is it needed? It doesnt see like something that would be used frequently. Couldn't you just create a delete method on your gateway? I've done this in the past... Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of João Fernandes Sent: Thursday, March 09, 2006 3:35 PM To: [email protected] Subject: RE: [Reactor For CF] why is there no "deleteByQuery" in abstractgateway? Doug I have asked for this in the past: simple table user_id name country email the same way you can do <cfset gtw = reactorfactoryobj.createGateway("myobj")> <cfset query = gtw.createQuery()> <cfset query.getWhere().isEqual() .... .... .... <cfset gtw.getByQuery(query)> we could do the same for delete <cfset gtw = reactorfactoryobj.createGateway("myobj")> <cfset query = gtw.createQuery()> <cfset query.getWhere().isEqual("myobj","country","PT")> <cfset query.getwhere().isLike("myobj","email","@cofina.pt","right")> <cfset gtw.deleteByQuery(query)> it whould delete all my records that would match country = 'PT' and email like '[EMAIL PROTECTED]' Cascading deletes whould be great but I would be happy with just this. João Fernandes -----Original Message----- From: [EMAIL PROTECTED] on behalf of Doug Hughes Sent: Thu 09-Mar-06 7:45 PM To: [email protected] Subject: RE: [Reactor For CF] why is there no "deleteByQuery" in abstractgateway? Sorry, I was looking for something using reactor objects. IE: I'd like the syntax for this to look like this: *code Example* And this means.... Etc, etc. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Bell Sent: Thursday, March 09, 2006 2:19 PM To: [email protected] Subject: RE: [Reactor For CF] why is there no "deleteByQuery" in abstractgateway? Delete from #table# Where #Filter# is how we do it. Table is known by object, so you just pass filter. It does require knowledge of the object properties, but we store that in the #EntityName#Service, so it's OK. We also have a deletebyqueryimplications() which will return the captions for any cascading deletes if you implement that (for composition to avoid orphans) so you can tell people what you'll be doing before they do it. Best Wishes, Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Thursday, March 09, 2006 2:13 PM To: [email protected] Subject: RE: [Reactor For CF] why is there no "deleteByQuery" in abstractgateway? How would this function? Can you provide some pseudocode? Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David A. Cheslow PhD Sent: Thursday, March 09, 2006 1:40 PM To: [email protected] Subject: [Reactor For CF] why is there no "deleteByQuery" in abstractgateway? The subject says it all. Seems to me that a deleteByQuery() would be pretty handy (and easy to add) right there. Or have I missed something very obvious? =dave= -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
