Re: [Koha] Patron's barcode

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.