How write between query in rails

rubyonrails-talk
1

I am trying something like this i want result which is between ? and ? with one condition but query gives me sql syntax exception.

Group.find_by_sql(["select * from groups where lft BETWEEN (?) and (?) and in_directory=?",self.lft,self.rgt, 1])

    how i solve it.

2

I am trying something like this i want result which is between ? and ? with one condition but query gives me sql syntax exception.

You don't need the () with between.

Fred

PS find_by_sql is unnecessary here.

3

:o

group = Group.find(:all,:conditions => ['lft BETWEEN ? and ? and in_directory= ? ',self.lft,self.right,1])

hope this might be ur looking