Rails 3 Validation - Comparison with database values

Question

I'm trying to use Rails validations for a form text box to see if the text entered matches any existing values in a specific column of a table in the database. Is this possible with Rails?

Basically, like this:

User enters 'Foobar'

Table column values: 'Foobar,test,house,random'

Validation does not pass because 'Foobar' is already in the database.

Thanks! dwmcc

Mike Z · Accepted Answer · 2012-04-11 00:01:26Z

1

You can do this in your model with something like validates_uniqueness_of :name or new in Rails 3 you can do multiple validations inline with validates :name, :presence => true, :uniqueness => true

From the Rails API.

answered Apr 11, 2012 at 0:01

Mike Z

4,1112 gold badges33 silver badges53 bronze badges

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

2 Comments

dwmcc Over a year ago

Thanks, two more questions: How can I make the matching case insensitive so that the application will not accept 'Foobar' because 'FOOBAR' already exists in the database? And how can I validate the uniqueness of the field based on another table? To clarify, how can I validate that 'Foobar' does not exist in another table in my database? Thanks!

Mike Z Over a year ago

As for the second part of your question, I do not know. I think that is complex enough to warrant a new question.

Collectives™ on Stack Overflow

Rails 3 Validation - Comparison with database values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related