[Koha-cvs] CVS: koha/C4/Circulation Circ2.pm,1.70,1.71

[Paul POULAIN]

Update of /cvsroot/koha/koha/C4/Circulation
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4402/C4/Circulation

Modified Files:
	Circ2.pm 
Log Message:
renaming items.bulk field to items.itemcallnumber.
Will be used to store call number for libraries that don't use dewey classification.
Note it's related to ITEMS, not biblio.

Index: Circ2.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Circulation/Circ2.pm,v
retrieving revision 1.70
retrieving revision 1.71
diff -C2 -r1.70 -r1.71
*** Circ2.pm	24 Mar 2004 21:06:48 -0000	1.70
--- Circ2.pm	2 Apr 2004 14:55:47 -0000	1.71
***************
*** 88,92 ****
  	my ($minlocation,$maxlocation,$datelastseen,$offset,$size) = @_;
  	my $dbh = C4::Context->dbh;
! 	my $sth = $dbh->prepare("select itemnumber,barcode,bulk,title,author from items,biblio where items.biblionumber=biblio.biblionumber and bulk>= ? and bulk <=? and (datelastseen< ? or datelastseen is null) order by bulk,title");
  	$sth->execute($minlocation,$maxlocation,$datelastseen);
  	my @results;
--- 88,92 ----
  	my ($minlocation,$maxlocation,$datelastseen,$offset,$size) = @_;
  	my $dbh = C4::Context->dbh;
! 	my $sth = $dbh->prepare("select itemnumber,barcode,itemcallnumber,title,author from items,biblio where items.biblionumber=biblio.biblionumber and itemcallnumber>= ? and itemcallnumber <=? and (datelastseen< ? or datelastseen is null) order by itemcallnumber,title");
  	$sth->execute($minlocation,$maxlocation,$datelastseen);
  	my @results;