<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005>I answers myself:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005>"select count(*) as <whatever> from TABLE
..."</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005></SPAN></FONT><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005>works.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=標楷體 color=#0000ff size=4><SPAN
class=208081202-21082005>Iap</SPAN></FONT></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=zh-tw dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
zope3-dev-bounces+iap_yeh=thecus.com@zope.org
[mailto:zope3-dev-bounces+iap_yeh=thecus.com@zope.org] <B>On Behalf Of
</B>Iap, Singuan<BR><B>Sent:</B> Saturday, August 20, 2005 5:36
PM<BR><B>To:</B> zope3-dev@zope.org<BR><B>Subject:</B> [Zope3-dev] select
count(*) from Table<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體 size=4>I use mysqldbda, why
"select count(*) from Table" doesn't work?</FONT></SPAN></DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體 size=4>also, "select
max(id) ..." neither. only "select field1, field2, from Table"
works.</FONT></SPAN></DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體
size=4></FONT></SPAN> </DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體 size=4>Any
work-around?</FONT></SPAN></DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體
size=4></FONT></SPAN> </DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體
size=4>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體
size=4></FONT></SPAN> </DIV>
<DIV><SPAN class=706003409-20082005><FONT face=標楷體
size=4>Iap</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>