![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Tue, May 25 2010 11:55 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Tue, May 25 2010 6:04 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Wed, May 26 2010 2:56 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | How on earth did I miss that all the way from 2.03b1 to 2.03b13?
Roy Lambert |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |