Thanks. I found it finally. The right syntax (for this issue) is select count(distinct prodcode) as prodcnt
There was a second issue with computed_field_1 the was being bounced by the ODBC driver as well. On Mon, Mar 16, 2009 at 3:54 PM, Jason Fisher <ja...@wanax.com> wrote: > > This is invalid: > > distinct(count prodcode) > > Are you trying to do a DISTINCT on the aggregate function COUNT()? > > Not sure that would work, but it would have to be DISTINCT COUNT(prodcode) > if that's what you're after. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4