From: Thomas Hurst Date: 2002-07-09T03:08:03+09:00 Subject: Re: Ruby.DBI -- select where ... * Nat Pryce (nat.pryce@b13media.com) wrote: > sth = dbh.prepare("select au_lname, au_fname from authors where state = > \"#{state}\"") Also note you can use ?'s as placeholders, then pass the literal to the execute or as an extra argument to prepare; it'll quote it for you taking into account any oddities of the server you're using. -- Thomas 'Freaky' Hurst - freaky@aagh.net - http://www.aagh.net/ - Pudder's Law: Anything that begins well will end badly. (Note: The converse of Pudder's law is not true.)