[ cf-dev ] timestamps and queries of queries

[Mark Woods]

um, am I doing something wrong or does cfmx not allow odbc/jdbc timestamps 
to be compared using < and > operators in queries of queries??

Running the query below I get the following error:
Query Of Queries syntax error.
Encountered "ts < {" at line 9, column 29. Incorrect conditional 
expression, Expected one of [like|null|between|in|comparison] condition

SELECT DISTINCT cacheName
FROM application.speck.wasCached
WHERE type IN (#listQualify(url.contentTypes,"'")#)
        AND id = ''
        AND label = ''
        AND keywords = ''
        AND ts < #createODBCDateTime(dateAdd("n","-#url.contentAge#",now()))#
The query being queried has no null values, though does have empty strings.

Thanks

Mark