From: Lowell Kirsh <lkirsh@...>
Date: 2005-06-20T16:10:35+09:00
Subject: trouble with sqlite-ruby

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