I have another question about this query is there a way make the
where look like this with parenthesis
([recurringPayments].[paymentCount] < [recurringPayments].
[maxPayments] AND [recurringPayments].[endOn] >= ? AND
[recurringPayments].[startOn] <= ? AND [recurringPayments].[lastRun]
= ? )
OR [recurringPayments].[lastRun] IS NULL
On Jun 17, 2007, at 2:52 PM, Matthew Graf wrote:
I am using MG:U with Reactor and I am trying to write a query here
is what I have so far
<cfset temp = ormService.CREATEITERATOR("recurringPayments") />
<cfset temp.GETWHERE().isltField(OBJECTALIAS="recurringPayments",
fieldAlias="paymentcount",
compareToObjectAlias1='recurringPayments',
compareToFieldAlias1='maxPayments'
)>
<cfset temp.GETWHERE().isGte(OBJECTALIAS="recurringPayments",
fieldAlias="endOn",
value='#dateformat(now(),'mm/dd/yyyy')#'
)>
<cfset temp.GETWHERE().isLte(OBJECTALIAS="recurringPayments",
fieldAlias="startON",
value='#dateformat(now(),'mm/dd/yyyy')#'
)>
<cfset temp.getWhere().setMode('or')>
<cfset temp.getWhere().isNull(OBJECTALIAS="recurringPayments",
fieldAlias="lastrun"
)>
now I would like to add the month(lastrun) is not equal to the
current month. Any thoughts or Ideas?
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
