Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > Writing xml to SQL

Reply
Thread Tools

Writing xml to SQL

 
 
Rob
Guest
Posts: n/a
 
      08-14-2004
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Reply With Quote
 
 
 
 
Abhinav
Guest
Posts: n/a
 
      08-16-2004
Rob wrote:

> 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

--
Abhinav
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Reference, SQL Queries, SQL help ecoolone ASP .Net 0 01-03-2008 10:58 AM
Writing xml file from MS SQL Ros Python 1 03-08-2007 02:51 PM
SQL: writing more concise paramaterized SQL darrel ASP .Net 13 03-30-2006 03:59 PM
Different results parsing a XML file with XML::Simple (XML::Sax vs. XML::Parser) Erik Wasser Perl Misc 5 03-05-2006 10:09 PM
Tools to extract data from SQL database and convert it into XML & insert XML data into SQL databases Harry Zoroc XML 1 07-12-2004 10:10 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57