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]
- RE: SQL Statement help! Jochem van Dieten
- RE: SQL Statement help! Jochem van Dieten
- RE: SQL Statement help! Tony Weeg
- RE: SQL Statement help! Tony Weeg
- RE: SQL Statement help! Jochem van Dieten
- RE: SQL Statement help! Tony Weeg
- Re:SQL Statement help! Jochem van Dieten
- Re:SQL Statement help! ColdFusion Programmer
- RE: SQL Statement help! Tony Weeg
- Re:SQL Statement help! Jochem van Dieten
- RE: SQL Statement help! ColdFusion Programmer
- RE: SQL Statement help! Tony Weeg
- Re:SQL Statement help! ColdFusion Programmer
- RE: SQL Statement help! Tony Weeg
- Re:SQL Statement help! ColdFusion Programmer
- RE: SQL Statement help! Tony Weeg
- Re:SQL Statement help! ColdFusion Programmer
- Re: SQL Statement help! Jochem van Dieten