Re: [Koha] Help with sql statement.

2012-06-11 Thread Nicole Engard
This should work: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between Date between (-mm-dd) AND and (-mm-dd) and b.code = Pick your branch|branches GROUP BY c.code ___ Koha mailing list http://koha-community.org

Re: [Koha] Unable to update form

2012-06-11 Thread Zeno Tajoli
Hi Stew, Il 10/06/2012 13:03, Stew Wilson ha scritto: I tried editing my own MARC framework. This worked well, until I accidentally deleted a tag that I wanted to keep. which tag do you deleted ? Bye Zeno Tajoli -- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520

Re: [Koha] OPAC User Can Not Login to Koha

2012-06-11 Thread Andi Sugandi
Hi Mason, On Mon, Jun 11, 2012 at 5:44 PM, Mason James m...@kohaaloha.com wrote: load a dump from your working local Koha, into your borked VDS Koha... does it work? Unfortunately no, it doesn't. The issue still remains: http://goo.gl/AEo13 (screenshot) ... Software error: Can't use an

Re: [Koha] Help with sql statement.

2012-06-11 Thread James Ghiorzi
Hi Jared, Thanks for responding on a weekend :). I changed the statement to: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between Date between (-mm-dd) AND DATE(dateenrolled) and (-mm-dd) and b.codePick your branch|branches GROUP BY c.code but its still

Re: [Koha] Help with sql statement.

2012-06-11 Thread Nicole Engard
This should work: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between Date between (-mm-dd) AND and (-mm-dd) and b.code = Pick your branch|branches GROUP BY c.code On Sat, Jun 9, 2012 at 7:55 PM, Jared Camins-Esakov jcam...@cpbibliography.com wrote: