thx :-)
On 8 Okt., 14:48, Erol Fornoles <[EMAIL PROTECTED]> wrote:
> On Oct 8, 8:44 pm, fx3000se <[EMAIL PROTECTED]> wrote:
>
>
>
> > ScheduleItem.count(["id = ?", 204])
> > used to work as expected in Rails 1.1.6, i.e. returning the count of
> > rows where id = 204 ...
> > In 2.1.1 I get the error:
>
> > "ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: You
> > have an error in your SQL syntax; check the manual that corresponds to
> > your MySQL server version for the right syntax to use near '?204) AS
> > count_id_204 FROM `schedule_items`' at line 1: SELECT count(id = ?204)
> > AS count_id_204 FROM `schedule_items` "
>
> > Looks like ["id = ?", id] is not evaluated/resolved correctly
> > resulting in 'id = ?204' instead of 'id = 204'
>
> > Bug?
>
> > Thx
> > Clemens
>
> ScheduleItem.count(:conditions => ["id = ?", 204])
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
