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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Tim McMahon Technical Services West Liberty Public Library