%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% '--------------------------------------------- 'Copyright 2003 Paragon Automation (M) Sdn Bhd 'Created by: Vivek Thomas ' vivek@excellence.com.my ' vivektj@hotmail.com 'Date Deployed: 1st June 2003 '--------------------------------------------- %> <% Response.Buffer = True Response.Cookies("Hukm")("DownPage") = "services/Lockers.asp" 'Dimension Variables Dim adoCon 'Database Connection Variable Dim strCon 'Holds the Database driver and the path and name of the database Dim adoRec, adoRecLoc 'Database Recordset Variable Dim strSQL, strSQLLoc 'Database query sring Dim strStatus, strNoOfSeats, strNoOfMonths, strStartTime, strEndTime, strCost, strSendEmailUser, strSendEmailAdmin Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open strCon Set adoRec = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT tbl_SetupLocker.* FROM tbl_SetupLocker " adoRec.CursorType = 0 adoRec.LockType = 3 adoRec.Open strSQL, strCon If adoRec.EOF Then '-------------- Multimedia Lab Teble has no data---------------- 'Response.Write("Locker Error") Response.Redirect("LockersErr.asp?Err=noPg") Else strStatus = adoRec.Fields("Status") strNoOfLockers = adoRec.Fields("NoOfLockers") strCost = adoRec.Fields("Cost") strDeposit = adoRec.Fields("Deposit") strSendEmailUser = adoRec.Fields("SendEmailUser") strSendEmailAdmin = adoRec.Fields("SendEmailAdmin") strEmailIDAdmin = adoRec.Fields("EmailIDAdmin") End if If strStatus <> True then Response.Redirect("LockersErr.asp?ErrType=noServ") End if %>