What I am trying to accomplish is, I have xml data that I am getting from UPS, what I need to do is save the data to an access database. I would like to be able to select specific nodes that I need to save. Any suggestions would be great. Thanks in advance
mattglet
6:52 pm on Feb 10, 2004 (gmt 0)
do you need to save it before the user sees it, or after?
-Matt
RyanPatrick
7:12 pm on Feb 10, 2004 (gmt 0)
Actually it never needs to be displayed to the screen. It just needs to dump directly into the database.
RyanPatrick
7:22 pm on Feb 10, 2004 (gmt 0)
I guess I should also add that I do not need to dump all the xml nodes to the database. Ideally I would like to pick and choose if you will, which nodes I want.
mattglet
1:56 pm on Feb 11, 2004 (gmt 0)
I use XSL to display my data to the user (while keeping it in hidden form fields). When a user is ready to checkout, the data in the hidden fields gets saved in the database. I'm not entirely sure how to parse the data without XSL, but I'm sure it's not that difficult. If you are using ASP, I think there's some tutorials at 4guysfromrolla on how to do it. Sorry I can't be of more help.
-Matt
RyanPatrick
2:09 pm on Feb 11, 2004 (gmt 0)
Thanks for the info and your time.
TheNige
10:47 pm on Feb 11, 2004 (gmt 0)
When you get the XML data from UPS, parse it using the XML DOM object. There are a few of them to choose from depending on what version of windows you have and other software that has been loaded on the server.
Look on the web for help with XMLDOM. With this object you can load the XML and then access the specific nodes that you need and then store them in your database.
