querying to check for integer values in ruby on rails

Question

I want to execute this query in rails app

   Video.where("category= 'film' AND grant = 1").order('created_at DESC').page(params[:page]).per_page(10)

here grant stores an integer value.

and I am getting following error

    Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grant = 1) ORDER BY created_at DESC LIMIT 10 OFFSET 0' at line 1: SELECT  `videos`.* FROM `videos`  WHERE (category= 'film' AND grant = 1) ORDER BY created_at DESC LIMIT 10 OFFSET 0

thanks in advance

nbbk · Accepted Answer · 2013-07-18 17:04:13Z

5

The problem is with grant. GRANT is a reserved word in MySql. You should use back-ticks around them.

Video.where("category= 'film' AND `grant` = 1").order('created_at DESC').page(params[:page]).per_page(10)

will do the job i guess. Refer Reserved Words

answered Jul 18, 2013 at 17:04

nbbk

1,1022 gold badges14 silver badges32 bronze badges

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

2 Comments

thomasfedb Over a year ago

A more Rails-ish implementation would use where(category: "film", grant: 1).

rohith Over a year ago

what if we want to use OR instead of AND ?

user2076561 · Accepted Answer · 2013-07-18 16:16:20Z

4

Try this ..

@videos=Video.where(:category => 'film',:grant => 'yes' ).order('created_at DESC').page(params[:page]).per_page(10)

answered Jul 18, 2013 at 16:16

user2076561

1591 gold badge2 silver badges7 bronze badges

2 Comments

rohith Over a year ago

thanks, it worked for me... but i have no clue why other queries is not working.

rohith Over a year ago

also i changed :grant => 'yes' to :grant => '1'. since my "grant " stores integer value.

thomasfedb · Accepted Answer · 2013-07-18 17:07:52Z

0

Check this:

Video.where("category = ? AND `grant` = ?", "film", 1).order('created_at DESC').page(params[:page]).per_page(10)

edited Jul 18, 2013 at 17:07

thomasfedb

5,9832 gold badges40 silver badges65 bronze badges

answered Jul 18, 2013 at 9:07

SR5

958 bronze badges

Collectives™ on Stack Overflow

querying to check for integer values in ruby on rails

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related