2008/10/7 File <[EMAIL PROTECTED]>:
> puts $db[:invTypes].
> filter(:marketGroupID != 0).
I think :marketGroupID != 0 is evaluated at true, so it's the same
as : filter(true)
> filter(:metaType <= @meta).
> filter(:volume => $volumeMin..$volumeMax).
>
> order_by(:categoryName, :groupName, :marketGroupID, :metaType, :typeName).sql
>
> => SELECT * FROM `invTypes` WHERE (('t' AND (`metaType` <= 3)) AND
> ((`volume` >= 5.0) AND (`volume` <= 100.0))) ORDER BY `categoryName`,
> `groupName`, `marketGroupID`, `metaType`, `typeName`
>
> What's with this "...('t' AND ..."???
you can write : filter(~{:marketGroupID => 0})
~{ ... } is used to return a negative expression.
-- Jean-François.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
