Re: $dbh->{"mysql_insertid"} always returns 0

am 18.03.2003 10:58:59 von Mike Blezien

are you calling the $dbh database handle after calling a DBI statement
handle($sth) or a database handle($dbh), IE $dbh->do(), then call the
$dbh->{'mysql_insertid'} ??

>> Michael.Renardus@atosorigin.com wrote:
> On a new Solaris 8.0 installation
> using MySQL 3.23.55 and Perl 5.6.1
> with Perl modules DBI 1.32 and Msql-Mysql-modules-1.2219
> the statement
> $sth->{'mysql_insertid'} returns a correct value, but
> $dbh->{'mysql_insertid'} always return a zero.
>
> Does anyone have a clue what is going on?

--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(985)902-8484
MSN: mickalo@bellsouth.net
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2095@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: $dbh->{"mysql_insertid"} always returns 0

am 18.03.2003 10:58:59 von Mike Blezien

$dbh->{"mysql_insertid"} always returns 0

am 18.03.2003 15:48:46 von Michael.Renardus

On a new Solaris 8.0 installation
using MySQL 3.23.55 and Perl 5.6.1
with Perl modules DBI 1.32 and Msql-Mysql-modules-1.2219
the statement
$sth->{'mysql_insertid'} returns a correct value, but
$dbh->{'mysql_insertid'} always return a zero.

Does anyone have a clue what is going on?

Thanks in advance,
Michael

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2094@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: $dbh->{"mysql_insertid"} always returns 0

am 19.03.2003 08:59:45 von Jochen Wiedmann

Zitiere Michael.Renardus@atosorigin.com:

> On a new Solaris 8.0 installation
> using MySQL 3.23.55 and Perl 5.6.1
> with Perl modules DBI 1.32 and Msql-Mysql-modules-1.2219
> the statement
> $sth->{'mysql_insertid'} returns a correct value, but
> $dbh->{'mysql_insertid'} always return a zero.

Please try whether the problem persists in DBD-mysql 2.1026.

thanks,

Jochen

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2097@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: $dbh->{"mysql_insertid"} always returns 0

am 19.03.2003 08:59:45 von Jochen Wiedmann

RE: $dbh->{"mysql_insertid"} always returns 0

am 19.03.2003 10:57:23 von Michael.Renardus

>Zitiere Michael.Renardus@atosorigin.com:
>
>> On a new Solaris 8.0 installation
>> using MySQL 3.23.55 and Perl 5.6.1
>> with Perl modules DBI 1.32 and Msql-Mysql-modules-1.2219
>> the statement
>> $sth->{'mysql_insertid'} returns a correct value, but
>> $dbh->{'mysql_insertid'} always return a zero.
>
>Please try whether the problem persists in DBD-mysql 2.1026.
Jochen Wiedmann,

Thank you that was the problem; I used an older version and
assumed that the Msql-Mysql-modules contained all of the DBD-stuff I need.

Michael Renardus

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2098@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

RE: $dbh->{"mysql_insertid"} always returns 0

am 19.03.2003 10:57:23 von Michael.Renardus