From: Gyoung-Yoon Noh <nohmad@...>
Date: 2005-06-21T04:41:36+09:00
Subject: Re: trouble with sqlite-ruby

On 6/20/05, Lowell Kirsh <lkirsh@cs.ubc.ca> wrote:
> I'm having trouble getting bind parameters to work. I'm getting errors
> along the line of "no such bind parameter 'file' (SQLite3::Exception)".
> This arises in 2 situations, which are probably both doing the same
> thing under the hood. Here are the pices of code that give me the errors:
> 
>    stmt = db.prepare("select * from mp3 where file = :file;")
>    stmt.bind_param('file', 'hello')
> and
> 
>    stmt = db.execute("select * from mp3 where file = :file;",
>    "file" => 'hello')
> 
> I don't know why Ruby thinks there is no such bind parameter as 'file'
> when it's clearly there in the string.
> 
> Lowell
> 
> 

It seems to be recognized as one token ':file;', not ':file' as you expected.
Omit semicolon(;), indeed, semicolon need not be there
.
-- 
http://nohmad.sub-port.net