Ruby on Rails to check if a variable has a value

Question

My doubt is i am throwing an sql statement

@authenticates = Authenticate.find(
  :all, 
  :conditions => ["userid = ? AND password = ?", params[:text1], params[:text2]]
)

I need to put an if condition, so that if the above data exists i need to redirect to other page else display an error

How can i do this

Check the variable your set and change the location you redirect to? — Dave Newton
– Dave Newton, Commented Jul 4, 2012 at 14:59
Also, consider naming your parameters something actually meaningful. — Dave Newton
– Dave Newton, Commented Jul 4, 2012 at 15:00
btw "passwords" that are stored and retrieved like this == open access ;) — Michael Durrant
– Michael Durrant, Commented Jul 4, 2012 at 15:06

Matzi · Accepted Answer · 2014-07-07 08:36:05Z

2

Seems that you need an authentication example. Check this.

Otherwise you just need an if condition to check if the @authenticates variable contains anything or not.

edited Jul 7, 2014 at 8:36

answered Jul 4, 2012 at 15:01

Matzi

14k4 gold badges35 silver badges51 bronze badges

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

Comments

Veraticus · Accepted Answer · 2012-07-04 14:59:22Z

1

You just want the if clause that'll make this happen? If so:

if params[:text1] && params[:text2]
  @authenticates = Authenticate.find(
    :all, 
    :conditions => ["userid = ? AND password = ?", params[:text1], params[:text2]]
  )
 else
   redirect_to page_where_the_params_are_set_path
 end

answered Jul 4, 2012 at 14:59

Veraticus

16.1k3 gold badges43 silver badges45 bronze badges

Comments

Jason Kim · Accepted Answer · 2012-07-04 15:01:50Z

0

I need to put an if condition, so that if the above data exists i need to redirect to other page else display an error

Sorry, but your question is awkwardly worded. I would suggest rephrasing the question clearly, so that you can get the right response. I presume what you want is something like this

@authenticates = Authenticate.find(
  :all, 
  :conditions => ["userid = ? AND password = ?", params[:text1], params[:text2]]
)
if @authenticates.count < 1
  redirect_to some_action_path
end

answered Jul 4, 2012 at 15:01

Jason Kim

19.2k13 gold badges70 silver badges106 bronze badges

Collectives™ on Stack Overflow

Ruby on Rails to check if a variable has a value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related