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/
