allrighty, for you perl/mysql folks here is the trouble I'm having.
I'm tyring to do a transaction in mysql/innodb in perl with the following
basic flow
eval{
Insert my first record
get the insert_id
(using $sth->{mysql_insert_id})
now perform other inserts that need that key
commit;
};
if($@)
{
rollback;
and other logic
}
the only problem is the {mysql_insert_id} doesn't give me anything back.
NADA...
Is this a bug only in transactions or innodb? since I know the function is
working in autocommit / MyIsam tables.
Do I have to do the select last_insert_id ? Because that IS working (and
consequently what I am doing now).
using .43 on linux RH7.1 compiled from source
--
Jayce^
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
