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/
<<winmail.dat>>
