I seem to have discovered a loophole in not being able to set parameters for INTERVALS. It works so I can now have a user defined parameter without having to rebuild the statement.

SELECT
_ID,
_fkContacts,
_fkStaff,
_InOutInd,
_ELNtype,
IF(_aList IS NOT NULL,TRUE,FALSE) AS _HasAttachments,
_Subject,
_Comments,
_Timestamp
FROM ELN
WHERE
_fkContacts = :IDToMatch
AND
_TimeStamp   >= CURRENT_TIMESTAMP - CAST(:Months AS INTERVAL  MONTH) <<<<<<<<<<<
ORDER BY _TimeStamp DESC


Roy Lambert

Roy,

<< I seem to have discovered a loophole in not being able to set parameters
for INTERVALS. It works so I can now have a user defined parameter without
having to rebuild the statement. >>

Yes, that was fixed here:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.02&incident=3065

--
Tim Young
Elevate Software
www.elevatesoft.com

How on earth did I miss that all the way from 2.03b1 to 2.03b13?

Roy Lambert