ASP Source Code:
<%Option Explicit%>
<!--#include file="Misc.inc"-->
<!--#include file="ADOsetup.inc"-->
<HTML>
<HEAD>
<%
DIM strSQL, strID, strTemp
strSQL = "Select * FROM tblTTDtasks WHERE 2 = 1"
ADOrs.Open strSQL, ADOcn
SUB Blankfmt(strCaption,strField)
Response.Write("<tr>")
Response.Write(vbTab & "<td width='20%'><B>")
Response.Write(strCaption)
Response.Write("</td></B>")
Response.Write("<td>")
SELECT CASE strField
CASE "fldTaskPriority"
Response.Write ("<select name=" & "'" & strField & "'>")
Response.Write ("<option value=1>1</option>" & vbCrLf)
Response.Write ("<option value=2>2</option>" & vbCrLf)
Response.Write ("<option value=3>3</option>" & vbCrLf)
Response.Write("</select>")
CASE "fldUser"
Response.Write("<select name=" & "'" & strField & "'>")
Response.Write("<option value=TBD>TBD</option>" & vbCrLf)
Response.Write("<option value=Ken>Ken</option>" & vbCrLf)
Response.Write("<option value=Dan>Dan</option>" & vbCrLf)
Response.Write("<option value=Frank>Frank</option>" & vbCrLf)
Response.Write("<option value=Other>Other</option>" & vbCrLf)
Response.Write("</select>")
CASE ELSE
Response.Write("<input type='Text' Name=")
Response.Write("'" & strField & "'>")
END SELECT
Response.Write("</td>")
Response.Write("</tr>")
END SUB
%>
</HEAD>
<BODY>
<%CALL Heading("New Entry")%>
<form action="Add.asp" method="get">
<table width="80%">
<%
CALL Blankfmt("Topic","fldTopic")
CALL Blankfmt("Task","fldTask")
CALL Blankfmt("Priority","fldTaskPriority")
CALL Blankfmt("Status","fldStatus")
CALL Blankfmt("User","fldUser")
CALL Blankfmt("Cost","fldCost")
CALL Blankfmt("Deadline","fldDeadLine")
CALL Blankfmt("Details","fldDetails")
%>
</table>
<input type="submit" value="Submit New Data"><BR>
</form>
<!--#include file="ADOclose.inc"-->
</BODY>
</HTML>