I think you've got the SUM and IIF nested the wrony way 'round - try
SUM(IIF(site_date {d '2000-04-27'}, totalbirds, 0))
-Original Message-
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 10:07 PM
To: [EMAIL PROTECTED]
Subject: Re: OT - IIF
Hi folks, this is a bit OT, but I thought there might be a better way to do
what's not working in CF anyway, so here it is:
I have the following code:
cfset week = #now()# - #createtimespan(7, 0, 0, 0)#
cfset month = #now()# - #createtimespan(30, 0, 0, 0)#
cfset year = #now()# -
I usually see the query coded as:
AND site_date #date1#
AND site_date #now()#
Primitive I know, but tried and true :-)
-Original Message-
From: Deanna L. Schneider [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, May 04, 2000 3:10 PM
Subject: OT - IIF
Thanks, John, but that's not really the problem, I don't think.
The query works if I use constants like this.
cfquery name="pullcount" datasource="#dbvar#"
SELECT IIF(10, sum(totalbirds), 0) AS weekbirds,
IIF(10, sum(totalbirds), 0) AS monthbirds,
IIF(10, sum(totalbirds), 0)AS yearbirds,
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
- Original Message -
From: Deanna L. Schneider [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 04, 2000 20:06
Subject: Re: OT - IIF
5 matches
Mail list logo