?
Solved

Formatting a written XML file....

Posted on 2007-11-20
4
Medium Priority
?
376 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

599 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