> 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]