Hi Amet,
If you don't have access to the database to change this
property, you can just change your query like this:
sqlStr="select email,pass from tbluser where UPPER(email)='"
+ txtEmail.Text.ToUpper() +"' and UPPER(pass)='" +
txtPass.Text.ToUpper() + "'"
Of course you probably need to change your login script to avoid
SQL injection as well; google on "prevent sql injection" (without
quotes) and you'll get a lot of information on this subject.
Cheers,
Peter
-----Original Message-----
From: amet [mailto:[EMAIL PROTECTED]
hi.I have a login page needs email and password combination.page
language is c# and database is MSSql2000.for example email in db is
[EMAIL PROTECTED] and pass is 123.when user enters [EMAIL PROTECTED] and
123,he cant logs in cause of the letter e.if he enters [EMAIL PROTECTED]
no problem,he is in.my query is
simple:
sqlStr="select email,pass from tbluser where email='"
+ txtEmail.Text+"' and pass='" + txtPass.Text + "'"
help please.thanks..
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
