From: "seb@..." <seb@...>
Date: 2006-11-16T22:56:58+09:00
Subject: Re: parse xml file, put results in mysql db

--- Kathy Simmons <kathys39@hotmail.com> wrote:
> I'm a ruby newbie, parsing an xml file and putting results in mysql 
> file.  Working on linux.  I can parse the data and print it out ok. 
> Problem comes when I try to insert it into the mysql db - I get an error 
> for the variables.
> 
> Here's how I'm grabbing the data from xml and assigning to variable:
>   doc.elements.each("elementname") { |element| puts 
> element.attributes["args"]
>   args = element.attributes["args"}.......
> 
> That works fine. Below is the db stuff - can anyone figure out what I'm 
> doing wrong?
> 
> dbname = "data"
> m = Mysql.new("localhost", "userid", "passwd")
> dbh = DBI.connect("dbi:Mysql:data:localhost", "userid", "passwd")
> m.select_db(dbname)
> sth=dbh.prepare("INSERT INTO rawdata (file, tool, arguments) VALUES 
> (?,?,?)")
> sth.execute("#{filename}", "#{toolname}", "#{args}" )
> 
> 
> The last line is where it fails - if I put in values, it works fine, so 
> I know the error is in my variables.  This is first time I"ve programmed 
> ruby, so I'm not sure what is wrong....
> 
> -- 
> Posted via http://www.ruby-forum.com/.
> 
> 

Where are these variables being set?  Could we have the whole code, either
here or on pastebin.com for example?

My first instinct would be to remove the "#{}" around the variables, though I
can't see that being the main issue.