[Zope] ZMySQLDA and aggregate functions on Win

2001-01-12 Thread Dave Woolston
select count(*) from show group by article; ERROR 1064: You have an error in your SQL syntax near 'show group by article' at line 1 Sorry if I misunderstand what you are trying to do - = Dave Woolston [EMAIL PROTECTED] Digital Creations www.digicool.com (716) 262

RE: [Zope] Zope is not getting MySQL SELECT results ...

2001-01-24 Thread Dave Woolston
test.test' doesn't exist As you can see - you would get the result you described if you did not have a table defined. HTH ===== Dave Woolston [EMAIL PROTECTED] Digital Creations www.digicool.com (716) 262-4715 ___