[Zope] database functions & zope

Stephen Nosal stephennosal@e3mil.com
8 Aug 2000 12:13:50 -0700


Bob -

That did it! Thanks for the quick help and explanation.

- Steve

On Tue, 08 August 2000, Bob Tierney wrote:

> 
> 
> One of the requirements of a DA is to return information about the result
> set columns.  Does Sybase give a name to column "count(*)".  Some database
> products do and some don't.  Try giving the column an alias name like so
> 
> select count(*) as total from db_table
> 
> assuming Sybase supports this of course.
> 
> Regards,
> 
> Bob
> 
> 
> 
> --------------------------------------------------------------
> Robert E. Tierney                    bob.tierney@goingv.com
> Going Virtual                        http://www.goingv.com
> 10800 Independence Pointe Pkwy      Phone: 1-704-849-0731 x109
> Matthews, NC 28105                    Fax: 1-704-849-2279
>                                    AOL-IM: RETierney
> --------------------------------------------------------------
> 
> On 8 Aug 2000, Stephen Nosal wrote:
> 
> > Folks -
> > 
> > How do I execute SQL statements such as select count(*) from db_table?
> > 
> > I'm running zope 2.2 with the SybaseDA 2.0b2. My connection to the database works fine, ie select * from small_table where amount>1000 produces a valid result set.
> > 
> > Using just the DA connection test, the statement select count(*) from db_table comes up with the error:
> > 
> > Error Type: ValueError
> > Error Value: Empty column name,
> > 
> > Any insight here would be great - I couldn't find anything documented about database functions.
> > 
> > - Steve
> > 
> > 
> > __________________________________________________________________
> > Get your Private, Anti-Spam, Free Email at http://e3mil.com 
> > and Step into a Friendly Universe!
> > 
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists - 
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
> > 
> > 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )


__________________________________________________________________
Get your Private, Anti-Spam, Free Email at http://e3mil.com 
and Step into a Friendly Universe!