View Single Post
  #1 (permalink)  
Old June 7th, 2007, 10:01 AM
mrjoka mrjoka is offline
Authorized User
Join Date: Jan 2007
Location: , , .
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem reading a value from an xml

dear experts, thanks for the help till now.
i'm working with an xml file, first i called the xml file, it is empty, the user entered some values in a form and then i parse these values to the xml, when this information is parsed to the xml, the location id is automatically generated, now i need to get this locationid and store it in database.
here is the xml i get:
 <?xml version="1.0" encoding="UTF-8" ?>
- <Response type="location.add" xmlns:xsi="" xsi:noNamespaceSchemaLocation="http://tools.finder.xml.addlocation.asp">
- <location id="3088479" marker_id="0" score="0" published="0" refid="">
- <address>
  <phone />
  <fax />
  <email />
  <internet />
  <memo />
  <image />
- <properties>
  <propertygroup id="200" name="Pharmacies" />
  <propertygroup id="201" name="UPO" />

the user enters all the field but the location is generated automatically.

i used:
set location_id = xmlObj.getElementsByTagName("location_id")
and in the query i'm using insert into tabe (location_id,....0 values (location_id)
i've been working in this problem for a logn time now. any help will be appreciated.

Reply With Quote