From: Jaypee <rf.oodanaw@...>
Date: 2005-06-21T04:25:35+09:00
Subject: Re: trouble with sqlite-ruby

Lowell Kirsh a �crit :
> 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
My little, tiny experience with SQLite3 is that it requires quote around
the tables and columns name. Have you tried this way:
stmt = db.prepare("select * from 'mp3' where 'file' = :file;")
J-P