From: Daniel Schierbeck <daniel.schierbeck@...>
Date: 2006-05-12T19:00:37+09:00
Subject: Re: Two small questions

Valen wrote:
> I play Ruby without rails:
> 
> <% @connection = Mysql.new('localhost', 'root', '', 'carpart')%>
> <%=  query = 'Select * from `store` where  `part`="Stuff on shelf" ' %>
> <% list = @connection.query(query) %>
> 
>  and it works, but when I try to use a="Stuff on shelf" and I have
> 
> <%=  query = 'Select * from `store` where  `part`=' +  "#{a}"  %>
> 
>  operator <% list = @connection.query(query) %> raises MYSQL error, so I 
> cannot change string "Stuff on shelf" by variable a. I tried different 
> ways, but in vain.

Try this:

   query = "SELECT * FROM `store` WHERE `part`='#{a}'"

Note the single quotation marks around `#{a}'. Also note that I use 
upper case characters for all the SQL keywords -- it's just a 
convention, but it makes it easier for others to understand your code if 
they're used to the coding style.

One more thing; is `a' an input you get from the user? If so, you'll 
need some more info on how to deal with that.


Cheers,
Daniel