[Download-List] Multivalue Field Question

[Linda Miller]

Multivalue Field QuestionI think you need to use the NUM.VALUES ALL command after the field name to get all of the values.
  ----- Original Message ----- 
  From: Morawa, Hans 
  To: download-list at cedarville.edu 
  Sent: Tuesday, June 08, 2004 10:04 PM
  Subject: [Download-List] Multivalue Field Question


  We are trying to use DOWNLOAD version 7.10 to download some multivalue data but when testing the generated file only contains the first line of the multivalue field. Example listed here of the data and download statement and output file,

  LIST GL.CATEGORY "OF" 10:56:37  09-06-04  PAGE 1

  GL.CATEGORY                      Sub Category.............

  OF                               Print & Stationary

                                                Postage

                                                Telephone Fixed

                                                Telephone Calls

                                                Telephone Mobile

                                                Subscriptions

                                                Bank Charges

                                                Travel

                                                Doubt Debts

                                                Bad Debts W/O

                                                Collection Fees

                                                FBT

                                                Cleaning

                                                Courier

                                                PC Software

                                                Computer Services

                                                Insurance

                                                Entertain

                                                Finance Interest

                                                Staff Costs

  02 SELECT GL.CATEGORY WITH @ID = 'OF'

  01 DOWNLOAD GL.CATEGORY @ID XML.ATTRIBUTE SUB.DESC MULTI.VALUE FORMAT XML FILE &

  HOLD& DOWNLOAD.XML OVERWRITING

  DOWNLOAD version 7.10

  Using input file GL.CATEGORY

  Output to file &HOLD& DOWNLOAD.XML



  1 record processed.

  LIST.ITEM &HOLD& DOWNLOAD.XML 10:59:03  09-06-04  PAGE 1

      DOWNLOAD.XML

  001 <?xml version="1.0"?>

  002 <download>

  003 <glcategory id="OF">

  004   <subdesc>Print & Stationary</subdesc>

  005 </glcategory>

  006 </download>



  How do I get DOWNLOAD to include all multivalues. Thanks.

  Regards,

  Hans



        ---
        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.
       




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.701 / Virus Database: 458 - Release Date: 06/07/2004
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20040609/c321e042/attachment.html>