Writing xml to SQL

[Rob (22)]

Hi Everyone,
I'm new to xml and I would like to know if I could benefit from using it. I have an online registration form that I would like to write to sql as xml. Right now, I take all of requet.form and dump it into one field of the sql database as a string and use "vbcrlf" as a delimiter and my application parses through that string and deals with it accordingly. I would like to know if anyone anyone knows of any resources that can show me how to do this. I've seen a lot of tutorials but nothing that will show me how to write it in one field in a structured format.

Any help would be appreciated.

Thanks
Rob

 

[Abhinav (archive)]

Hi Everyone,
I'm new to xml and I would like to know if I could benefit from using it. I have an online registration form that I would like to write to sql as xml. Right now, I take all of requet.form and dump it into one field of the sql database as a string and use "vbcrlf" as a delimiter and my application parses through that string and deals with it accordingly. I would like to know if anyone anyone knows of any resources that can show me how to do this. I've seen a lot of tutorials but nothing that will show me how to write it in one field in a structured format.

Oracle databases have an XMLType column which you can use. Check out the docs at http://www.oracle.com

I do not know about other databases....maybe something exists for them too ..

HTH