I encountered the following problem with sqlite3：
databases table：
member：
username passworld
bb.qnyd@gmail.com
05c0693789f977b3eb0902eb568d498f
I operate in the rails which ：
Member.find_by_username_and_password("bb.qnyd","05c0693789f977b3eb0902eb568d498f")
=> nil
However, some can return the correct results
I run the sql statement：select * from member
password="05c0693789f977b3eb0902eb568d498f",notice: not found
This is sqlite3 bug??
--
-------------------------------------------------------------------------
learn log: http://me.boolsir.com
my life log: http://www.boolsir.com
-------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en.
Please post these types of questions to the rubyonrails-talk mailing list. rubyonrails-core is reserved for discussion about the internals of the framework. On Tuesday, 6 September 2011 at 11:01 AM, B.Tag wrote:> I encountered the following problem with sqlite3： > > databases table： > member： > username passworld > bb.qnyd@gmail.com (mailto:bb.qnyd@gmail.com) 05c0693789f977b3eb0902eb568d498f > > > I operate in the rails which ： > Member.find_by_username_and_password("bb.qnyd","05c0693789f977b3eb0902eb568d498f") => nil > > However, some can return the correct results > > I run the sql statement：select * from member password="05c0693789f977b3eb0902eb568d498f",notice: not found > > This is sqlite3 bug?? > > > -- > ------------------------------------------------------------------------- > learn log: http://me.boolsir.com > my life log: http://www.boolsir.com > ------------------------------------------------------------------------- > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. > To post to this group, send email to rubyonrails-core@googlegroups.com (mailto:rubyonrails-core@googlegroups.com). > To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com (mailto:rubyonrails-core+unsubscribe@googlegroups.com). > For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
ok,I sorry! I use gmail auto-complete. 2011/9/6 Ryan Bigg <radarlistener@gmail.com>> Please post these types of questions to the rubyonrails-talk mailing list. > rubyonrails-core is reserved for discussion about the internals of the > framework. > > On Tuesday, 6 September 2011 at 11:01 AM, B.Tag wrote: > > I encountered the following problem with sqlite3： > > databases table： > member： > username passworld > bb.qnyd@gmail.com > 05c0693789f977b3eb0902eb568d498f > > > I operate in the rails which ： > > Member.find_by_username_and_password("bb.qnyd","05c0693789f977b3eb0902eb568d498f") > => nil > > However, some can return the correct results > > I run the sql statement：select * from member > password="05c0693789f977b3eb0902eb568d498f",notice: not found > > This is sqlite3 bug?? > > > -- > ------------------------------------------------------------------------- > learn log: http://me.boolsir.com > my life log: http://www.boolsir.com > ------------------------------------------------------------------------- > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Core" group. > To post to this group, send email to rubyonrails-core@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-core+unsubscribe@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-core?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Core" group. > To post to this group, send email to rubyonrails-core@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-core+unsubscribe@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-core?hl=en. >-- ------------------------------------------------------------------------- learn log: http://me.boolsir.com my life log: http://www.boolsir.com ------------------------------------------------------------------------- -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.