Via Datamapper 0.10, is there a mechanism to better handle
conditionals with OR (instead of AND)?
I had my ghetto search query break from 0.9 to 0.10:
all(["(title like ? OR description_source like ? OR company_name
like ? OR outside_location like ?)", search, search, search, search])
I know there's the much fancier :name.like => "" , however I
couldn't figure out how to make it work with an OR query. Can anyone
help?
Here's the stack trace I get on the above query. the search variable
is just a simple string
~ Binding mismatch: 2 for 1
INTERNAL ERROR!!! Binding mismatch: 2 for 1
/Users/jc/Merb/testapp/gems/gems/data_objects-0.10.0/lib/data_objects/
command.rb:73:in `escape_sql'
/Users/jc/Merb/testapp/gems/gems/dm-core-0.10.0/lib/dm-core/adapters/
data_objects_adapter.rb:88:in `execute_reader'
/Users/jc/Merb/testapp/gems/gems/dm-core-0.10.0/lib/dm-core/adapters/
data_objects_adapter.rb:88:in `read'
/Users/jc/Merb/testapp/gems/gems/dm-core-0.10.0/lib/dm-core/adapters/
data_objects_adapter.rb:266:in `with_connection'
/Users/jc/Merb/testapp/gems/gems/dm-core-0.10.0/lib/dm-core/adapters/
data_objects_adapter.rb:84:in `read'
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DataMapper" 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/datamapper?hl=en
-~----------~----~----~----~------~----~------~--~---
