Results 1 to 2 of 2

Thread: XML into SQL- elements or attribs?

  1. #1
    Join Date
    Apr 2003

    Question XML into SQL- elements or attribs?

    Hi all

    I need to get an XML file into a SQL database (and back out again later- either into Quark Express or onto the Internet). The file is basically contains details from our company address book and is quite simple in structure (i.e. first name, last name, address-- the same throughout really).

    Now...i still don't know what to use: elements or attirbutes. I don't know what the difference will be and how it will effect my work in the future. Getting the data in, i could use either method, but i will then need to use the info in the database for intranet(ASP) applications. I also want the xml data to map nicely to SQL tables/columns.

    Any info MUCH appreciated


  2. #2
    Join Date
    Dec 2002
    Calgary, Canada
    It should not matter much at all ( I hope).

    W3C already have prety good standard for XML so I dont' think it will effect either way.
    In my opinion its just a matter of choice.
    You can call me lazy for this but since retrieveing attributes involves one extra step therefore I have always stuck with element values..



Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center

Recent Articles