CFQUERY TO PERFORM TIME COMPARISONS
Posted on 2004-04-23
I need help with the following code...
<cfset stime = dateadd("n",-10, time)>
<cfset etime = dateadd("n",10,time)>
<!--- Query of Query Running from Master Query--->
<cfquery name="notify" dbtype="query">
select username, name, time
where username = '#master.username#' and (time > #stime# or time < #stime#)
Above, I'm attempting to perform a time comparison where stime and etime is the window where time should be called on. However this doesn't seem to work.
Thanks for your help !