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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
