From: Hannes Wyss <hwyss@...>
Date: 2002-07-09T02:11:40+09:00
Subject: Re: Ruby.DBI -- select where ...

Mark, 

I don't know MS-SQL, but I would estimate that you need to quote your values
unless you want the dbms to look for a column of that name:

dbh.prepare("select ... from ... where state='#{state}'")
                                             ^        ^
Cheers
Hannes