[Top] [All Lists]

Re: problem using DISTINCT

Subject: Re: problem using DISTINCT
From: "brianism"
Date: Thu, 16 Aug 2007 17:53:41 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion

Thank you cf_dev2. I think I get the idea of what that code is trying to do. I 
added it to my page and get the following error:

 ODBC Error Code = 37000 (Syntax error or access violation)

 [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in 
query expression 'MAX(CASE WHEN wh_standard = 'yes' THEN 1 ELSE 0 END)'.

 Is there something I should be adding to this?

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