Dear Vimal ji, Please add WHERE date(issues.issuedate) BETWEEN '2011-02-08' AND '2011-02-09' line in your sql query and generate with date limit
SELECT issues.issuedate,items.barcode,biblio.title, author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON issues.itemnumber=items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber WHERE date(issues.issuedate) BETWEEN '2011-02-08' AND '2011-02-09' ORDER BY issues.issuedate Thanks & Regards, Nikunj Tyagi, DPL On Tue, Apr 19, 2011 at 6:31 PM, <[email protected]> wrote: > Send Koha mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Authorities (martin caris) > 2. Ashik Rajbhandari invited you to Dropbox (Dropbox) > 3. Koha behind proxy server (schwitzd) > 4. Re: Accents in Irish Gaelic (Peter Lorimer) > 5. Circulation report limited with date (Vimal Kumar) > 6. Re: Accents in Irish Gaelic (Elaine Bradtke) > 7. Koha move to 3.4 (Linda Culberson) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 19 Apr 2011 02:44:47 +0200 > From: martin caris <[email protected]> > Subject: [Koha] Authorities > To: <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > > Hello, > > I have a problem with my authorities: I catalog my book in the framework > and I save my bibliographic record, but when I see my authority record, no > authorities are linked. How is it possible? > Koha version: 3.02.05. > > Another question: is it possible to create, in the field 952 (copy field), > my own subfields? > > Thank you. > > Martin Caris > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/75a68774/attachment-0001.htm > > ------------------------------ > > Message: 2 > Date: Tue, 19 Apr 2011 06:35:04 +0000 > From: Dropbox <[email protected]> > Subject: [Koha] Ashik Rajbhandari invited you to Dropbox > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf8" > > Ashik Rajbhandari wants you to try Dropbox! Dropbox lets you bring all your > photos, docs and videos with you anywhere and share them easily. > > Get started here: > http://www.dropbox.com/link/20.RvaCvlwouf/Njg2OTA3MjI1Nw?src=referrals_bulk9 > > - The Dropbox Team > > ____________________________________________________ > To stop receiving invites from Dropbox, please go to > http://www.dropbox.com/bl/0d4e454ad162/koha%40lists.katipo.co.nz > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/78040caa/attachment-0001.htm > > ------------------------------ > > Message: 3 > Date: Tue, 19 Apr 2011 00:16:26 -0700 (PDT) > From: schwitzd <[email protected]> > Subject: [Koha] Koha behind proxy server > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > Hello > > I'm trying to using koha behind a proxy server, but I'm not able to contact > the server using the z39.50 protocol. How I have to configure koha to works > with the proxy? > I have to enable something on the proxy server? > > Thanks a lot > Daniel > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Koha-behind-proxy-server-tp4312674p4312674.html > Sent from the Koha - Discuss mailing list archive at Nabble.com. > > > ------------------------------ > > Message: 4 > Date: Tue, 19 Apr 2011 09:10:03 +0100 > From: Peter Lorimer <[email protected]> > Subject: Re: [Koha] Accents in Irish Gaelic > To: [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset="UTF-8" > > Hi > > I had a similar problem with Irish characters not displaying correctly. > It was down to browser default character encoding. > > I overcome this by using the Perl 'Encode' module > > # use Encode; > > Where print $x was displaying Irish characters incorrectly, using > > print encode('utf-8',$x); renders Irish characters correctly. So each > time a variable (string) is added to a template I use: > > $template->param ( > testData => encode('utf-8', $data), > > ); > > -- > Kind Regards > > Peter Lorimer > Software Engineer > OSLO (Open Source ILS Systems) > > > -----Original Message----- > From: [email protected] > Reply-to: [email protected] > To: [email protected] > Subject: Koha Digest, Vol 66, Issue 42 > Date: Tue, 19 Apr 2011 07:11:04 +1200 > > Re: Accents in Irish Gaelic > > > > ------------------------------ > > Message: 5 > Date: Tue, 19 Apr 2011 17:52:27 +0530 > From: Vimal Kumar <[email protected]> > Subject: [Koha] Circulation report limited with date > To: Koha-List <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > Dear Friends, > I could generate the current checkouts with following SQL query: > > SELECT issues.issuedate,items.barcode,biblio.title, > author,borrowers.firstname,borrowers.surname FROM issues LEFT JOIN > borrowers > ON borrowers.borrowernumber=issues.borrowernumber LEFT JOIN items ON > issues.itemnumber=items.itemnumber LEFT JOIN biblio ON > items.biblionumber=biblio.biblionumber ORDER BY issues.issuedate > > Please help me to generate the same as per date limit. For example: I need > to generate report of current checkouts as of 29th March 2011. How shall I > modify the query so that I can get the report limited with date. > > With best regards > > > -- > Vimal Kumar V. > Mahatma Gandhi University Library > Kottayam, Kerala- 686 560 > Web: http://www.vimalkumar.co.nr > Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com > --------------------------------------------------------------------------- > "I forget what I was taught. I only remember what I have learnt" > -Patrick White > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://lists.katipo.co.nz/pipermail/koha/attachments/20110419/452a0f56/attachment-0001.htm > > ------------------------------ > > Message: 6 > Date: Tue, 19 Apr 2011 13:53:26 +0100 > From: Elaine Bradtke <[email protected]> > Subject: Re: [Koha] Accents in Irish Gaelic > Cc: koha <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1 > > We had a bit of gremlin trouble over the weekend. This included > trouble with z39.50 searches returning no results, even for items that > I knew were there. By the time I got around to looking at everything > again, the problems had all resolved. Accents are appearing as they > should, z39.50 searches are returning results. Phew. > Thanks everyone for your help! > Elaine > > On Mon, Apr 18, 2011 at 3:03 PM, Galen Charlton <[email protected]> > wrote: > > Hi Elaine, > > > > On Apr 18, 2011, at 9:23 AM, Elaine Bradtke wrote: > >> We've checked the settings, and they are now correct according to the > >> wiki. ?However, the Gaelic is still not downloading correctly. ?I've > >> experimented with several settings in our targets, MARC8 seems the > >> best but it's not perfect. ?I still get 'h' appearing before accented > >> letters. ?Any other thoughts? > > > > Could you give us an example of a Z39.50 target and record that you're > experiencing this problem with? > > > > Regards, > > > > Galen > > -- > > Galen Charlton > > VP, Data Services > > Equinox Software, Inc. / Your Library's Guide to Open Source > > email: [email protected] > > direct: +1 352-215-7548 > > skype: ?gmcharlt > > web: ? ?http://www.esilibrary.com/ > > > > > > > > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel? ? +44 (0) 20 7485 2206 ext 36 > -------------------------------------------------------------------------- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --------------------------------------------------------------------------- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) > > > ------------------------------ > > Message: 7 > Date: Tue, 19 Apr 2011 08:01:18 -0500 > From: Linda Culberson <[email protected]> > Subject: [Koha] Koha move to 3.4 > To: koha <[email protected]>, > [email protected] > Message-ID: <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > All, > How is the recommended way to move to the upcoming 3.4? We were > thinking of having two instances. One with our current 3.02.02.003 and > one with 3.4. Is that a good way to do it or should we upgrade to 3.2.7 > and go from there? > > Can we move our data or is it better to do a fresh load? How different > is the database in 3.4? > > Your advice to this newbie is greatly appreciated. > > -- > Linda Culberson [email protected] > Archives and Records Services Division > Ms. Dept. of Archives & History > P. O. Box 571 > Jackson, MS 39205-0571 > Telephone: 601/576-6873 > Facsimile: 601/576-6824 > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 66, Issue 44 > ************************************ >
_______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
