HTTP 500 error
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=8197
Printed Date: 01 April 2026 at 4:22am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: HTTP 500 error
Posted By: Sammy
Subject: HTTP 500 error
Date Posted: 18 December 2003 at 2:12pm
|
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,c ity,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> |
Replies:
Posted By: Mart
Date Posted: 18 December 2003 at 2:16pm
| Turn off Friendlt HTTP error messages - http://webwiz.net/asp/faq/friendly_HTTP_error_messages.asp - http://webwiz.net/asp/faq/friendly_HTTP_error_messages. asp then repost the error. |
Posted By: Sammy
Date Posted: 18 December 2003 at 2:55pm
| I unchecked it but I am still getting same http:500.10 error message |
Posted By: dpyers
Date Posted: 18 December 2003 at 11:44pm
|
Typically, you see this error when you call a function that doesn't exist (run time), have unbalanced parentheses - "(" but not a ")" (loadtime)- or divide by 0 (runtime). Sprinkle some responsewrites in the asp code to sectionalize the fault - e.g. Response.write "1 <br>" Response.write "2 <BR>" ... particularly at the begining, before each major activity (SQL execution), and at the end. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: Sammy
Date Posted: 19 December 2003 at 6:26am
|
The issue has been resolved. The problem was with the insert statement where a couple of fields were mis-spelled. Actually, the dba renamed some fields and I didn't have enough sense to verify those first. In any case, I thank you all for the assistance. |