On Wednesday 16 January 2002 07:28, Hamlin Nicholas-qa568 wrote:
> Easier yet, when using DBI::mysql, is:
>
> my $IncrementedID = $dbh->{'mysql_insertid'};
>
>
> When executed after the INSERT command.Does this now work with 64-bit auto-increment fields now in DBI? As of less than a year ago, DBI would incorrectly truncate the result to 32-bits and we had to use the SELECT LAST_INSERT_ID() method instead. A real pain to track down all the code that used the old method :-( We prefix some of our IDs with server IDs and when we tried a server with a number so high that the ID was outside the range of 2^32, we got garbage :-( Best, Kyle -- Cut costs, Fax smart. Use iPrint2Fax worldwide and save! - iPrint2Fax software is FREE, no fax modem required. - FREE iPrint2Fax to a single email address. - iPrint2Fax to PSTN based Fax (Up to 95% Savings) - iPrint2Fax Broadcasting: Send 100s of faxes and fax to emails in the time it takes to send just one! ========================================== FREE software download available at www.iPrint2Fax.com ========================================== --------------------------------------------------------------------- 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
