[Koha-cvs] koha/C4 Members.pm

[Joshua Ferraro]

CVSROOT:	/sources/koha
Module name:	koha
Branch: 	
Changes by:	Joshua Ferraro <kados at savannah.gnu.org>	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;