Howdy John,
Tuesday, October 1, 2002, 9:29:20 AM, John Beynon wrote:
JB> Still bitches....same error message - but the SQL at the bottom of the page
JB> changes to:
JB> SQL Select * from BlogArticles where articledate >= {d
JB> '2002-09-24'} order by articledate DESC
JB> What's with the ' stuff?
I don't know, but I also had probs with date comparisons in QofQ's. Then
I discovered mention of the fact that QofQ's don't allow ODBC dates in
comparison operations in Rob Brooks-Bilson's book "Programming
ColdFusion" (Note: Mr. B-B refers to QofQ's as CFSQL):
"CFSQL doesn't support nested aggregate functions nor does it support
ODBC dates in comparison operations." (p. 377)
This is the only reference I found thus far that addresses ODBC date
comparisons in QofQ's. It may be possible to work this out with a
workaround, but I haven't hit on it yet.
Chris Montgomery monty @ airtightweb.com
--
Airtight Web Services http://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-3249/888-745-7603
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
