[Koha] Patron's barcode

ils rehoboth rehoboth_ils at yahoo.com
Thu Jan 28 19:16:27 NZDT 2010


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: 
SELECTborrowers.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.


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100127/598980a6/attachment.htm 


More information about the Koha mailing list