janice
12-18-2003, 04:02 PM
Hope to get some help on this.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
I have 3 pages:
First page is called getpoint.asp.
All this page does is when click, invokes a second page called showForms.asp to open in a popup window.
Once this form is completed and a submit button is clicked, the last page called insert.asp is invoked to process the form and submit the data to the database.
So far, I have run into a snag.
I keep getting this error:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
I don't know what it is or how to fix it.
Can someone please take a look at these codes.
Please bear with me for am including all 3 because they are short and I honestly don't know which of them is causing me grief.
Please forgive me for doing this.
getpoint.asp
------------
<script language="javascript">
var loc = "showform.asp?LAT=" + "<%=Request.Form("lat")%>" + "&LON=" + "<%=Request.Form("lon")%>";
win = window.open(loc, "ShowFormWin", "width=610,height=330,dependent=yes,resizable=yes");
win.focus();
</script>
showForm.asp
------------
<html>
<head>
<title> Spills Report Log </title>
</head>
<body bgcolor="silver">
<form Name="myform" method="post" action="insert.asp">
<table><tr><td>
<input type="hidden" name="rpt_lat" value=="<%=Request.Querystring("lat")%>">
<input type="hidden" name="rpt_lon" value=="<%=Request.Querystring("lon")%>">
</td></tr>
<tr>
<td>
Spills Location:
</td>
<td>
<input type="text" maxlength="30" name="rpt_location" size="33">
</td><td>
City:
</td>
<td>
<input type="text" maxlength="30" name="rpt_City" size="33">
</td
</tr>
<tr>
<td>
Basin:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Basin" size="33">
</td>
<td>
Date Found:
</td>
<td>
<input type="text" maxlength="30" name="rpt_DteFound" size="33">
</td>
</tr>
<tr>
<td>
District:
</td>
<td>
<input type="text" maxlength="30" name="rpt_District" size="33">
</td>
<td>
Commision:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Comm" size="33">
</td>
</tr>
<tr>
<td>
Type Of Spill:
</td>
<td>
<input type="text" maxlength="30" name="rpt_type_of_spill" size="33">
</td>
<td>
Cause Type:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Cause_Type" size="33">
</td>
</tr>
<tr>
<td>
Receiving:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Receiving" size="33">
</td>
<td>
Date Repaired:
</td>
<td>
<input type="text" maxlength="30" name="rpt_DteRepaired" size="33">
</td>
</tr>
<tr>
<td>
Total Gallon:
</td>
<td>
<input type="text" maxlength="30" name="rpt_tlGallon" size="33">
</td>
</tr>
</table>
<center>
<input type="Submit" name="Submit" Value="OK">
<input type="Button" name="CancelButton" Value="Cancel" onClick="window.close()">
</center>
</form>
</body>
</html>
insert.asp
----------
<%
Set myConn=Server.CreateObject("ADODB.Connection")
myConn.open("Spills")
SQLstr="INSERT INTO spills_geocd1 " & _
"( lat,lon,spills_loca,cause_type,commission, total_gall, " & _
"date_repai,type_of_sp,receiving_,basin1,district,city,date_found) " & _
"values( " & _
" '" & Request.Form("rpt_lat") & "', '" & Request.Form("rpt_lon") & "','" & Request.Form("rpt_location") & "', " &_
" '" & Request.Form("rpt_Cause_Type") & "', '" & Request.Form("rpt_Comm") & "'," & _
" '" & Request.Form("rpt_tlGallon") & "', " & _
" '" & Request.Form("rpt_DteRepaired") & "', " & _
" '" & Request.Form("rpt_type_of_spill") & "', " & _
" '" & Request.Form("rpt_Receiving") & "', " & _
" '" & Request.Form("rpt_Basin") & "', " & _
" '" & Request.Form("rpt_District") & "', " & _
" '" & Request.Form("rpt_City") & "'," & _
" '" & Request.Form("rpt_DteFound") & "')"
myConn.Execute (SQLstr)
%>
<script language="javascript">
alert("Point added successfully! Reload the map to see the changes you made.");
window.close();
</script>
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
I have 3 pages:
First page is called getpoint.asp.
All this page does is when click, invokes a second page called showForms.asp to open in a popup window.
Once this form is completed and a submit button is clicked, the last page called insert.asp is invoked to process the form and submit the data to the database.
So far, I have run into a snag.
I keep getting this error:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
I don't know what it is or how to fix it.
Can someone please take a look at these codes.
Please bear with me for am including all 3 because they are short and I honestly don't know which of them is causing me grief.
Please forgive me for doing this.
getpoint.asp
------------
<script language="javascript">
var loc = "showform.asp?LAT=" + "<%=Request.Form("lat")%>" + "&LON=" + "<%=Request.Form("lon")%>";
win = window.open(loc, "ShowFormWin", "width=610,height=330,dependent=yes,resizable=yes");
win.focus();
</script>
showForm.asp
------------
<html>
<head>
<title> Spills Report Log </title>
</head>
<body bgcolor="silver">
<form Name="myform" method="post" action="insert.asp">
<table><tr><td>
<input type="hidden" name="rpt_lat" value=="<%=Request.Querystring("lat")%>">
<input type="hidden" name="rpt_lon" value=="<%=Request.Querystring("lon")%>">
</td></tr>
<tr>
<td>
Spills Location:
</td>
<td>
<input type="text" maxlength="30" name="rpt_location" size="33">
</td><td>
City:
</td>
<td>
<input type="text" maxlength="30" name="rpt_City" size="33">
</td
</tr>
<tr>
<td>
Basin:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Basin" size="33">
</td>
<td>
Date Found:
</td>
<td>
<input type="text" maxlength="30" name="rpt_DteFound" size="33">
</td>
</tr>
<tr>
<td>
District:
</td>
<td>
<input type="text" maxlength="30" name="rpt_District" size="33">
</td>
<td>
Commision:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Comm" size="33">
</td>
</tr>
<tr>
<td>
Type Of Spill:
</td>
<td>
<input type="text" maxlength="30" name="rpt_type_of_spill" size="33">
</td>
<td>
Cause Type:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Cause_Type" size="33">
</td>
</tr>
<tr>
<td>
Receiving:
</td>
<td>
<input type="text" maxlength="30" name="rpt_Receiving" size="33">
</td>
<td>
Date Repaired:
</td>
<td>
<input type="text" maxlength="30" name="rpt_DteRepaired" size="33">
</td>
</tr>
<tr>
<td>
Total Gallon:
</td>
<td>
<input type="text" maxlength="30" name="rpt_tlGallon" size="33">
</td>
</tr>
</table>
<center>
<input type="Submit" name="Submit" Value="OK">
<input type="Button" name="CancelButton" Value="Cancel" onClick="window.close()">
</center>
</form>
</body>
</html>
insert.asp
----------
<%
Set myConn=Server.CreateObject("ADODB.Connection")
myConn.open("Spills")
SQLstr="INSERT INTO spills_geocd1 " & _
"( lat,lon,spills_loca,cause_type,commission, total_gall, " & _
"date_repai,type_of_sp,receiving_,basin1,district,city,date_found) " & _
"values( " & _
" '" & Request.Form("rpt_lat") & "', '" & Request.Form("rpt_lon") & "','" & Request.Form("rpt_location") & "', " &_
" '" & Request.Form("rpt_Cause_Type") & "', '" & Request.Form("rpt_Comm") & "'," & _
" '" & Request.Form("rpt_tlGallon") & "', " & _
" '" & Request.Form("rpt_DteRepaired") & "', " & _
" '" & Request.Form("rpt_type_of_spill") & "', " & _
" '" & Request.Form("rpt_Receiving") & "', " & _
" '" & Request.Form("rpt_Basin") & "', " & _
" '" & Request.Form("rpt_District") & "', " & _
" '" & Request.Form("rpt_City") & "'," & _
" '" & Request.Form("rpt_DteFound") & "')"
myConn.Execute (SQLstr)
%>
<script language="javascript">
alert("Point added successfully! Reload the map to see the changes you made.");
window.close();
</script>