end of xml file

Results 1 to 2 of 2

Thread: end of xml file

  1. #1
    neo Guest

    Default end of xml file

    Hi,<BR> I am reading from an xml file and writing the contents to a database. I use the XMLDOM object. Here is my code.<BR>Set xml = Server.CreateObject("Microsoft.XMLDOM")<BR>xml.asy nc = False<BR>xml.load (Server.MapPath("comments.xml"))<BR>dim i<BR>i = 0<BR>do while i&#060; xml.length &#039;not sure what to do here<BR>username = (xml.getElementsByTagName("username").item(i).text )<BR>email = (xml.getElementsByTagName("email").item(i).text)<B R>comment = (xml.getElementsByTagName("body").item(i).text)<BR >sql1="INSERT INTO comments Values (&#039;"& username &"&#039;,&#039;"& email &"&#039;,&#039;"& comment &"&#039;)"<BR>oConn.Execute(sql1)<BR>i=i+1<BR>l oop

  2. #2
    bob hoskins Guest

    Default soz bout this but aint this like vb

    it looks alot like vb cool i may learn it

Posting Permissions

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