add 'FROM dual' at the end:
Access should work as SQL server but I have not tried months ago.
Jaime/
-Original Message-
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 27, 2000 11:17 AM
To: CF-Talk
Subject: access iif count
Hi folks,
I'm trying to use
Garza [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 27, 2000 7:24 PM
To: CF-Talk
Subject: RE: access iif count
Power to the sub queries!
FOR SQL Server:
SELECT
(SELECT Count(*) FROM Survey WHERE success=1) as SuccessYes,
(SELECT Count(*) FROM Survey WHERE success=0) as Succes
Thanks Jaime,
But, it doesn't work. Syntax Error.
-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
Thanks Peter. That did it. I swear I tried that. Oh well. Brain burp.
-Deanna
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI
Hi folks,
I'm trying to use IIF in a query to count a bunch of yes/no values. Here's
what I'm trying that doesn't work (both count the total rows):
cfquery name="countyesnos" datasource="#dsn#"
SELECT COUNT(IIF (success = 1, 1, 0)) as successyes,
COUNT(iif (success = 0, 1, 0)) as successno
5 matches
Mail list logo