Problem with download function

[Ramakers Josse]

when i put a group by in the sql statement the download function does
not work (previous ... do work fine)

Ex Mydb.sql = "select a , sum(b) as totals from file group by a"

this gives the following error
<font face=&#34;Arial&#34; size=2>
<p>Provider</font> <font face=&#34;Arial&#34; size=2>error &#39;80004005&#39;</font>
<p>
<font face=&#34;Arial&#34; size=2>Unspecified error</font>
<p>
<font face=&#34;Arial&#34; size=2>/ucbbud/asp/Exptest.asp</font><font face=&#34;Arial&#34; size=2> line 78</font>

Remark : I am working on an oracle database

thanks , jos

[Frank]

Is your SQL a valid statement -

Goto Scott/Tiger

Select empno, sum(sal) as salary from emp group by empno


will yield an error !!





On 2/23/99 3:30:37 AM, Ramakers Josse wrote:
>
when i put a group by in the sql statement the download function does
>
not work (previous ... do work fine)

Ex Mydb.sql = &#34;select a ,
> sum(b) as totals from file group by a&#34;

this gives the following
> error
<font face=&#34;Arial&#34; size=2>
<p>Provider</font> <font
> face=&#34;Arial&#34; size=2>error &#39;80004005&#39;</font>
<p>
<font
> face=&#34;Arial&#34; size=2>Unspecified error</font>
<p>
<font
> face=&#34;Arial&#34; size=2>/ucbbud/asp/Exptest.asp</font><font
> face=&#34;Arial&#34; size=2> line 78</font>

Remark : I am working on
> an oracle database

thanks , jos