Chris Cormack wrote:
On Sun, Mar 31, 2002 at 12:49:54PM +1200, Chris Cormack said:
On Sun, Mar 31, 2002 at 10:42:32AM +1000, Roger Buck said:
Yes it does make sense... but when I enter stuff here, nothin shows - in Bilio Record, Total number of items always = 0
Another addbooks.pl problem?
I just sent a message to you off list about this.
Its actually to do with ItemInfo which is in Search.pm which is called by detail.pl.
ItemInfo depends on some data in the branch table. I think this is whats breaking it.
Can you do a select * from branches and the same for biblio, biblioitems and items please?
Ahh ha,
I think it is the branches, in addbooks.pl when you get the 3rd screen to add the barcode. It gives you a list of branches.
These appear to be hardcoded into the script, they should be drawn from the database, since you are now adding a book, to a branch that doesnt exist in your database. Then when you get to detail.pl it cant find the branch the book says it belongs to so cant display it.
to test my theory, you could do a update items set holdingbranch='C';
Then detail.pl should be working. Meanwhile ill go get addbooks to pull the branch list from the db
Yes - This works! R.