<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Multivalue Field Question</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4913.1100" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I think you need to use the NUM.VALUES ALL command
after the field name to get all of the values.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Hans.Morawa@boral.com.au
href="mailto:Hans.Morawa@boral.com.au">Morawa, Hans</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=download-list@cedarville.edu
href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 08, 2004 10:04
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Download-List] Multivalue Field
Question</DIV>
<DIV><BR></DIV><!-- Converted from text/rtf format -->
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>We</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face="Century Gothic" size=2>are trying to use</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face="Century Gothic"
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face="Century Gothic" size=2>DOWNLOAD version 7.10</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face="Century Gothic"
size=2></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au> <FONT
face="Century Gothic" size=2>to download some</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face="Century Gothic"
size=2>multivalue data but</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au> <FONT face="Century Gothic" size=2>when testing</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face="Century Gothic" size=2>the
generated file only contains the first line of the multivalue
field</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face="Century Gothic" size=2>. Example listed here</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face="Century Gothic" size=2> of the
data and download statement and output file</FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face="Century Gothic"
size=2>,</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic" size=2>LIST
GL.CATEGORY "OF" 10:56:37 09-06-04 PAGE 1</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>GL.CATEGORY </FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face="Century Gothic"
size=2> </FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face="Century Gothic" size=2>Sub
Category.............</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>OF </FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au>
<FONT face="Century Gothic"
size=2> </FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au> <FONT face="Century Gothic" size=2>Print
& Stationary</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Postage</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Telephone Fixed</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Telephone Calls</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Telephone Mobile</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Subscriptions</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Bank Charges</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Travel</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Doubt Debts</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Bad Debts W/O</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Collection Fees</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
FBT</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Cleaning</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Courier</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
PC Software</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Computer Services</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Insurance</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Entertain</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Finance Interest</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>
Staff Costs</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>02 SELECT
GL.CATEGORY WITH @ID = 'OF'</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>01 DOWNLOAD
GL.CATEGORY @ID XML.ATTRIBUTE SUB.DESC MULTI.VALUE FORMAT XML FILE
&</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>HOLD&
DOWNLOAD.XML OVERWRITING</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>DOWNLOAD
version 7.10</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Using input
file GL.CATEGORY</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>Output to file
&HOLD& DOWNLOAD.XML</FONT></SPAN></P><BR>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>1 record
processed.</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>LIST.ITEM
&HOLD& DOWNLOAD.XML 10:59:03 09-06-04 PAGE
1</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New"
size=2> DOWNLOAD.XML</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>001 <?xml
version="1.0"?></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>002
<download></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>003
<glcategory id="OF"></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>004
<subdesc>Print & Stationary</subdesc></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>005
</glcategory></FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Courier New" size=2>006
</download></FONT></SPAN></P><BR>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic" size=2>How do I get
DOWNLOAD to include all multivalues. Thanks.</FONT></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>Regards,</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-au><FONT face="Century Gothic"
size=2>Hans</FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN></P>
<P align=left><SPAN lang=en-us></SPAN><A name=""><SPAN
lang=en-us></SPAN></A></P>
<P align=left><SPAN lang=en-au></SPAN></P>
<TABLE>
<TBODY>
<TR>
<TD bgColor=#ffffff><FONT color=#000000>---<BR>This email and any files
transmitted with it are confidential to the intended recipient and may
be privileged. If you have received this email inadvertently or you are
not the intended recipient, you may not disseminate, distribute, copy or
in any way rely on it. Further, you should notify the sender immediately
and delete the email from your computer. Whilst we have taken
precautions to alert us to the presence of computer viruses, we cannot
guarantee that this email and any files transmitted with it are free
from such viruses.<BR></FONT></TD></TR></TBODY></TABLE></BLOCKQUOTE>
<DIV><FONT face="Century Gothic" size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face="Century Gothic" size=2><BR>---<BR>Outgoing mail is certified
Virus Free.<BR>Checked by AVG anti-virus system (<A
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: 6.0.701 /
Virus Database: 458 - Release Date: 06/07/2004</FONT></DIV></BODY></HTML>