Well that's how I was able to narrow it down to that one line.
Anyways, I think I figured out the problem. Here is a bigger piece of the
code
<CFSET offset[60] = '#DateAdd('n', -60, now)#'>
<CFQUERY datasource="details_at_dns" name="get_hit_data_last_hour">
Select dns_hit_id, dns_hit_datetime, dns_id
FROM tbl_dns_hits
WHERE (dns_id = '#dns_lookup.dns_id#') and (dns_hit_datetime between
#offset[60]# and #now()#)
</CFQUERY>
<cfset hit = ArrayNew(1)>
<CFLOOP index="X" from="1" to="60">
<CFLOOP query="get_hit_data_last_hour">
<CFSET variables.hit[x] = 0>
<CFIF (get_hit_data_last_hour.dns_hit_datetime GT DateAdd('n', -X, now))
and (get_hit_data_last_hour.dns_hit_datetime LT DateAdd('n', -0, now))>
<cfset variables.hit[x] = variables.hit[x] + 1/>
</CFIF>
</CFLOOP>
</CFLOOP>
I'm clocking out from work now and need to catch the metrolink. If anybody
sees any red flags here, let me know. I'm going to keep working on this once
I get home from church band practice tonight.
--
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 !!
