On Thu, Sep 22, 2011 at 7:21 PM, Fred <[email protected]> wrote: > Hello everyone, > > I have a rails app which uses email as login name. At some point, I > have to search the user, in the User model by email. For some reason, > the method User.find_by_email(email) returns nil, even though the user > is in the database. > > The same applies for any find_by_* method that searches by any > database column. I was able to find the user using the User.find > > Does anyone have an idea of what might be going on? >
Is this ruby 1.9? Maybe ... this is related to string encoding of the columns ? Check the string encoding of the string by which you are searching and the one that is used in the database. Please show exact code samples for how you used User.find (with succesful result) and User.find_by_email (without result). For this scenario of encoding issues, please show the email.encoding on the result from from the find => User.first.email.encoding HTH, Peter -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
