From: Mike Stok <mike@...>
Date: 2013-06-22T08:26:51+09:00
Subject: Re: DB transaction setup, and feeling stupid.


--Apple-Mail=_9ECE9C6B-E967-47B9-9178-DDB76D235619
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii


On 2013-06-21, at 7:20 PM, "Ken D'Ambrosio" <ken@jots.org> wrote:

> 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):
>=20
> [1] pry(main)> require 'mysql'
> =3D> true
> [2] pry(main)> @db_conn =3D Mysql.new 'localhost', 'root', =
'passwordhere', 'jabberlogs'
> =3D> #<Mysql:0x0000000183f760>
> [3] pry(main)> line =3D =
'/home/ken/.purple/logs/jabber/kdambr200@cable/aabreh200@vss-xmpp.sys.comc=
ast.net/2013-04-10.100100-0400EDT.html'
> =3D> =
"/home/ken/.purple/logs/jabber/kdambr200@cable/aabreh200@vss-xmpp.sys.comc=
ast.net/2013-04-10.100100-0400EDT.html"
> [4] pry(main)> @dbio =3D @db_conn.prepare "SELECT file_id FROM =
loglines WHERE line=3D\"?\""

Have you tried

@dbio =3D @db_conn.prepare "SELECT file_id FROM loglines WHERE line=3D?"

So that the place holder is not "hidden" in a string?

> =3D> #<Mysql::Stmt:0x00000001599a60>
> [5] pry(main)> @dbio.execute(line)
> Mysql::Error: execute: param_count(0) !=3D number of argument(1)
> from (pry):5:in `execute'
>=20
> I've tried all the permutations I can think for syntax surrounding the =
question mark... but I'm kinda stumped.  Any pointers?
>=20
> Thanks kindly,
>=20
> -Ken

Hope this helps,

Mike

--=20

Mike Stok <mike@stok.ca>
http://www.stok.ca/~mike/

The "`Stok' disclaimers" apply.







--Apple-Mail=_9ECE9C6B-E967-47B9-9178-DDB76D235619
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=us-ascii

<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space; "><br>On 2013-06-21, at 7:20 PM, =
"Ken D'Ambrosio" &lt;<a href=3D"mailto:ken@jots.org">ken@jots.org</a>&gt; =
wrote:<br><br><blockquote type=3D"cite">Hi, all. &nbsp;I'm a relative =
Ruby newb, and I'm trying to set up paramaterized MySQL queries. =
&nbsp;And am&nbsp;getting completely stumped. &nbsp;I do a similar query =
slightly before this one, and it works great. &nbsp;This&nbsp;one? =
&nbsp;Not so much. &nbsp;It fails with the same error in my .rb file, =
but I figured I'd give the pry for the&nbsp;gory details (and fewer =
lines):<br><br>[1] pry(main)&gt; require 'mysql'<br>=3D&gt; true<br>[2] =
pry(main)&gt; @db_conn =3D Mysql.new 'localhost', 'root', =
'passwordhere', 'jabberlogs'<br>=3D&gt; =
#&lt;Mysql:0x0000000183f760&gt;<br>[3] pry(main)&gt; line =3D =
'/home/ken/.purple/logs/jabber/kdambr200@cable/aabreh200@vss-<a =
href=3D"http://xmpp.sys.comcast.net/2013-04-10.100100-0400EDT.html'">xmpp.=
sys.comcast.net/2013-04-10.100100-0400EDT.html'</a><br>=3D&gt; =
"/home/ken/.purple/logs/jabber/kdambr200@cable/aabreh200@vss-xmpp.sys.comc=
ast.net/2013-04-10.100100-0400EDT.html"<br>[4] pry(main)&gt;&nbsp;@dbio =
=3D @db_conn.prepare "SELECT file_id FROM loglines WHERE =
line=3D\"?\""</blockquote><div><br></div>Have you =
tried<div><br></div><div>@dbio =3D @db_conn.prepare "SELECT file_id FROM =
loglines WHERE line=3D?"</div><div><br></div><div>So that the place =
holder is not "hidden" in a string?</div><div><br><blockquote =
type=3D"cite">=3D&gt; #&lt;Mysql::Stmt:0x00000001599a60&gt;<br>[5] =
pry(main)&gt; @dbio.execute(line)<br>Mysql::Error: execute: =
param_count(0) !=3D number of argument(1)<br>from (pry):5:in =
`execute'<br><br>I've tried all the permutations I can think for syntax =
surrounding the question mark... but I'm kinda&nbsp;stumped. &nbsp;Any =
pointers?<br><br>Thanks =
kindly,<br><br>-Ken<br></blockquote><div><br></div>Hope this =
helps,</div><div><br></div><div>Mike</div><div><br><div>--&nbsp;<br><br>Mi=
ke Stok &lt;<a href=3D"mailto:mike@stok.ca">mike@stok.ca</a>&gt;<br><a =
href=3D"http://www.stok.ca/~mike/">http://www.stok.ca/~mike/</a><br><br>Th=
e "`Stok' disclaimers" =
apply.<br><br><br><br><br><br></div><br></div></body></html>=

--Apple-Mail=_9ECE9C6B-E967-47B9-9178-DDB76D235619--