Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00904 Invalid column name for SELECT COUNT(DISTINCT ...) with Oracle 9i and ADO

Re: ORA-00904 Invalid column name for SELECT COUNT(DISTINCT ...) with Oracle 9i and ADO

From: Simon Roberts <ant2003_at_telpacific.com.au>
Date: 13 Oct 2003 21:15:32 +1000
Message-ID: <Xns9413D5919B8D5dr34m0ft0mm0rr0w@202.172.112.2> 





Simon Roberts <ant2003_at_telpacific.com.au> wrote in 
news:Xns9413D1C91599dr34m0ft0mm0rr0w_at_202.172.112.2:



> "Phil Jollans" <nospam_at_messring.de> wrote in

> news:b9qf57$kbblq$1_at_ID-178233.news.dfncis.de: 

> 

> Hey Phil

> 

> Try SELECT DISTINCT COUNT(<Column>) FROM <Table>

> 

> Simon

> 




Nah man your sql works fine on ADO 2.8 with MySQL



Simon
Received on Mon Oct 13 2003 - 06:15:32 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US