[Zope] MySQLDA Problems with simple constant/function queries

[Andrew Kenneth Milton]

+----[ Stefan Franke ]---------------------------------------------
[Charset iso-8859-1 unsupported, filtering to ASCII...]
| I'm using MySQLDA 1.1.3 on Win32. When I type the following queries
| into the test tab edit box, I get the traceback below:
| 
|   select LAST_INSERT_ID()
| 
| or
| 
|   select 1 from <table>

I can give you work_arounds for both cases:-

select 1 from foo as One

select CONV(LAST_INSERT_ID(),10,10) AS LAST_INSERT_ID

This last one took me a little while to work out :-)

-- 
Totally Holistic Enterprises Internet|  P:+61 7 3870 0066   | Andrew Milton
The Internet (Aust) Pty Ltd          |  F:+61 7 3870 4477   | 
ACN: 082 081 472                     |  M:+61 416 022 411   | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068    |akm@theinternet.com.au|