Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Wed, Jun 8 2011 12:02 PM	Permanent Link
Dale Derix	I'm trying to create a parameterized query with a start and end date, so far without success. WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate >= TIMESTAMP :StartDate AND ivInvoiceDate <= TIMESTAMP :EndDate Anyone know how to do this? Thanks
Wed, Jun 8 2011 12:31 PM	Permanent Link
Dale Derix	Duhhh WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate >= :StartDate AND ivInvoiceDate <= :EndDate Sometimes I amaze myself Dale
Wed, Jun 8 2011 1:55 PM	Permanent Link
Uli Becker	Dale, << WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate >= :StartDate AND ivInvoiceDate <= :EndDate >> or WHERE ivCaseKey = :ivCaseKey AND ivInvoiceDate between :StartDate AND :EndDate Regards Uli
Thu, Jun 9 2011 3:58 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Dale, << Sometimes I amaze myself >> A good rule to help you remember is that you never use literal prefixes, quotes, etc. with parameters. -- Tim Young Elevate Software www.elevatesoft.com