[Koha-cvs] koha/C4 Members.pm

[Joshua Ferraro]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         
Changes by:     Joshua Ferraro <address@hidden> 06/04/03 23:45:00

Modified files:
        C4             : Members.pm 

Log message:
        sync with head.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/koha/C4/Members.pm.diff?tr1=1.12&tr2=1.13&r1=text&r2=text

Patches:
Index: koha/C4/Members.pm
diff -u koha/C4/Members.pm:1.12 koha/C4/Members.pm:1.13
--- koha/C4/Members.pm:1.12     Wed Oct 26 09:12:33 2005
+++ koha/C4/Members.pm  Mon Apr  3 23:45:00 2006
@@ -414,7 +414,11 @@
                
                        $cardnumber="V$cardnumber$rem";
                } else {
-                       my $sth=$dbh->prepare("select max(borrowers.cardnumber) 
from borrowers");
+                       # MODIFIED BY JF: mysql4.1 allows casting as an 
integer, which is probably
+            # better. I'll leave the original in in case it needs to be 
changed for you
+            my $sth=$dbh->prepare("select max(cast(cardnumber as signed)) from 
borrowers");
+            #my $sth=$dbh->prepare("select max(borrowers.cardnumber) from 
borrowers");
+
                        $sth->execute;
                
                        my ($result)=$sth->fetchrow;