<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<CFSET #user# = "none">
<CFSET #usernone# = "none">
<cfquery name="check_pass" datasource="gb_login" dbtype="ODBC">
SELECT * FROM users WHERE user = '#Form.username#'
</cfquery>
<html>
<head>
<title>Web-based Gradebook Login</title>
</head>
<body>
<cfoutput query="check_pass">
<cfif IsDefined("user") AND (#Form.password# eq #password#)>
<p>
You have been authenticated
</p>
<p>
Your authorization level is:
</p>
#type#
<cfelse>
<p> You have entered an incorrect password! </p>
</cfif>
</cfoutput>
<cfif check_pass.RecordCount eq 0>
<p> You have entered an invalid UserName! </p>
</cfif>
</body>