Yep just discovered that empirically, may be nice to add that to the
cheat sheet :)
Also for the second issue this seems to work too...
Instead of...
> ds.update do
> periods.each do |p| # create updates for all periods
> (p|idx) << (p|idx) + v
> end
> end
This may work...
h= periods.inject({}){ |h, p| h.merge((p|idx) => (p|idx) + v }
ds.update_sql(h)
Does that look ok?
If they are all equivalent I can update.
Thanks
On Jun 29, 2:35 pm, "Aman Gupta" <[EMAIL PROTECTED]> wrote:
> > DB[:table].update{ :a << :a + 1 }
> > -> UPDATE table SET a = a + 1
>
> These work:
>
> >> DB[:table].update_sql( :a => (:a+1) )
> => "UPDATE `table` SET `a` = (`a` + 1)"
>
> >> DB[:table].update_sql( :a => 'a+1'.lit )
> => "UPDATE `table` SET `a` = a+1"
>
> Amand
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-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/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
