search for: showaltb

Hi, I''m having a problem with the automatic formatting of my mysql query. My code is this: Tablename.find(:all, :conditions => {:id => list}) Where list is a list of id''s (8,9,10) The problem is that the query is automatically formatted to this: SELECT * FROM Tablename WHERE (id in (''8,7,9'')) I need this query to run without the extra single quotes

My understanding is that, given tables Alpha and Beta that the table which holds the 1-to-1 relation will be called Alpha_Beta (or is it alpha_beta?). So far so good. alpha_beta will have, lets say, two fields: alpha_id and beta_id. Seems that it''d be a good idea for those two fields to form a compound primary key, ensuring there are no duplicates. However, RoR doesn''t

On 6/12/07, Thufir <hawat.thufir-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > I just want to get a listing of my database, as I''ve done with a dummy > example. Right now I''m getting: > > "Routing Error > > no route found to match "/legacy/list" with {:method=>:get}" > <http://localhost:3000/legacy/list> > >