Hi Nicole,

Thanks for the correction :)

Respectfully,

James Ghiorzi
Library Assistant II
San Benito County Free Library
470 Fifth St.
Hollister, CA 95023
(831) 636-4107

________________________________
From: Nicole Engard [[email protected]]
Sent: Monday, November 07, 2011 9:52 AM
To: James Ghiorzi
Cc: Massimo Plevani; [email protected]
Subject: Re: [Koha] Acquisition module

James,

That won't do the trick - but this will:

SELECT name from aqbooksellers order by name asc

And you're right about not being able to delete.

Nicole

2011/11/7 James Ghiorzi 
<[email protected]<mailto:[email protected]>>
Hi Massimo,

I believe that there is currently no way to delete a vendor using the client 
interface (there might be a way using SQL, but I wouldn't know how to do it).

The list of vendors here is my amateurish stab at it:


SELECT v.name<http://v.name> AS vendor
FROM aqorders o
Order by v.name<http://v.name> ASC

Hope that helps,

James Ghiorzi
Library Assistant II
San Benito County Free Library
470 Fifth ST.
Hollister, CA 95023



________________________________
From: [email protected]<mailto:[email protected]> 
[[email protected]<mailto:[email protected]>] On 
Behalf Of Massimo Plevani [[email protected]<mailto:[email protected]>]
Sent: Monday, November 07, 2011 8:19 AM
To: [email protected]<mailto:[email protected]>
Subject: [Koha] Acquisition module

Dear all,
I started to work with acquisition module. I have some questions:

1. How can I delete a vendors?
2. Can I see the list of vendors (e.g Alphabeticaly ordered)?

Thanks you for your help. All the best.

Massimo Plevani

_______________________________________________
Koha mailing list  http://koha-community.org
[email protected]<mailto:[email protected]>
http://lists.katipo.co.nz/mailman/listinfo/koha


_______________________________________________
Koha mailing list  http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to