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]

Reply via email to