+----[ 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    |[EMAIL PROTECTED]| 

_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to