Re: [Koha] SQL runs outside of staff client but not inside it

2013-03-20 Thread Doug Dearden
liams Sent: Wednesday, March 20, 2013 10:19 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL runs outside of staff client but not inside it Doug: You wrote: >I am working on some SQL to get a report for last month's acquisitions, and >worked up the following code to do it: [...sn

Re: [Koha] SQL runs outside of staff client but not inside it

2013-03-20 Thread Robert Williams
Doug: You wrote: >I am working on some SQL to get a report for last month's acquisitions, and >worked up the following code to do it: [...snip...] A couple of the SQL Reports posted on the wiki have a WHERE clause that purportedly limits to the previous month. Would something like the followin

Re: [Koha] SQL runs outside of staff client but not inside it

2013-03-20 Thread Galen Charlton
Hi, On Wed, Mar 20, 2013 at 8:50 AM, Doug Dearden wrote: > The problem definitely lies in the first half of the code where I am loading > date information into variables to build the begin and end dates. If that > code is removed and actual dates entered for the BETWEEN values the report > ru

[Koha] SQL runs outside of staff client but not inside it

2013-03-20 Thread Doug Dearden
Hello all, I am working on some SQL to get a report for last month's acquisitions, and worked up the following code to do it: SELECT MONTH(CURDATE()) INTO @curmonth; SELECT MONTH(CURDATE())-1 INTO @lastmonth; SELECT YEAR(CURDATE()) INTO @reportyear; SELECT YEAR(CURDATE())-1 INTO @lastmnthyear; S