Hi Ryan, First option that springs to mind is to get rid of access and install a real database. Failing that I would either:
a) Do the translation you want within CF, or b) Within Access, define the query that you want, and then use CF to select from the query Cheers, Phil. ----- Original Message ----- From: "Ryan Sabir" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 10:06 AM 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/
