Missing comma in this piece (right before sum(totalbirds). Change that and
see what happens.
SELECT IIF(site_date < {d '2000-04-27'} sum(totalbirds), 0) AS
weekbirds, IIF(1>0, sum(totalbirds), 0) AS monthbirds, IIF(1>0,
sum(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
----- Original Message -----
From: Deanna L. Schneider <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 20:06
Subject: Re: OT - IIF function in Access
> 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(1>0, sum(totalbirds), 0) AS weekbirds,
> IIF(1>0, sum(totalbirds), 0) AS monthbirds,
> IIF(1>0, sum(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>
>
>
> But if I try to throw a variable in there....it doesn't work. More
> thoughts?
> -d
>
>
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
> operator) in
> query expression 'IIF(site_date < #4/27/2000# sum(totalbirds), 0)'.
>
>
> SQL = "SELECT IIF(site_date < {d '2000-04-27'} sum(totalbirds), 0) AS
> weekbirds, IIF(1>0, sum(totalbirds), 0) AS monthbirds, IIF(1>0,
> sum(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"
>
>
>
>
> ************************************************************
> 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.
>
------------------------------------------------------------------------------
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.
