%
Dim strLog
strLog = Request.QueryString("LO")%>
<%
Dim strUser, strPass, strError, oConn, oRS, strSQL
strUser = TRIM(Request.Form("userName"))
strPass = TRIM(Request.Form("pass"))
If Len(Request.Form("submitFlag")) > 0 Then
session ("userID") = ""
session ("firstname") = ""
session ("surname") = ""
If Len(strUser) = 0 Then
strError = strError & "
Please enter a valid username.
"
Response.Write(strError)
End If
If Len(strPass) = 0 Then
strError = strError & "
Please enter a valid password.
"
Response.Write(strError)
End If
' if the length of the string is not equal to zero, validate the user's login details
If Len(strError) = 0 Then
' create (instantiate) connection object
Set oConn = Server.CreateObject( "ADODB.Connection" )
' open connection to database, using connection object and connection string
oConn.open dbConnString
strSQL = "SELECT * " & _
"FROM tblUsers " & _
"WHERE userName = '" & strUser & "' AND userPass = '" & strPass & "'"
' create a recordset object to hold the rows returned from the database
Set oRS = Server.CreateObject( "ADODB.Recordset" )
' open recordset
oRS.Open strSQL, oConn
If oRS.EOF Then
strError = strError & "
I'm sorry you have entered an invalid username and password combination. Please re-try.
"
Response.Write(strError)
Else
' everything is OK, the user has a valid login
Call LoggedIn(oRS("userID"), oRS("userName"), oRS("userPass"))
End If
oRS.Close
oConn.Close
Set oRS = Nothing
Set oConn = Nothing
End If
End If
%>
St. Ive's Chambers - Birmingham UK
Chambers are pleased to announce that
Mr Gareth Cheetham has accepted an
invitation to join Chambers as a tenant having completed his pupillage.
He will be available to accept instructions in all areas of general
common law.more...
Chambers are pleased to announce that
Miss Claire Briggs has accepted an
invitation to join Chambers as a tenant.
more...
Recommendations
Find
out what Chambers & Partners and the Legal 500 guides
to the legal profession say about
St. Ive’s Chambers and our individual barristers. more...
Video
Conferencing at St. Ive’s Chambers.
Next time you are considering organising a conference, even
if it is not with a barrister at St.Ive’s Chambers more...