+----[ 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|