[Zope3-dev] select count(*) from Table

[Iap, Singuan]

I answers myself:
 
"select count(*) as <whatever> from TABLE ..."
 
works.
 
Iap


  _____  

From: zope3-dev-bounces+iap_yeh=thecus.com at zope.org [mailto:zope3-dev-bounces+iap_yeh=thecus.com at zope.org] On Behalf Of Iap, Singuan
Sent: Saturday, August 20, 2005 5:36 PM
To: zope3-dev at zope.org
Subject: [Zope3-dev] select count(*) from Table


I use mysqldbda, why "select count(*) from Table" doesn't work?
also, "select max(id) ..." neither. only "select field1, field2, from Table" works.
 
Any work-around?
 
Regards,
 
Iap

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope3-dev/attachments/20050821/375824d0/attachment.htm