On Apr 28, 12:53 pm, Owain <owain.mcgu...@gmail.com> wrote: > > mysql> insert into confirmations (quote_id) values(188); > Query OK, 1 row affected (0.01 sec) > > mysql> select * from confirmations where quote_id = 188;
Why are you filtering by quote_id here? Fred > +-----+----------+-------+---------------------+--------------------- > +-----------+ > | id | quote_id | flags | created_at | updated_at | > serialnum | > +-----+----------+-------+---------------------+--------------------- > +-----------+ > | 188 | 188 | 4 | 2011-04-28 10:41:32 | 2011-04-28 10:41:32 | > 10195323 | > | 189 | 188 | NULL | NULL | NULL | > NULL | > +-----+----------+-------+---------------------+--------------------- > +-----------+ > 2 rows in set (0.00 sec) > > So in some way the mysql adapter is reporting a statement invalid when > it shouldn't as far as I can tell. > > Any ideas on where to start looking would be a great help. > > O. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.