<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta content="MSHTML 6.00.6000.17104" name="GENERATOR">
<style id="owaTempEditStyle"></style><style title="owaParaStyle"><!--P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
--></style>
</head>
<body ocsi="x">
<div style="FONT-SIZE: 13px; COLOR: #000000; DIRECTION: ltr; FONT-FAMILY: Tahoma">
<div>Hi Nicole,</div>
<div><font face="tahoma" size="2"></font> </div>
<div>Thanks for the correction :)</div>
<div><font face="tahoma" size="2"></font> </div>
<div><font face="tahoma" size="2">Respectfully,</font></div>
<div><font face="tahoma" size="2"></font> </div>
<div><font face="tahoma" size="2">James Ghiorzi<a></a></font></div>
<div><font face="tahoma" size="2">Library Assistant II</font></div>
<div><font face="tahoma" size="2">San Benito County Free Library</font></div>
<div><font face="tahoma" size="2">470 Fifth St.</font></div>
<div><font face="tahoma" size="2">Hollister, CA 95023</font></div>
<div><font face="tahoma" size="2">(831) 636-4107</font></div>
<div dir="ltr"><font face="Tahoma" color="#000000" size="2"></font> </div>
<div id="divRpF619455" style="DIRECTION: ltr">
<hr tabindex="-1">
<font face="Tahoma" color="#000000" size="2"><b>From:</b> Nicole Engard [nengard@gmail.com]<br>
<b>Sent:</b> Monday, November 07, 2011 9:52 AM<br>
<b>To:</b> James Ghiorzi<br>
<b>Cc:</b> Massimo Plevani; koha@lists.katipo.co.nz<br>
<b>Subject:</b> Re: [Koha] Acquisition module<br>
</font><br>
</div>
<div></div>
<div>James,<br>
<br>
That won't do the trick - but this will:<br>
<br>
SELECT name from aqbooksellers order by name asc<br>
<br>
And you're right about not being able to delete.<br>
<br>
Nicole<br>
<br>
<div class="gmail_quote">2011/11/7 James Ghiorzi <span dir="ltr"><<a href="mailto:JGhiorzi@lib.co.san-benito.ca.us">JGhiorzi@lib.co.san-benito.ca.us</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div style="FONT-SIZE: 13px; COLOR: #000000; DIRECTION: ltr; FONT-FAMILY: Tahoma">
<div><font face="Arial" size="3">Hi Massimo,</font></div>
<div><font face="Arial" size="3"></font> </div>
<div><font face="Arial" size="3">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).</font></div>
<div><font face="Arial" size="3"></font> </div>
<div><font face="Arial" size="3">The list of vendors here is my amateurish<a></a> stab at it:</font></div>
<div><font face="Arial" size="3"></font> </div>
<div>
<pre><span><font face="Arial" size="3">SELECT <a href="http://v.name" target="_blank">v.name</a><a></a><a></a> AS vendor<br>FROM aqorders o <br>Order by <a href="http://v.name" target="_blank">v.name</a> ASC<a></a><a></a></font></span></pre>
<pre><span><font face="Arial" size="3">Hope that helps,</font></span></pre>
<pre><span><font face="Arial" size="3">James Ghiorzi<br>Library Assistant II<br>San Benito County Free Library<br>470 Fifth ST.<br>Hollister, CA 95023</font></span></pre>
<font face="Arial" size="3"> </font></div>
<div dir="ltr"><font face="Arial" color="#000000" size="3"></font> </div>
<div style="DIRECTION: ltr"><font face="Arial" size="3">
<hr>
</font><font face="Arial"><font size="3"><font color="#000000"><b>From:</b> <a href="mailto:koha-bounces@lists.katipo.co.nz">
koha-bounces@lists.katipo.co.nz</a> [<a href="mailto:koha-bounces@lists.katipo.co.nz">koha-bounces@lists.katipo.co.nz</a>] On Behalf Of Massimo Plevani [<a href="mailto:max_pleva@hotmail.it">max_pleva@hotmail.it</a>]<br>
<b>Sent:</b> Monday, November 07, 2011 8:19 AM<br>
<b>To:</b> <a href="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</a><br>
<b>Subject:</b> [Koha] Acquisition module<br>
</font><br>
</font></font></div>
<div>
<div></div>
<div class="h5">
<div><font face="Arial" size="3"></font></div>
<div>
<div dir="ltr"><font face="Arial" size="3">Dear all, </font>
<div><font face="Arial" size="3">I started to work with acquisition module. I have some questions:</font></div>
<div><font face="Arial"><br>
<font size="3"></font></font></div>
<div><font face="Arial" size="3">1. How can I delete a vendors?</font></div>
<div><font face="Arial" size="3">2. Can I see the list of vendors (e.g Alphabeticaly ordered)?</font></div>
<div><font face="Arial"><br>
<font size="3"></font></font></div>
<div><font face="Arial" size="3">Thanks you for your help. All the best.</font></div>
<div><font face="Arial"><br>
<font size="3"></font></font></div>
<div><font face="Arial" size="3">Massimo Plevani</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</body>
</html>