Text String to XML

testsubject · #1 (**permalink**) November 23rd, 2006, 08:23 AM

Hi folks,

The problem I have got is.....A user input some string i.e. "sp_list, anne, cook"

Format being <stored procedure name>, <parm1>, <parm2>.

Then they click submit and I need to be able to parse this into an xml document.

Anyone got any ideas?

Thanks

testsubject · #2 (**permalink**) November 27th, 2006, 06:26 AM

I have got the program to accept an xml string into a text box. It then takes the string and puts it into an xml document.

Code:

<API_REQUEST>
<NAME>SP_TEST</NAME>
<PARAMETERS>
<param1>1</param1>
<param2>2</param2>
<param3>3</param3>
</PARAMETERS>
</API_REQUEST>

Above is what the XML document looks like.

Now what I need to do is to read through the document and pull out the NAME, and ParamX. I can pull out the NAME without a problem, but I need to be able to loop through the PARAMETERS and pull out all the different parameters and create a varible for each paramter. Unfortunately the amount of parameters is going to change.

If anyone has got any ideas or code snippets that would be great.

Thanks!!!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Parsing from a text string	jroxit	Classic ASP Basics	5	November 18th, 2008 05:08 PM
Creating XML doc ; writing string(xml format) into	KamalRaturi	XML	5	May 28th, 2008 05:51 AM
Text String to XML	testsubject	XML	1	November 26th, 2006 06:50 PM
Parsing a text string	medix_911	Access	8	November 21st, 2006 01:37 PM
Finding a string in the text	muki	XSLT	5	November 15th, 2005 11:20 PM