<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<%@ Language = VBscript %>
<%
carID=Request.Querystring("carID")
tranID=Request.Querystring("tranID")
gradeID=Request.Querystring("gradeID")
appID=Request.Querystring("appID")
appRate=Request.Querystring("appRate")
SQLTIME="SELECT appTime FROM appointments "
SQLTIME=SQLTIME &: "WHERE appID=" &: appID
set conntime = server.createobject("ADODB.Connection")
conntime.open "parking"
set thetime=conntime.execute(SQLTIME)
apptime=thetime(0)
conntime.close
%>
<HTML>
<HEAD>
<TITLE>Book an Appointment</TITLE>
</HEAD>
<BODY bgcolor="black" text="white">
<br><br><br><br><br>
<center>
<table width="250">
<tr>
<td>
<font face="arial" size="6">Just enter your name, email address, Social Security number, mother's maiden name, and a valid saving's account number below and your appointment for <font color="blue"><%= apptime %></font> will be booked.</font>
<p><font face="arial" size="4">
<form action="update.asp" method="get">
<input type="Hidden" name="carID" value="<%= carID %>">
<input type="Hidden" name="tranID" value="<%= tranID %>">
<input type="Hidden" name="gradeID" value="<%= gradeID %>">
<input type="Hidden" name="appID" value="<%= appID %>">
<input type="Hidden" name="appRate" value="<%= appRate %>">
<input type="Text" name="fname" size="20"> <i>First name</i>
<p><input type="Text" name="lname" size="20"> <i>Last name </i>
<p><input type="Text" name="email" size="20"> <i>Email</i>
<p><input type="Submit" value="You're Gonna Love This">
</form>
</td>
</tr>
</table>
<p>
</center>
</BODY>
</HTML>