For starters, now is not a function, but now() is.
<CFSET offset[60] = DateAdd('n', -60, now())>
See where you're missing some () inside your CFIF's too?
I don't see where offset[60] being manipulated as an indexed array at all.
So why not just something nice and flat, like offset_60?
<CFSET offset_60 = DateAdd('n', -60, now())>
offset_60 should then be a date object. Consequently, you may want to
use this function to insure that you make nice format with your sql server:
WHERE (dns_id = '#dns_lookup.dns_id#') and (dns_hit_datetime between
#createODBCDate(offset_60)# and #createODBCDate(now())#)
Don't know what your db server is, but this syntax booster often helps
with classics like PostgreSQL.
Finally, make your x var lowercase throughout. I don't care whether or
not your current language of choice needs it or not. Better start now!
See where all that gets you.
Alan Holden
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en
!! save a network - please trim replies before posting !!
