[#407882] Ruby extremely slow compared to PHP — Mick Jagger <lists@...>

Hello there, how are you? Hope you are fine. I am a PHP programmer

17 messages 2013/06/02

[#407908] TCPServer/Socket and Marshal problem — Panagiotis Atmatzidis <atma@...>

Hello,

18 messages 2013/06/03

[#407946] Is rubyquiz.com dead? — Alphonse 23 <lists@...>

Thread title says everything.

18 messages 2013/06/04

[#408012] Need help understanding recursion. — pedro oliva <lists@...>

Ive been reading Chris Pine's book 'Learn to Program' and its been going

11 messages 2013/06/06

[#408129] Getting Started With Development — Chamila Wijayarathna <cdwijayarathna@...>

I'm new to Ruby Development. I downloaded source from Github, but couldn't

24 messages 2013/06/11
[#408131] Re: Getting Started With Development — Per-erik Martin <lists@...> 2013/06/11

Ruby is often installed on linux, or can be easily installed with the

[#408146] Re: Getting Started With Development — "Chamila W." <lists@...> 2013/06/11

Per-erik Martin wrote in post #1112021:

[#408149] Re: Getting Started With Development — "Carlo E. Prelz" <fluido@...> 2013/06/11

Subject: Re: Getting Started With Development

[#408198] NokoGiri XML Parser — "Devender P." <lists@...>

Hi,

11 messages 2013/06/13

[#408201] trying to load a .rb file in irb — "Eric D." <lists@...>

I am trying to load a ruby program into irb and it will not load.

12 messages 2013/06/13

[#408205] Can I use Sinatra to render dynamic pages? — Ruby Student <ruby.student@...>

Hell Team,

18 messages 2013/06/13
[#408219] Re: Can I use Sinatra to render dynamic pages? — Nicholas Van Weerdenburg <vanweerd@...> 2013/06/14

You should be able to do this without JavaScript by using streaming.

[#408228] Re: Can I use Sinatra to render dynamic pages? — Ruby Student <ruby.student@...> 2013/06/14

Well, I got some good suggestions from everyone here. I thank you all for

[#408275] Compare and sort one array according to another. — masta Blasta <lists@...>

I have two arrays of objects that look something like this:

14 messages 2013/06/17

[#408276] Comparing objects — "Thom T." <lists@...>

How do I compare two objects in Ruby, considering only attributes

15 messages 2013/06/17

[#408307] getting the most out of Ruby — robin wood <lists@...>

I write a lot of scripts in Ruby, most are small simple things but some

13 messages 2013/06/18

[#408309] Creating ruby script exe — Rochit Sen <lists@...>

Hi All,

17 messages 2013/06/18

[#408357] Beginners problem with database and datamapper — cristian cristian <lists@...>

Hi all!

28 messages 2013/06/20

[#408437] How do I input a variable floating point number into Ruby Programs — "Michael P F." <lists@...>

I want to evaluate the following interactively:

10 messages 2013/06/23

[#408518] #!/usr/bin/env: No such file or directory — Todd Sterben <lists@...>

I am new to both linux and ruby. I am using Ubuntu and Ruby 1.9

17 messages 2013/06/27

[#408528] Designing a Cabinet class — Mike Vezzani <lists@...>

Hello all,

12 messages 2013/06/27

[#408561] Find elment in array of hashes — Rodrigo Lueneberg <lists@...>

array = {:id=>1, :price =>0.25} # index[0]

23 messages 2013/06/28

Re: DB transaction setup, and feeling stupid.

From: Robert Klemme <shortcutter@...>
Date: 2013-06-22 12:38:46 UTC
List: ruby-talk #408407
On Sat, Jun 22, 2013 at 1:26 AM, Mike Stok <mike@stok.ca> wrote:

>
> 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):
>
> [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=\"?\""
>
>
> Have you tried
>
> @dbio = @db_conn.prepare "SELECT file_id FROM loglines WHERE line=?"
>
> So that the place holder is not "hidden" in a string?
>

It's not hidden - it's not a placeholder any more. :-)  I agree: I am
almost 100% sure that this is the issue.  When looking at the error message
it mentions 0 parameters but found 1 argument (see below).


>
> => #<Mysql::Stmt:0x00000001599a60>
> [5] pry(main)> @dbio.execute(line)
> Mysql::Error: execute: param_count(0) != number of argument(1)
> from (pry):5:in `execute'
>
> Kind regards

robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

In This Thread

Prev Next