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!!!!

Need to download code?

Navigation