Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP Newbie needs help with HTTP 500.100 error

Status
Not open for further replies.

redwatty

IS-IT--Management
Aug 3, 2001
46
GB
Hi

I am currently building an ASP intranet in Dreamweaver Ultra Dev 4. I have managed to get a number of simple insert pages to update the Access database. However I am having problems with one insert page which utilises Dynamic lists/menus. I have followed all the procedures correctly (I think)but get an internal server error when I run the page in IE and try to submit a new record. I will post the code here and highlight the line in red that seems to be throwing up the error. If anybody could have a peruse and see if they spot any glaring errors.

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;../Connections/innerwheel.asp&quot; -->
<%
' *** Edit Operations: declare variables

MM_editAction = CStr(Request(&quot;URL&quot;))
If (Request.QueryString <> &quot;&quot;) Then
MM_editAction = MM_editAction & &quot;?&quot; & Request.QueryString
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = &quot;&quot;
%>
<%
' *** Insert Record: set variables

If (CStr(Request(&quot;MM_insert&quot;)) <> &quot;&quot;) Then

MM_editConnection = MM_innerwheel_STRING
MM_editTable = &quot;events&quot;
MM_editRedirectUrl = &quot;default.asp&quot;
MM_fieldsStr = &quot;eventname|value|eventvenue|value|language|value|trainer1|value|datefrom|value|dateto|value|trainer2|value|trainer3|value|placesavail|value|placesbooked|value|employee|value|todaysdate|value|notes|value&quot;
MM_columnsStr = &quot;eventnameid|none,none,NULL|eventvenueid|none,none,NULL|languageid|none,none,NULL|trainer1|',none,''|datefrom|',none,NULL|dateto|',none,NULL|trainer2|',none,''|trainer3|',none,''|eventplaces|none,none,NULL|eventbooked|none,none,NULL|employeeid|none,none,NULL|date|',none,NULL|notes|',none,''&quot;

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, &quot;|&quot;)
MM_columns = Split(MM_columnsStr, &quot;|&quot;)

' set the form values
For i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(i+1) = CStr(Request.Form(MM_fields(i)))
Next

' append the query string to the redirect URL
If (MM_editRedirectUrl <> &quot;&quot; And Request.QueryString <> &quot;&quot;) Then
If (InStr(1, MM_editRedirectUrl, &quot;?&quot;, vbTextCompare) = 0 And Request.QueryString <> &quot;&quot;) Then
MM_editRedirectUrl = MM_editRedirectUrl & &quot;?&quot; & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & &quot;&&quot; & Request.QueryString
End If
End If

End If
%>
<%
' *** Insert Record: construct a sql insert statement and execute it

If (CStr(Request(&quot;MM_insert&quot;)) <> &quot;&quot;) Then

' create the sql insert statement
MM_tableValues = &quot;&quot;
MM_dbValues = &quot;&quot;
For i = LBound(MM_fields) To UBound(MM_fields) Step 2
FormVal = MM_fields(i+1)
MM_typeArray = Split(MM_columns(i+1),&quot;,&quot;)
Delim = MM_typeArray(0)
If (Delim = &quot;none&quot;) Then Delim = &quot;&quot;
AltVal = MM_typeArray(1)
If (AltVal = &quot;none&quot;) Then AltVal = &quot;&quot;
EmptyVal = MM_typeArray(2)
If (EmptyVal = &quot;none&quot;) Then EmptyVal = &quot;&quot;
If (FormVal = &quot;&quot;) Then
FormVal = EmptyVal
Else
If (AltVal <> &quot;&quot;) Then
FormVal = AltVal
ElseIf (Delim = &quot;'&quot;) Then ' escape quotes
FormVal = &quot;'&quot; & Replace(FormVal,&quot;'&quot;,&quot;''&quot;) & &quot;'&quot;
Else
FormVal = Delim + FormVal + Delim
End If
End If
If (i <> LBound(MM_fields)) Then
MM_tableValues = MM_tableValues & &quot;,&quot;
MM_dbValues = MM_dbValues & &quot;,&quot;
End if
MM_tableValues = MM_tableValues & MM_columns(i)
MM_dbValues = MM_dbValues & FormVal
Next
MM_editQuery = &quot;insert into &quot; & MM_editTable & &quot; (&quot; & MM_tableValues & &quot;) values (&quot; & MM_dbValues & &quot;)&quot;

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject(&quot;ADODB.Command&quot;)
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> &quot;&quot;) Then
Response.Redirect(MM_editRedirectUrl)
End If
End If

End If
%>
<%
set eventvenue = Server.CreateObject(&quot;ADODB.Recordset&quot;)
eventvenue.ActiveConnection = MM_innerwheel_STRING
eventvenue.Source = &quot;SELECT DISTINCT eventvenue, eventvenueid FROM eventvenue ORDER BY eventvenue ASC&quot;
eventvenue.CursorType = 0
eventvenue.CursorLocation = 2
eventvenue.LockType = 3
eventvenue.Open()
eventvenue_numRows = 0
%>
<%
set eventname = Server.CreateObject(&quot;ADODB.Recordset&quot;)
eventname.ActiveConnection = MM_innerwheel_STRING
eventname.Source = &quot;SELECT DISTINCT eventname, eventnameid FROM eventname ORDER BY eventname ASC&quot;
eventname.CursorType = 0
eventname.CursorLocation = 2
eventname.LockType = 3
eventname.Open()
eventname_numRows = 0
%>
<%
set eventlanguage = Server.CreateObject(&quot;ADODB.Recordset&quot;)
eventlanguage.ActiveConnection = MM_innerwheel_STRING
eventlanguage.Source = &quot;SELECT DISTINCT language, languageid FROM language ORDER BY language ASC&quot;
eventlanguage.CursorType = 0
eventlanguage.CursorLocation = 2
eventlanguage.LockType = 3
eventlanguage.Open()
eventlanguage_numRows = 0
%>
<%
set employee = Server.CreateObject(&quot;ADODB.Recordset&quot;)
employee.ActiveConnection = MM_innerwheel_STRING
employee.Source = &quot;SELECT DISTINCT first, employeeid FROM staffrecord ORDER BY first ASC&quot;
employee.CursorType = 0
employee.CursorLocation = 2
employee.LockType = 3
employee.Open()
employee_numRows = 0
%>
<%
set events = Server.CreateObject(&quot;ADODB.Recordset&quot;)
events.ActiveConnection = MM_innerwheel_STRING
events.Source = &quot;SELECT * FROM events&quot;
events.CursorType = 0
events.CursorLocation = 2
events.LockType = 3
events.Open()
events_numRows = 0
%>
<!-- #BeginTemplate &quot;/Templates/main.dwt&quot; -->
<head>
<title>Inner Wheel</title>
<meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=iso-8859-1&quot;>
<script language=&quot;JavaScript&quot;>
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName==&quot;Netscape&quot;)&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<body bgcolor=&quot;#FFFFFF&quot; text=&quot;#000000&quot; link=&quot;#333333&quot; vlink=&quot;#006699&quot; alink=&quot;#3399FF&quot;>
<table width=&quot;75%&quot; border=&quot;0&quot; height=&quot;75%&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; align=&quot;center&quot;>
<tr>
<td valign=&quot;top&quot; height=&quot;884&quot;>
<table width=&quot;100%&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; height=&quot;161&quot;>
<tr>
<td height=&quot;161&quot; width=&quot;100%&quot; bgcolor=&quot;#CCCCCC&quot; background=&quot;../Images/banner2_new.jpg&quot; valign=&quot;bottom&quot;>
<p> </p>
<table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;2&quot;>
<tr>
<td width=&quot;53%&quot;> </td>
<td width=&quot;47%&quot;>
<table width=&quot;431&quot; border=&quot;0&quot; height=&quot;59&quot;>
<tr>
<td height=&quot;46&quot; colspan=&quot;9&quot;><img src=&quot;../Images/clickable.gif&quot; width=&quot;424&quot; height=&quot;47&quot; usemap=&quot;#Map&quot; border=&quot;0&quot; href=&quot;../email/default.asp&quot;></td>
</tr>
<tr>
<td height=&quot;9&quot; width=&quot;43&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot;><a href=&quot;../accounts/default.asp&quot;>Accounts</a></font></td>
<td height=&quot;9&quot; width=&quot;41&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;../caption/default.asp&quot;>Caption</a></font></td>
<td height=&quot;9&quot; width=&quot;45&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;../support/default.asp&quot;>Support</a></font></td>
<td height=&quot;9&quot; width=&quot;44&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;default.asp&quot;>Events</a></font></td>
<td height=&quot;9&quot; width=&quot;44&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;../default.asp&quot;>Home</a></font></td>
<td height=&quot;9&quot; width=&quot;40&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;../news/default.asp&quot;>News</a></font></td>
<td height=&quot;9&quot; width=&quot;31&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;../admin/default.asp&quot;>Admin</a></font></td>
<td height=&quot;9&quot; width=&quot;54&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;../telephone/default.asp&quot;>Telephone</a></font></td>
<td height=&quot;9&quot; width=&quot;51&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><a href=&quot;../email/default.asp&quot;>e-mail</a></font></td>
</tr>
</table>
</td>
</tr>
</table>
<p> </p>
</td>
</tr>
</table>
<table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; height=&quot;705&quot;>
<tr>
<td height=&quot;708&quot; valign=&quot;top&quot; align=&quot;center&quot;>
<table width=&quot;100%&quot; border=&quot;0&quot; height=&quot;669&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr>
<td width=&quot;14%&quot; valign=&quot;top&quot; height=&quot;669&quot;>
<table width=&quot;100%&quot; border=&quot;0&quot; background=&quot;../Images/leftnav_top_grad.jpg&quot; cellpadding=&quot;1&quot; cellspacing=&quot;0&quot; height=&quot;261&quot;>
<tr>
<td valign=&quot;top&quot; height=&quot;259&quot;>
<table width=&quot;100%&quot; border=&quot;0&quot; height=&quot;240&quot; align=&quot;center&quot; bgcolor=&quot;#FFFFFF&quot; cellpadding=&quot;1&quot;>
<tr>
<td height=&quot;13&quot; bgcolor=&quot;#FFFFFF&quot; width=&quot;100%&quot;>
<h1><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;>Navigate</font></h1>
</td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;../accounts/default.asp&quot;>Accounts</a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;../caption/default.asp&quot;>Caption
competition </a></b></font></td>
</tr>
<tr>
<td height=&quot;6&quot; width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;../support/default.asp&quot;>Software
Support Logs</a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;event%20listings.asp&quot;>Event
listings </a></b></font></td>
</tr>
<tr>
<td height=&quot;8&quot; width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;../default.asp&quot;>Home
Page</a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;../news/default.asp&quot;>News</a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;../admin/default.asp&quot;>Site
Administration </a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><a href=&quot;../telephone/default.asp&quot;>Telephone
functionality</a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot;><b><font color=&quot;#000000&quot;><a href=&quot;../location/default.asp&quot;>Location</a></font></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#000000&quot;><b><a href=&quot;../floor%20plans/default.asp&quot;>Floor
plans </a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#333333&quot;><b><a href=&quot;../health%20and%20safety/default.asp&quot;>Health
and Safety</a></b></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#000000&quot;><b><a href=&quot;../downloads/default.asp&quot;>Downloads</a></b></font><a href=&quot;../downloads/default.asp&quot;><b><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>sd</font></b></a><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>fs</font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfg</font></td>
</tr>
<tr>
<td height=&quot;2&quot; width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfgdfg</font></td>
</tr>
<tr>
<td height=&quot;50&quot; width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfgd</font></td>
</tr>
</table>
</td>
</tr>
</table>
<table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;1&quot; cellspacing=&quot;0&quot; bgcolor=&quot;#FFFFFF&quot;>
<tr>
<td>
<table width=&quot;100%&quot; border=&quot;0&quot; bgcolor=&quot;#FFFFFF&quot;>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width=&quot;100%&quot; border=&quot;0&quot; background=&quot;../Images/leftnav_bott_grad.jpg&quot; cellpadding=&quot;1&quot; cellspacing=&quot;0&quot; height=&quot;172&quot;>
<tr>
<td height=&quot;176&quot; valign=&quot;top&quot;>
<table width=&quot;100%&quot; border=&quot;0&quot; height=&quot;186&quot; bgcolor=&quot;#FFFFFF&quot;>
<tr>
<td width=&quot;100%&quot; height=&quot;20&quot;>
<h1><font size=&quot;2&quot; face=&quot;Arial, Helvetica, sans-serif&quot;>Internal
News</font></h1>
</td>
</tr>
<tr>
<td width=&quot;100%&quot; bgcolor=&quot;#FFFFFF&quot; height=&quot;15&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>lll<font color=&quot;#000000&quot;></font></font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfgdf</font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfg</font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfg</font></td>
</tr>
<tr>
<td width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfg</font></td>
</tr>
<tr>
<td height=&quot;36&quot; width=&quot;100%&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfgd</font></td>
</tr>
<tr>
<td height=&quot;10&quot; width=&quot;100%&quot; valign=&quot;top&quot;><font size=&quot;1&quot; face=&quot;Arial, Helvetica, sans-serif&quot; color=&quot;#FFFFFF&quot;>dfgdfgd</font></td>
</tr>
</table>
</td>
</tr>
</table>
<p> </p>
<table width=&quot;100%&quot; border=&quot;0&quot; height=&quot;77&quot;>
<tr>
<td background=&quot;../Images/bottom_grad.jpg&quot; height=&quot;22&quot;> </td>
</tr>
</table>
<p> </p>
</td>
<td width=&quot;1%&quot; height=&quot;669&quot;> </td>
<td width=&quot;85%&quot; valign=&quot;top&quot; height=&quot;669&quot; align=&quot;left&quot;>
<table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;1&quot; height=&quot;642&quot;>
<tr>
<td width=&quot;78%&quot; valign=&quot;top&quot; height=&quot;643&quot;> <!-- #BeginEditable &quot;main&quot; -->
<table width=&quot;529&quot; border=&quot;0&quot; cellspacing=&quot;0&quot; height=&quot;654&quot; background=&quot;../Images/amb1.jpg&quot; align=&quot;center&quot;>
<tr>
<td valign=&quot;top&quot; height=&quot;114&quot; width=&quot;189&quot;> </td>
<td valign=&quot;top&quot; height=&quot;114&quot; width=&quot;422&quot;> </td>
</tr>
<tr>
<td valign=&quot;top&quot; colspan=&quot;2&quot;>
<form ACTION=&quot;<%=MM_editAction%>&quot; name=&quot;addnewevent&quot; method=&quot;post&quot;>
<table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;0&quot; height=&quot;113&quot;>
<tr>
<td height=&quot;14&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#000000&quot;><b><font color=&quot;#990000&quot;>Select
event name</font></b></font> </td>
<td rowspan=&quot;2&quot;> </td>
</tr>
<tr>
<td height=&quot;10&quot;>
<select name=&quot;eventname&quot;>
<option selected>select event name</option>
<%
While (NOT eventname.EOF)
%>
<option value=&quot;<%=(eventname.Fields.Item(&quot;eventnameid&quot;).Value)%>&quot;><%=(eventname.Fields.Item(&quot;eventname&quot;).Value)%></option>
<%
eventname.MoveNext()
Wend
If (eventname.CursorType > 0) Then
eventname.MoveFirst
Else
eventname.Requery
End If
%>
</select>
<b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;><a href=&quot;add%20event%20name.asp&quot;>add
new event name</a></font></b></td>
</tr>
<tr>
<td height=&quot;4&quot;><font size=&quot;1&quot;></font></td>
<td height=&quot;4&quot;><font size=&quot;1&quot;></font></td>
</tr>
<tr>
<td height=&quot;6&quot;><b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;>Select
event venue</font></b></td>
<td rowspan=&quot;2&quot;> </td>
</tr>
<tr>
<td height=&quot;5&quot;> <font face=&quot;Arial, Helvetica, sans-serif&quot;>
<font size=&quot;1&quot;> <font color=&quot;#990000&quot;> <b>
<select name=&quot;eventvenue&quot;>
<option selected>select event venue</option>
<%
While (NOT eventvenue.EOF)
%>
<option value=&quot;<%=(eventvenue.Fields.Item(&quot;eventvenueid&quot;).Value)%>&quot;><%=(eventvenue.Fields.Item(&quot;eventvenue&quot;).Value)%></option>
<%
eventvenue.MoveNext()
Wend
If (eventvenue.CursorType > 0) Then
eventvenue.MoveFirst
Else
eventvenue.Requery
End If
%>
</select>
<a href=&quot;add%20event%20location.asp&quot;>add
new event venue</a></b></font></font></font></td>
</tr>
<tr>
<td height=&quot;10&quot;><font size=&quot;1&quot;></font></td>
<td height=&quot;10&quot;><font size=&quot;1&quot;></font></td>
</tr>
<tr>
<td height=&quot;4&quot;><b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;>Select
event language</font></b> </td>
<td rowspan=&quot;2&quot;> </td>
</tr>
<tr>
<td>
<select name=&quot;language&quot;>
<option selected>select event language</option>
<%
While (NOT eventlanguage.EOF)
%>
<option value=&quot;<%=(eventlanguage.Fields.Item(&quot;languageid&quot;).Value)%>&quot;><%=(eventlanguage.Fields.Item(&quot;language&quot;).Value)%></option>
<%
eventlanguage.MoveNext()
Wend
If (eventlanguage.CursorType > 0) Then
eventlanguage.MoveFirst
Else
eventlanguage.Requery
End If
%>
</select>
</td>
</tr>
</table>
<br>
<table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;0&quot;>
<tr>
<td height=&quot;10&quot; width=&quot;39%&quot;><b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;>
Trainer(s) / Course tutors</font></b></td>
<td height=&quot;10&quot; width=&quot;30%&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#000000&quot;><b><font color=&quot;#990000&quot;>Start
date (dd/mm/yyyy)</font></b></font></td>
<td height=&quot;10&quot; width=&quot;31%&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#000000&quot;><b><font color=&quot;#990000&quot;>End
date </font><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#000000&quot;><b><font color=&quot;#990000&quot;>
(dd/mm/yyyy)</font></b></font></b></font></td>
</tr>
<tr>
<td height=&quot;2&quot; width=&quot;39%&quot; valign=&quot;top&quot;>
<input type=&quot;text&quot; name=&quot;trainer1&quot;>
</td>
<td height=&quot;2&quot; width=&quot;30%&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
<input type=&quot;text&quot; name=&quot;datefrom&quot; size=&quot;11&quot;>
</font></td>
<td height=&quot;2&quot; width=&quot;31%&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
<input type=&quot;text&quot; name=&quot;dateto&quot; size=&quot;11&quot;>
</font></td>
</tr>
<tr>
<td rowspan=&quot;2&quot; height=&quot;17&quot; width=&quot;39%&quot;>
<input type=&quot;text&quot; name=&quot;trainer2&quot;>
</td>
<td colspan=&quot;2&quot; height=&quot;11&quot;> </td>
</tr>
<tr>
<td height=&quot;2&quot; width=&quot;30%&quot;><b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;>Places
available</font></b></td>
<td height=&quot;2&quot; width=&quot;31%&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;>Places
booked </font></td>
</tr>
<tr>
<td width=&quot;39%&quot; height=&quot;2&quot; valign=&quot;bottom&quot;>
<input type=&quot;text&quot; name=&quot;trainer3&quot;>
</td>
<td height=&quot;2&quot; valign=&quot;top&quot; width=&quot;30%&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
<input type=&quot;text&quot; name=&quot;placesavail&quot; size=&quot;3&quot; value=&quot;0&quot;>
</font></td>
<td height=&quot;2&quot; valign=&quot;top&quot; width=&quot;31%&quot;><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
<input type=&quot;text&quot; name=&quot;placesbooked&quot; size=&quot;3&quot; value=&quot;0&quot;>
</font></td>
</tr>
<tr>
<td colspan=&quot;3&quot; valign=&quot;top&quot;><b></b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
</font><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;></font><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
</font></td>
</tr>
<tr>
<td width=&quot;39%&quot; rowspan=&quot;2&quot;>  </td>
<td><b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;>Your
name</font></b></td>
<td><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;><b>Date
submitted</b></font></td>
</tr>
<tr>
<td><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
<select name=&quot;employee&quot;>
<option selected>Select your name</option>
<%
While (NOT employee.EOF)
%>
<option value=&quot;<%=(employee.Fields.Item(&quot;employeeid&quot;).Value)%>&quot;><%=(employee.Fields.Item(&quot;first&quot;).Value)%></option>
<%
employee.MoveNext()
Wend
If (employee.CursorType > 0) Then
employee.MoveFirst
Else
employee.Requery
End If
%>
</select>
</font></td>
<td><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;2&quot; color=&quot;#000000&quot;>
<input type=&quot;text&quot; name=&quot;todaysdate&quot; size=&quot;11&quot;>
</font></td>
</tr>
<tr>
<td width=&quot;39%&quot; height=&quot;2&quot; valign=&quot;bottom&quot;><b><font face=&quot;Arial, Helvetica, sans-serif&quot; size=&quot;1&quot; color=&quot;#990000&quot;>Notes
/ comments</font></b></td>
<td colspan=&quot;2&quot; height=&quot;2&quot;> </td>
</tr>
<tr>
<td colspan=&quot;3&quot;>
<textarea name=&quot;notes&quot; cols=&quot;50&quot; rows=&quot;5&quot;>
 
in your internet explorer go to Tools/Internet Options.
click on the Advanced tab and under Browsing uncheck the option Show friendly HTTP error messages (or better yet, use mozilla :)
this will allow you to see the exact error message your script is generating. (-:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top