At 12:45 PM +0200 6/1/1999, Matthias Pigulla wrote:
>I'm currently facing a little problem with the C API's mysql_insert_id()
>function. I'll have to check it a bit more thoroughly, but right now it
>seems to me as if
>- it would return the correct auto_incremented value after an INSERT,
>- but after performing a second INSERT into another table with the use
>of LAST_INSERT_ID() funcion in the query itself, it returns 0,
>although no new auto_incrementing table hat been touched.
>Am I doing sth wrong, is this the intended behaviour? The manual says
>"returns the id that was most recently generated", so I expected the
>value to remain visible.
Yes, it should remain visible. The 0 return should happen only if you
haven't generated an AUTO_INCREMENT value during the course of the
connection yet. Are you performing both INSERTs during the same connection,
or have you perhaps disconnected and reconnected?
>BTW, I am using a 3.22.22 client with a 3.22.16gamma (remote) server. If
>you find it necessary (and it's not a problem on my side), I'll post
>some code to check this out.
> w e b f a c t o r y | matthias pigulla
> www.webfactory.de mp@stripped
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/