[Koha-devel] Re: little question

[paul POULAIN]

Silvia H M wrote:

> Hi Paul,
>  
> I would like to know which field of what table from the database in koha
> stores the number (amount) of items of a same book?
> I mean, for example If I have 3 books with the same title, author, 
> isbn, etc.
> where should I look it for?
>  
> Regards,
>  
> Silvia Hernandez

Hi Silvia,
1st of all, you should ask this on koha-devel ml, the answer may be 
instersting for other.
2nd, you should avoid "little question" in the title. As I don't know 
you, it's exactly the kind of mail that is junk/spam and goes directly 
to trash.

Anyway, the answer is :
The number of item is stored nowhere.
You can find it with a small sql request : select count(*) from items 
where biblionumber=? (or isbn=?, or title=? and author=?, or ...)

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20030521/e3678313/attachment-0002.htm>