Hey,
I'm getting a really weird != conversion for sqlite3. Here's my code:
require 'sequel'
$db = Sequel.sqlite 'db/eve.db'
@meta = 3
$volumeMin = 5.0
$volumeMax = 100.0
puts $db[:invTypes].
filter(:marketGroupID > 0).
filter(:metaType <= @meta).
filter(:volume => $volumeMin..$volumeMax).
order_by(:categoryName, :groupName, :marketGroupID, :metaType, :typeName).sql
=> SELECT * FROM `invTypes` WHERE (((`marketGroupID` > 0) AND
(`metaType` <= 3)) AND ((`volume` >= 5.0) AND (`volume` <= 100.0)))
ORDER BY `categoryName`, `groupName`, `marketGroupID`, `metaType`,
`typeName`
puts $db[:invTypes].
filter(:marketGroupID != 0).
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 ..."???
What am I doing wrong?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
