Re: [Koha-cvs] koha/C4 Members.pm [rel_2_2]

[Pierrick LE GALL]

Hi Joshua,

On Mon, 03 Apr 2006 23:43:20 +0000
Joshua Ferraro <address@hidden> wrote:

> Log message:
>       fixing a bug in the way that max is generated when finding
> the next borrowernumber. Now, using mysql 4.1 we can convert to an
> integer to get an accurate next value.

It is dangerous to find the next borrower number using the "max"
function.

Ideally we should use the autoincrement property of the column. This
solution is equivalent to having sequences (they don't exist in MySQL).

Another solution would be to find the maximum between the maximum
borrowers.borrowernumber and the maximum
deletedborrowers.borrowernumber.

Hope it helps :-)

-- 
Pierrick LE GALL
INEO media system