>
> <cfoutput>#DateFormat(Now()-7,"yyyy/mm/dd")# - #qTmp.DateTime#</cfoutput>
> <cfquery name="lQuery2" dbtype="query">
> SELECT UserName, SearchString, Count(SearchString) AS Occurences
> FROM qTmp
> WHERE <cfqueryparam cfsqltype="cf_sql_timestamp" value="#DateFormat(Now()-7,'yyyy/mm/dd')#"> < DateTime
> GROUP BY UserName, SearchString
> </cfquery>
Any NULLs in qTmp? What datatype is DateTime in the database?
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
