From: Mark Probert Date: 2002-07-09T02:08:09+09:00 Subject: Re: Ruby.DBI -- select where ... Dossy wrote: > On 2002.07.09, Mark Probert wrote: > > sth = dbh.prepare("select au_lname, au_fname from authors where > > state = #{state}") > [...] > > You forgot the single-quotes around the string literal in your SQL: > Thank you so much! Sometimes the simple mistakes are the hardest to find ... -mark. --------------------- Mark Probert (probertm@nortelnnetworks.com) Nortel Networks -- Optera Metro 3000 GNPS Phone: (613) 768-1082 [ESN: 398-1082]