Rails find by sql escape colon character

Question

I am trying to run a SQL query on a model with a value that has a colon ':' in it.

Something like:

Model.find_by_sql([SELECT * FROM table WHERE field1 = ? AND field2 ='some:value'], params)

This causes the following error:

ActiveRecord::PreparedStatementInvalid

Any one know how to properly escape the colon ':' in the value text to field2 above?

makaroni4 · Accepted Answer · 2012-04-23 18:10:13Z

4

Use where, it will make the code shorter:

Model.where("field1 = ? AND field2 ='some:value']", params)

Concrete example:

1.9.3-head :024 > Tag.where('created_at <= ? and name = "some:value"', Time.now)
  Tag Load (1.6ms)  SELECT "tags".* FROM "tags" WHERE (created_at <= '2012-04-23 18:06:54.967319' and name = "some:value")
 => [#<Tag id: 2419, name: "some:value", created_at: "2012-04-23 18:06:35", updated_at: "2012-04-23 18:06:35">]

answered Apr 23, 2012 at 18:10

makaroni4

2,2811 gold badge18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lucapette · Accepted Answer · 2012-04-23 17:52:12Z

2

gsub!(':','\\:\\') on value should work.

edited Apr 23, 2012 at 17:52

lucapette

20.7k6 gold badges67 silver badges59 bronze badges

answered Apr 23, 2012 at 17:41

rrevi

1,0614 gold badges17 silver badges32 bronze badges

Collectives™ on Stack Overflow

Rails find by sql escape colon character

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related