472,344 Members | 2,478 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,344 software developers and data experts.

asp and XML help!

im trying to add a new customer record to my XML file using ASP. im getting the corrrect information into my xml file however my XML tree struction isnt what it should be..let me explain.

below is a sample of my customers.xml file notice the structure

Expand|Select|Wrap|Line Numbers
  1.   <customers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="customers.xsd">
  2.     <customer customerNumber="BL343456">
  3.         <meterNumber>134456</meterNumber>
  4.         <name title="">
  5.             <firstName></firstName>
  6.             <lastName></lastName>
  7.         </name>
  8.         <address>
  9.             <streetNumber></streetNumber>
  10.             <streetName></streetName>
  11.             <suburb></suburb>
  12.             <pCode></pCode>
  13.         </address> 
  14.            </customer>
  15.  
  16.  
when i obtain the information from the form and write to the xml file the following structure is the result

Expand|Select|Wrap|Line Numbers
  1.   <customer customerNumber="">
  2.             <meterNumber/>
  3.             <name title="">
  4.                     <firstName/>
  5.                     <lastName/>
  6.          <address>
  7.                  <streetNumber/>
  8.                  <streetName/>
  9.                  <suburb/>
  10.                 <pCode/>
  11.              </address>
  12.           </name>
  13.        </customer> 
notice that my address root is within root element of name...im not sure how to close the name root and start my address root element

here is a portion of my asp code

Expand|Select|Wrap|Line Numbers
  1.     Set xmlRoot = xmlFile.DocumentElement
  2.  
  3.     ' Create new customer and Customer ID node
  4.     Set xmlNode = xmlFile.CreateElement( "customer" )
  5.     Call xmlNode.SetAttribute("customerNumber", custNum)
  6.     Call xmlRoot.AppendChild( xmlNode )
  7.  
  8.     Set xmlRoot = xmlNode
  9.  
  10.     'Create meter number node.
  11.     Set xmlNode = xmlFile.CreateElement( "meterNumber" )
  12.     xmlNode.Text = metNumber
  13.     Call xmlRoot.AppendChild( xmlNode )
  14.  
  15.     'create the name node and title attribute
  16.     Set xmlNode = xmlFile.CreateElement( "name" )
  17.     Call xmlNode.SetAttribute("title", title)
  18.     Call xmlRoot.AppendChild( xmlNode )
  19.  
  20.     'set the name element to the root element for the following 
  21.     Set xmlRoot = xmlNode
  22.  
  23.    'create firstname.
  24.     Set xmlNode = xmlFile.CreateElement( "firstName" )
  25.     xmlNode.Text = fName
  26.     Call xmlRoot.AppendChild( xmlNode )
  27.  
  28.     'create surname (lastname)
  29.     Set xmlNode = xmlFile.CreateElement( "lastName" )
  30.     xmlNode.Text = surName
  31.     Call xmlRoot.AppendChild( xmlNode )
  32.  
  33.     Set xmlNode = xmlFile.CreateElement( "address" )
  34.     Call xmlRoot.AppendChild( xmlNode )
  35.     Set xmlRoot = xmlNode 
May 28 '07 #1
0 869

Sign in to post your reply or Sign up for a free account.

Similar topics

21
by: Dave | last post by:
After following Microsofts admonition to reformat my system before doing a final compilation of my app I got many warnings/errors upon compiling an...
9
by: Tom | last post by:
A question for gui application programmers. . . I 've got some GUI programs, written in Python/wxPython, and I've got a help button and a help menu...
6
by: wukexin | last post by:
Help me, good men. I find mang books that introduce bit "mang header files",they talk too bit,in fact it is my too fool, I don't learn it, I have...
3
by: Colin J. Williams | last post by:
Python advertises some basic service: C:\Python24>python Python 2.4.1 (#65, Mar 30 2005, 09:13:57) on win32 Type "help", "copyright",...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting...
5
by: Steve | last post by:
I have written a help file (chm) for a DLL and referenced it using Help.ShowHelp My expectation is that a developer using my DLL would be able to...
8
by: Mark | last post by:
I have loaded Visual Studio .net on my home computer and my laptop, but my home computer has an abbreviated help screen not 2% of the help on my...
10
by: JonathanOrlev | last post by:
Hello everybody, I wrote this comment in another message of mine, but decided to post it again as a standalone message. I think that...
1
by: trunxnirvana007 | last post by:
'UPGRADE_WARNING: Array has a new behavior. Click for more:...
0
by: hitencontractor | last post by:
I am working on .NET Version 2003 making an SDI application that calls MS Excel 2003. I added a menu item called "MyApp Help" in the end of the menu...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.