Steve Onnis
unread,Sep 4, 2012, 3:56:28 AM9/4/12Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to cfau...@googlegroups.com
Can anyone help me out with this. Doesnt matter what i try it wont work :(
Trying to return items within a date range or after a certain date but the end date in the db can be empty or null. any ideas on where i am going wrong?
LOCAL.r = ORMExecuteQuery("
SELECT af.title, af.caption, af.asset.assetid
FROM Feature as af join af.asset as a
WHERE a.assettype.assettypeid = 1
AND a.orientation = 'Landscape'
AND (
af.startdate >= :dateValStart
AND
(af.enddate <= :dateValEnd OR af.enddate IS NULL)
)
",
{dateValStart=createODBCDate(NOW()), dateValEnd=createODBCDate(NOW())}, false, {maxResults=ARGUMENTS.records});