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,
Any ideas?
>ColdFusion Programmer wrote:
>> This is what I'm doing, and I get an error. I'm using SQL Server
>> 2000
>
>No, you are not. Since your dbtype is "query", you are using CF.
>
>
>> <cfquery name="lQuery2" dbtype="query">
>> SELECT UserName, SearchString, Count(SearchString) AS Occurences
>> FROM
>> WHERE (#DateFormat(Now(),"yyyy/mm/dd")#
>> #TimeFormat(Now(),"HH:mm:ss")# - #qTmp.DateTime#) < 7 qTmp
>> GROUP BY UserName, SearchString
>> </cfquery>
>
>SELECT UserName,
> SearchString,
> Count(SearchString) AS Occurences
>FROM qTmp
>WHERE #DateAdd("d",-7,Now())# < DateTime
>GROUP BY UserName, SearchString
>
>Jochem
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]