Thanks dudes, I actually got the if statement to work like I had planned... I was misreading the docs..
the statement is 'iif(CONDITION,TRUEVALUE,FALSEVALUE), not 'iff' duh to me! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Sabir Sent: Thursday, 13 February 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/
