On Wed, 2002-02-20 at 15:00, Adam Thick wrote:
haven't got any problems with the scripts themselves, so no, don't have anything in the apache logs... thought it might have more to do with the database, extracted some of the SQL from the Search.pm.
This one works fine, nice and simple :
"Select * from biblio where ((title like 'adam%' or title like '% adam%')) or ((author like 'adam%' or author like '% adam%')) or ((seriestitle like 'adam%' or seriestitle like '% adam%')) or ((notes like 'adam%' or notes like '% adam%')) order by title limit 0,10"
Get no results from this query though. There's no data in some of these tables. I was wondering whether all data gets entered using the simple Acquistions page? Or is there extra data that I need to enter?
"Select * from biblio,bibliosubtitle,biblioitems where biblio.biblionumber=biblioitems.biblionumber and biblio.biblionumber=bibliosubtitle.biblionumber and (((title like 'adam%' or title like '% adam%')) or ((subtitle like 'adam%' or subtitle like '% adam%')) or ((seriestitle like 'adam%' or seriestitle like '% adam%')) or ((biblio.notes like 'adam%' or biblio.notes like '% adam%')) or ((biblioitems.notes like 'adam%' or biblioitems.notes like '% adam%'))) group by biblio.biblionumber"
This is a title search eh? The second one is the loose search .. i suspect is a bit broken. Well at the moment it depends on the there being data in the bibliosubtitle table. Which may not be being entered by simple acquisitions .. which is a fair call because if a book doesnt have a subtitle there is no reason to be put a blank entry in the bibliosubtitle table really. Ive reworked the query to use a left join instead. If you do a cvs update u should get the new version. Also ive been playing with keyword search to speed it up. It uses Set::Scalar now .. it is faster .. but im not sure i like it. But if you want to play with it ull need Set::Scalar installed as well. If not, rename KeywordSearch to KeywordSearch2 and KeywordSearch2 to KeywordSearch and u'll be back to status quo. Hope this helps Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz