ohho
Reputation: 51941
:conditions => "LIKE ___%" syntax
The following gives an error: ArgumentError: malformed format string - %':
named_scope :sales, :conditions => ["rolename LIKE 'salesteam%'"]
The following is OK:
named_scope :sales, :conditions => ["rolename LIKE 'salesteam%%'"]
I am wondering where I can find the documentation for the %% (double %) syntax.
Upvotes: 1
Views: 2404
Answers (1)
Syed Aslam
Reputation: 8807
Shouldn't it be like this?
named_scope :sales, :conditions => ["rolename LIKE ?", 'salesteam%']
Upvotes: 3
Related Questions
- How do I do a LIKE % query in ActiveRecord?
- SQL Like operator in ruby on rails
- Multiple like conditions in active record
- how do i get a rails WHERE query to be more specific? "Like" works, = doesn't
- Help with rails active record querying (like clause)
- Rails activerecord LIKE AND clause error
- LIKE operator in active record query with associations
- Like statement in Rails 3
- Like and where condition in ruby
- Adding a LIKE criteria to a Rails Conditions block