From: Junkone <junkone1@...>
Date: 2008-06-16T06:29:12+09:00
Subject: ruby string format kicks in when doign wild card in activerecord

when i was doing a LIKE statement in my wild card query. Ruby thinks
that the % is a String Format charactor and throws exception. what are
my options.


>> Rawdata.find(:all , :conditions=>["processed_indicator like 'LF%'"])
ArgumentError: malformed format string - %'
        from e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:1421:in `%'
        from e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:1421:in `sanitize_sql_array'
        from e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:1390:in `sanitize_sql'
        from e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:1163:in `add_conditions!'
        from e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:1096:in `construct_finder_sql'
        from e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:997:in `find_every'
        from e:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/
active_record/base.rb:418:in `find'
        from (irb):20
>>