Try
<CFQUERY blah>
SELECT 'BANANA' AS fruitType, 'NOT 1' AS Type
FROM fruityGoodness
WHERE type <> 1
UNION
SELECT 'APPLE' AS fruitType, '1' AS Type
FROM fruityGoodness
WHERE type = 1
</CFQUERY>
Regards
Steve Onnis
Domain Concept Designs
+61 422 337 685
+61 3 9444 7504
http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com>
("If you think it can't be done, you haven't asked me!") - Steve Onnis
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Sabir
Sent: Thursday, February 13, 2003 10:07 AM
To: CFAussie Mailing List
Subject: [cfaussie] 'if' in SQL
Hey all, how would I do an 'if' statement in an SQL query on an Access
database?
I'm trying something like:
<CFQUERY blah>
SELECT if(type = 1,'APPLE','BANANA') AS fruitType
FROM fruityGoodness
</CFQUERY>
but its returning an error, i"ve also tries 'iff' .. can I even do this kind
of thing in Access?
thanks...
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of CFAUSSIE
Sent: Thursday, 13 February 2003 9:16 AM
To: CFAussie Mailing List
Subject: [cfaussie] Crystal Reports
Howdy again,
Last night at our CFUG...I asked the question bout reports and if there was
any other alternatives to crystal. Either CF related or a 3rd party....cf
would be better though. The answer I got last night wasn't entirely what I
wanted to hear.
Any advise would be helpful...
Thanks again!!!
Jeremy
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
