I answers myself:
"select count(*) as <whatever> from TABLE
..."
works.
Iap
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Iap, Singuan
Sent: Saturday, August 20, 2005 5:36 PM
To: zope3-dev@zope.org
Subject: [Zope3-dev] select count(*) from TableI 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
_______________________________________________ Zope3-dev mailing list Zope3-dev@zope.org Unsub: http://mail.zope.org/mailman/options/zope3-dev/archive%40mail-archive.com