Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XML format in field.How to extract? (vbscript/asp)

    actually i have a table AUDIT_LOG, to capture the action of user changes.
    i need to write a ASP to output a Text file (pls refer to text file output sturcture) from audit_log table.
    OLD_LOG_DATA consits xml format eg: <CUST_SEQ>11111</CUST_SEQ><NAME>DANIEL</NAME>
    NEW_LOG_DATA consits data eg: <CUST_SEQ>22222</CUST_SEQ><NAME>NICK</NAME>

    can you guide me a sample code to perform this task to extract field that have xml format
    and put in a text file which have below text file stucture? thanks

    SQL> desc audit_log;
    Name Null? Type
    ----------------------------------------------------- -------- ----------------
    LOG_SEQ_NO
    LOG_TABLE
    LOG_ACTION
    LOG_DATETIME
    OLD_LOG_DATA
    NEW_LOG_DATA


    TEXT FILE OUTPUT :
    LOG_TABLE LOG_ACTION FIELD_NAME OLD_VALUE NEW_VALUE
    CUSTOMER, C, CUST_SEQ, 11111, 22222
    CUSTOMER,C,NAME,DANIEL,NICK

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: XML format in field.How to extract? (vbscript/asp)

    Please post responses to this question in the original thread beginning at <!post=Post 125719 , 125719>Post 125719 <!/post>.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •