From: Ken D'Ambrosio <ken@...>
Date: 2013-06-22T08:20:59+09:00
Subject: DB transaction setup, and feeling stupid.

Hi, all.  I'm a relative Ruby newb, and I'm trying to set up 
paramaterized MySQL queries.  And am getting completely stumped.  I do a 
similar query slightly before this one, and it works great.  This one?  
Not so much.  It fails with the same error in my .rb file, but I figured 
I'd give the pry for the gory details (and fewer lines):

[1] pry(main)> require 'mysql'
=> true
[2] pry(main)> @db_conn = Mysql.new 'localhost', 'root', 'passwordhere', 
'jabberlogs'
=> #<Mysql:0x0000000183f760>
[3] pry(main)> line = 
'/home/ken/.purple/logs/jabber/kdambr200@cable/aabreh200@vss-xmpp.sys.comcast.net/2013-04-10.100100-0400EDT.html'
=> 
"/home/ken/.purple/logs/jabber/kdambr200@cable/aabreh200@vss-xmpp.sys.comcast.net/2013-04-10.100100-0400EDT.html"
[4] pry(main)> @dbio = @db_conn.prepare "SELECT file_id FROM loglines 
WHERE line=\"?\""
=> #<Mysql::Stmt:0x00000001599a60>
[5] pry(main)> @dbio.execute(line)
Mysql::Error: execute: param_count(0) != number of argument(1)
from (pry):5:in `execute'

I've tried all the permutations I can think for syntax surrounding the 
question mark... but I'm kinda stumped.  Any pointers?

Thanks kindly,

-Ken