Hi all. For those that are curious, I figured out my IIF problem. This is
the solution:
<cfquery name="pullcount" datasource="#dbvar#">
SELECT SUM(IIF(site_date BETWEEN #now()# and #createodbcdate(week)#,
totalbirds, 0)) AS weekbirds,
SUM(IIF(site_date BETWEEN #now()# and #createodbcdate(month)#, totalbirds,
0)) AS monthbirds,
SUM(IIF(site_date BETWEEN #now()# and #createodbcdate(year)#, totalbirds,
0)) AS yearbirds,
site.per_id,
person.fname,
person.lname
FROM sighting, site, person
WHERE sighting.site_id = site.site_id
AND site.per_id = person.per_id
GROUP BY site.per_id, person.fname, person.lname
</cfquery>
Ugly, but functional.
Thanks anyway.
-d
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
