i have code that adds a xml data to a database

the structure of the xml document is as follows

<tutorial>
  <album>
       <title>adobe golive</title>
       <genre> web design </genre>
       <link>
      <title>http://hotwired.lycos.com/webmonkey/99/19/index3a.html? tw=authoring
      </title>
      </link>
  </album>
</tutorial>


-------------------------------------------------------------------
the code that adds the data is

Set objRecord = objDom.createElement("album") **********creates the album record
objRoot.appendChild objRecord

Set objFieldValue = objDom.createElement("title") **********creates software package title
objFieldValue.Text = Request.Form("titleQuery")

objRecord.appendChild objFieldValue

Set objFieldValue = objDom.createElement("genre") ******creates the genre of the package
objFieldValue.Text = Request.Form("genreQuery")



Set objFieldValue = objDom.createElement("link") *****creates the link
objFieldValue.Text = Request.Form("linkQuery")

objRecord.appendChild objFieldValue


------------------------------------------------------
but the structure of the add xml record after runnging the code is

<album>
<title>css</title>
<genre>authoring</genre>
</album>
<link>
<title>http://www.w3.org</title>
</link>


as you can see the album tag is closed before the link tag is starts, so i want the close album tag </album> to appear ater the </link> tag to keep the original structure of the xml document, so my xsl stylesheet works

any ideas??


thanks

I don't think you've shown us the crucial bit of code. With your required structure, you need to
1. create the link element
2. create the title element and set its text
3. append the title element as a child of the link
4. append the link as a child of the album