Parse XML to database

hi, can someone help me with this
after i read theres nothing show in my database… wat happen…?
where is my error in my code??

class Map

require ‘rexml/document’
require “mysql”
require “dbi”
include REXML
scanfile = File.new(‘River_Va.lmx’)
doc = doc = File.open(‘River_Va.lmx’, ‘rb’) {|scanfile|
Document.new(scanfile)
}
puts doc

maps = REXML::Document.new()
root = maps.root

names = []
latitudes = []
longtitudes = []

      #~ MSISDN = {}
#~ mobils.elements.each("MobileDevices/MobileDevice") { |element|

puts
#~ element.attributes[“MSISDN”]
#~ MSISDN = element.attributes[“MSISDN”] }

#~ datetime = {}
#~ mobils.elements.each("MobileDevices/MobileDevice") { |element|

puts
#~ element.attributes[“datetime”]
#~ datetime = element.attributes[“datetime”] }

#~ description = {}
#~ mobils.elements.each("MobileDevices/MobileDevice") { |element|

puts
#~ element.attributes[“description”]
#~ description = element.attributes[“description”] }

maps.elements.each("lm:landmark") { |element| puts

element.attributes[“name”]
names.push element.attributes[“name”]
name = element.attributes[“name”]}

puts name
maps.elements.each(“lm:landmark”) { |element| puts
element.attributes[“latitude”]
latitudes.push element.attributes[“latitude”]}

puts latitudes
maps.elements.each(“lm:longitude”) { |element| puts
element.attributes[“longtitude”]
longtitudes.push element.attributes[“longtitude”] }

puts longtitudes

db insert

dbname=“email_development”

m = Mysql.new(“localhost”, “root”, “”, “email_development”)
sth=m.query(“insert into maps (name,latitude,longtitude) values
(name,latitude,longtitude)”)
#~ (“INSERT INTO Maps (name, latitude,
#~ longtitude)
#~ VALUES (?,?,?,?,?)”)
#~ models.each_index do |index|
#~name = names[index]
#~ latitude = latitudes[index]
#~ longtitude = longtitudes[index]
# sth.execute(“River_Va.lmx”, “email_development”, “#{names}”,
#"#{latitudes}", “#{longtitudes}”)
#end

end

this is my xml file~~

<?xml version="1.0" encoding="UTF-8"?>

<lm:lmx xmlns:lm=“http://www.nokia.com/schemas/location/landmarks/1/0
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance
xsi:schemaLocation=“http://www.nokia.com/schemas/location/landmarks/1/0
lmx.xsd”>
lm:landmarkCollection
lm:landmark
lm:nameRiver Valley High School</lm:name>
lm:coordinates
lm:latitude9.36</lm:latitude>
lm:longitude147.804</lm:longitude>
</lm:coordinates>
lm:addressInfo
lm:countrySingapore</lm:country>
lm:citySingapore</lm:city>
lm:postalCode10</lm:postalCode>
lm:districtBukit Merah</lm:district>
lm:streetMalan Road</lm:street>
lm:phoneNumber+65987987987</lm:phoneNumber>
</lm:addressInfo>
</lm:landmark>
</lm:landmarkCollection>
</lm:lmx>

On 02.06.2008 04:06, Cean O. wrote:

hi, can someone help me with this
after i read theres nothing show in my database… wat happen…?
where is my error in my code??

I don’t see any COMMIT in there.

robert

hmm…i solved the database problem… but… after i extract the xml
file, it shows me nil

which part that i did wrong?

require ‘rexml/document’
require “mysql”
require “dbi”
include REXML
scanfile = File.new(‘River_Va.lmx’)

dbname=“email_development”
doc = REXML::Document.new scanfile

string = <<EOF

Text, text, text

EOF
doc = Document.new string

doc = Document.new File.new(“River_Va.lmx”)

doc.elements.each("lm:landmarkCollection/lm:landmark") { |element| 

puts element.attributes[“lm:name”] }
root = doc.root

  popo = root.attributes["lm:name"]

puts root.attributes[“lm:name”]

remove the

… thx for helping…

well… i found it how… but then, can anyone help me how to remove
this thing inside the database please???

123

cause my attribute for my try in the database is integer, and it cant
read the try, so how shud i remove that thing before the database??

really appreciate if someone would help me with this…

cheers