Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Formatting a written XML file....

Posted on 2007-11-20
4
Medium Priority
?
369 Views
Last Modified: 2011-10-03
Is there something I can do in classic ASP that is similar to:
xmlWriter.Formatting = Formatting.Indented

what I'm coming across is, as I write the values to the document it is coming in as:
<?xml version="1.0" encoding="utf-8"?>
<Facility_Reservations>
      <FAC_RESERVATION ID="111320070933"><FAC_ID>7</FAC_ID><FAC_RES_DATE>11/17/2010</FAC_RES_DATE><FAC_RES_AVAIL>NO</FAC_RES_AVAIL><FAC_RES_DESC>this is a test</FAC_RES_DESC></FAC_RESERVATION></Facility_Reservations>


what I need to do is make it:
<?xml version="1.0" encoding="utf-8"?>
<Facility_Reservations>
      <FAC_RESERVATION ID="111320070933">
    <FAC_ID>7</FAC_ID>
    <FAC_RES_DATE>11/17/2010</FAC_RES_DATE>
    <FAC_RES_AVAIL>NO</FAC_RES_AVAIL>
    <FAC_RES_DESC>this is a test</FAC_RES_DESC>
  </FAC_RESERVATION>
</Facility_Reservations>

xmlpath = server.MapPath("/club/scripts/Interfaces/" & tmpAccountName & ".xml")
    set objXML = CreateObject("Microsoft.FreeThreadedXMLDOM")
        objXML.async = False
        blnFileExist = objXML.load(xmlpath)
        If not(blnFileExist) Then
            'If the file does not exist, build it now
            objXML.appendChild(objXML.createProcessingInstruction("xml","version=""1.0"""))
            objXML.appendChild(objXML.createElement("RL"))
        End If
            'set our child node object
            Set objXMLv = objXML.createElement("CLUB")
                'Assign this node an ID, and give the ID a value
                objXMLv.setAttribute "ID", tmpClubID
                'Append some child nodes for the login to be stored
                objXMLv.appendChild(objXML.createElement("UID"))
                objXMLv.appendChild(objXML.createElement("UPW"))
                'after the nodes were made, we insert the information into them
                objXMLv.childNodes(0).text = tmpMemberNo
                objXMLv.childNodes(1).text = tmpPassword
                'append the nodes to the document
                objXML.documentElement.appendChild(objXMLv.cloneNode(true))
                'save the file
                objXML.save(xmlpath)
            Set objXMLv = nothing
    Set xmlObj = nothing

Open in new window

0
Comment
Question by:kevp75
  • 2
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
Ashish Patel earned 2000 total points
ID: 20319407
NO you cannot do this in classic ASP.
0
 
LVL 25

Author Comment

by:kevp75
ID: 20321421
there has to be a way.  I've seen many sites that write an XML file and upon getting it as an email attachment and openning it in Notepad it is formatted correctly...
0
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20321458
They generally put vbCRLF after a new child node is added. Anyways, i will look for more options for you to get you something you are looking by tomorrow.
0
 
LVL 25

Author Comment

by:kevp75
ID: 20358016
ya know...I believe I may have hit a wall with this.  I've searched around for a few days now, and everything points to .NET, and nothing about this for classic.

Thanks for the help...
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
Integration Management Part 2
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question