good.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 10:31 AM
To: CF-Talk
Subject: Re:SQL Statement help!
I think this is what you mean
DateTime - 2003/09/01 11:52:16
Now - {ts '2003-10-10 15:28:19'}
>whats the value of dateTime parse out to?
>
>
>...tony
>
>tony weeg
>senior web applications architect
>navtrak, inc.
>www.navtrak.net
>[EMAIL PROTECTED]
>410.548.2337
>
>-----Original Message-----
>From: ColdFusion Programmer [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 10, 2003 9:32 AM
>To: CF-Talk
>Subject: Re:SQL Statement help!
>
>I now get a different error
>
>Query Of Queries runtime error.
>Unsupported type comparison.
>
>>ColdFusion Programmer wrote:
>>> Guys, I'm sorry for so many errors on my part. Jochem, the code your
>>> posted throws an error,
>>>
>>> Error Executing Database Query.
>>>
>>> Query Of Queries syntax error.
>>> Encountered "{" at line 0, column 0. Incorrect conditional
>>> _expression_, Expected one of [like|null|between|in|comparison]
>>> condition,
>>
>>SELECT UserName,
>> SearchString,
>> Count(SearchString) AS Occurences
>>FROM qTmp
>>WHERE <cfqueryparam cfsqltype="cf_sql_timestamp"
>>value="#DateAdd("d",-7,Now())#"> < DateTime GROUP BY UserName,
>> SearchString
>>
>>Jochem
>>
>>
>>
>>
>________________________________
>
>
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
