[Koha] Patron's barcode

[Tim McMahon]

Try putting a double or single quote around your barcode numbers.  It's 
probably stripping the leading zero off and searching for 2300 and 2310 
instead of 02300 and 02310.

ils rehoboth wrote:
> Hi all,
> I have been struggling to come up with an sql query that can generate 
> patrons barcode from koha (i am using 3.0. ) using kbarcode.
> I have come up with the following sql query but it seems it is not 
> working. Can somebody correct my sql statement:
> 
> *SELECT* borrowers.surname, borrowers.firstname, borrowers.cardnumber as 
> barcode *FROM* borrowers
> *WHERE* borrowers.cardnumber >=02300 and borrowers.cardnumber <=02310;  
> (NB: 02300 and 02310 represent the range of patrons' barcodes to be 
> generated)
> 
> 
> 
> Your input is highly appreciated.
> 
> 
>  
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Tim McMahon
Technical Services
West Liberty Public Library