I use:
$Gdata{'custid'} = $dbh->{'mysql_insertid'};
on 3.23.38 with perl 5.6.1 and DBI-1.15
Works like a champ!
On Sat, Jun 23, 2001 at 01:07:07PM -0500, xris wrote:
> > Two things you might want to try... first download and install the newest
> > Msql-Mysql DBD drivers.. check what the documentation says in there.. and
> > second, keep changing what variable you are trying to access and maybe you
> > will find one works that isnt documented.
>
> My problem with this is that I have no control over the versioning. I'm
> using an ISP who was gracious enough to upgrade one of the servers (hosting
> our largest clients) to 3.23 because it was having a BUNCH of other
> problems.
>
> So if the {mysql_insertid} thing is an issue, is there a fix? Does the
> latest DBD/DBI package fix it? Or is it strictly a MySQL issue and just
> needs to wait for a new release?
>
> As it is, it seems that:
>
> my ($id) = $dbh->selectrow_array("SELECT MAX(id) FROM tbl;");
>
> is really my only option. And to just hope that two things won't get
> inserted at the same time...
>
> -Chris
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
