VBScript case sensitive ?

[DKL01]

Hi,

Is VB script case sensitive ? If I enter "SAP" in the password field in logon screen it works. If I enter "sap" it won't. In database the password is stored as "SAP"

Page1.asp
-----------

<%@ Language=VBScript %>

<%

Dim userid
Dim password
Dim conn
Dim SQL
dim RS

userid = request(&quot;userid&quot
password = request(&quot;password&quot

Set conn = Server.CreateObject(&quot;ADODB.Connection&quot
conn.Open Application(&quot;ConnectionString&quot
session(&quot;Connection&quot = conn

set RS = Server.Createobject(&quot;ADODB.Recordset&quot
SQL = &quot;EXEC spValidateUser &quot; + userid
RS.Open SQL, conn


if RS(0)= password then
Response.Redirect(&quot;AddMember.asp&quot
else
Response.write(&quot;Invalid password&quot
end if


%>

 

[Swany]

Yes, string compares in VB are case sensitive.

to convert a string to uppercase use the UCASE() function, lowercase is LCASE()

password = UCASE(request(&quot;password&quot) .
.. Eat, think and be merry .
... ....................... .