macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: problem using DISTINCT

Subject: Re: problem using DISTINCT
From: "cf_dev2"
Date: Thu, 16 Aug 2007 18:00:26 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
The example I posted is for sql server.  Afaik, Access doesn't support CASE.   
That's why you're getting a syntax error.  I think Access uses either IIF() or 
possibly SWITCH?  Check your documentation.


<Prev in Thread] Current Thread [Next in Thread>