p2p.wrox.com: Archives - asp

asp_databases thread: RE: http 500 internal server error

Message #1 by "Roy, Siddarth S" <sroy@b...> on Wed, 19 Jun 2002 11:45:08 -0400

U have set up ur internet explorer that way

Internet explorer menu

tools ---> internet options ----------> advanced Tab

------------->show friendly url messages if it is checked un check it

then run the page with error on the page

it should be shown

thx
sid


-----Original Message-----
From: Lisa Smith [mailto:lisa@m...]
Sent: Wednesday, June 19, 2002 11:43 AM
To: ASP Databases
Subject: [asp_databases] RE: http 500 internal server error


Usually "page cannot be displayed" comes from trying to access a page 
that
does not exist.  However it can come from a database issue.  If you try
accessing the page using Netscape it may give you a more detailed error.
For some reason Internet Explorer is more vague in it's error 
descriptions
sometimes.

-----Original Message-----
From: ggebre@h... [mailto:ggebre@h...]
Sent: Tuesday, June 18, 2002 10:20 PM
To: ASP Databases
Subject: [asp_databases] http 500 internal server error


I am working form validation using the example give on chapter 15 of
Wrox's Begining ASP 3.0 pages, and I recieving this error that says Page
cannot be displayed.  I am wondering what is this?  I am not getting
anywhere?  What causes this error?  Here is the code for the program too
thanks.

<%

  Set rsUsers =3D Server.CreateObject("ADODB.RecordSet")
  rsUsers.Open Application("SQL_ConnectionString")

  Response.Write "DEBUG> Form =3D " & request.Form & "<BR>"

	If Request.Form("CustomerID")<> " " Then
		rsUsers.CheckID =3D "CustomerID =3D ' " & Request
("CustomerID") & "'"
	Else
		rsUsers.CheckID =3D "Email =3D ' " & Request.Form("Email")
& "'" & _
		                "AND Password =3D '" & Request.Form
("password") & "'"
    If rsUsers.EOF Then
    	rsUsers.AddNew
    End If
   End If

  Response.Write "DEBUG> Form =3D " & request.Form & "<BR>"
	rsUsers("Fname") =3D Request.Form("Fname")
 	rsUsers("Lname") =3D Request.Form("Lname")
	rsUsers("Staddress1") =3D Request.Form("StAddress1")
	rsUsers("StAddress2") =3D Request.Form("StAddress2")
	rsUsers("City") =3D Request.Form("City")
	rsUsers("State") =3D Request.Form("State")
	rsUsers("ZipCode") =3D Request.Form("ZipCode")
	rsUsers("Country") =3D Request.Form("Country")
	rsUsers("Email") =3D Request.Form("Email")
	rsUsers("Phone") =3D Request.Form("Phone")
	rsUsers("Active") =3D True
	rsUsers("LastLogin") =3D Now
	rsUsers.Update                                      'Update
database

	Dim strName, strValue
	 For each strField in rsUsers.Field
 		strName =3D strField.Name
 		strValue =3D strField.value
 		Request(strName) =3D strValue
 	Next
	Request("blnValidUser") =3D True          'verfiy that current user
is valid user of the system.
   Response.Redirect "DisplayItem.asp"     'Takes registered users to
display item menu automatically.
%>

Message #2 by "Lisa Smith" <lisa@m...> on Wed, 19 Jun 2002 08:42:35 -0700

Usually "page cannot be displayed" comes from trying to access a page that
does not exist.  However it can come from a database issue.  If you try
accessing the page using Netscape it may give you a more detailed error.
For some reason Internet Explorer is more vague in it's error descriptions
sometimes.

-----Original Message-----
From: ggebre@h... [mailto:ggebre@h...]
Sent: Tuesday, June 18, 2002 10:20 PM
To: ASP Databases
Subject: [asp_databases] http 500 internal server error


I am working form validation using the example give on chapter 15 of
Wrox's Begining ASP 3.0 pages, and I recieving this error that says Page
cannot be displayed.  I am wondering what is this?  I am not getting
anywhere?  What causes this error?  Here is the code for the program too
thanks.

<%

  Set rsUsers = Server.CreateObject("ADODB.RecordSet")
  rsUsers.Open Application("SQL_ConnectionString")

  Response.Write "DEBUG> Form = " & request.Form & "<BR>"

	If Request.Form("CustomerID")<> " " Then
		rsUsers.CheckID = "CustomerID = ' " & Request
("CustomerID") & "'"
	Else
		rsUsers.CheckID = "Email = ' " & Request.Form("Email")
& "'" & _
		                "AND Password = '" & Request.Form
("password") & "'"
    If rsUsers.EOF Then
    	rsUsers.AddNew
    End If
   End If

  Response.Write "DEBUG> Form = " & request.Form & "<BR>"
	rsUsers("Fname") = Request.Form("Fname")
 	rsUsers("Lname") = Request.Form("Lname")
	rsUsers("Staddress1") = Request.Form("StAddress1")
	rsUsers("StAddress2") = Request.Form("StAddress2")
	rsUsers("City") = Request.Form("City")
	rsUsers("State") = Request.Form("State")
	rsUsers("ZipCode") = Request.Form("ZipCode")
	rsUsers("Country") = Request.Form("Country")
	rsUsers("Email") = Request.Form("Email")
	rsUsers("Phone") = Request.Form("Phone")
	rsUsers("Active") = True
	rsUsers("LastLogin") = Now
	rsUsers.Update                                      'Update
database

	Dim strName, strValue
	 For each strField in rsUsers.Field
 		strName = strField.Name
 		strValue = strField.value
 		Request(strName) = strValue
 	Next
	Request("blnValidUser") = True          'verfiy that current user
is valid user of the system.
   Response.Redirect "DisplayItem.asp"     'Takes registered users to
display item menu automatically.
%>

Message #3 by Sam Clohesy <sam@e...> on Wed, 19 Jun 2002 16:47:42 +0100

Have to done (in IE)
Tools
Internet Options
Advanced
untick 'Show friendly HTTP errors' this should give you the correct
asp/dbase error





-----Original Message-----
From: Lisa Smith [mailto:lisa@m...]
Sent: 19 June 2002 16:43
To: ASP Databases
Subject: [asp_databases] RE: http 500 internal server error


Usually "page cannot be displayed" comes from trying to access a page that
does not exist.  However it can come from a database issue.  If you try
accessing the page using Netscape it may give you a more detailed error.
For some reason Internet Explorer is more vague in it's error descriptions
sometimes.

-----Original Message-----
From: ggebre@h... [mailto:ggebre@h...]
Sent: Tuesday, June 18, 2002 10:20 PM
To: ASP Databases
Subject: [asp_databases] http 500 internal server error


I am working form validation using the example give on chapter 15 of
Wrox's Begining ASP 3.0 pages, and I recieving this error that says Page
cannot be displayed.  I am wondering what is this?  I am not getting
anywhere?  What causes this error?  Here is the code for the program too
thanks.

<%

  Set rsUsers = Server.CreateObject("ADODB.RecordSet")
  rsUsers.Open Application("SQL_ConnectionString")

  Response.Write "DEBUG> Form = " & request.Form & "<BR>"

	If Request.Form("CustomerID")<> " " Then
		rsUsers.CheckID = "CustomerID = ' " & Request
("CustomerID") & "'"
	Else
		rsUsers.CheckID = "Email = ' " & Request.Form("Email")
& "'" & _
		                "AND Password = '" & Request.Form
("password") & "'"
    If rsUsers.EOF Then
    	rsUsers.AddNew
    End If
   End If

  Response.Write "DEBUG> Form = " & request.Form & "<BR>"
	rsUsers("Fname") = Request.Form("Fname")
 	rsUsers("Lname") = Request.Form("Lname")
	rsUsers("Staddress1") = Request.Form("StAddress1")
	rsUsers("StAddress2") = Request.Form("StAddress2")
	rsUsers("City") = Request.Form("City")
	rsUsers("State") = Request.Form("State")
	rsUsers("ZipCode") = Request.Form("ZipCode")
	rsUsers("Country") = Request.Form("Country")
	rsUsers("Email") = Request.Form("Email")
	rsUsers("Phone") = Request.Form("Phone")
	rsUsers("Active") = True
	rsUsers("LastLogin") = Now
	rsUsers.Update                                      'Update
database

	Dim strName, strValue
	 For each strField in rsUsers.Field
 		strName = strField.Name
 		strValue = strField.value
 		Request(strName) = strValue
 	Next
	Request("blnValidUser") = True          'verfiy that current user
is valid user of the system.
   Response.Redirect "DisplayItem.asp"     'Takes registered users to
display item menu automatically.
%>

Message #4 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 19 Jun 2002 00:00:52 +0200

Do this to be able to view more detailed error messages:

1) Open internet explorer
2) Tools -> Internet Settings
3) Advanced tab
4) Remove the check next to "Enable Friendly HTTP Error Messages"
5) OK


-Kim

> -----Original Message-----
> From: ggebre@h... [mailto:ggebre@h...]
> Sent: 18. juni 2002 22:20
> To: ASP Databases
> Subject: [asp_databases] http 500 internal server error
> 
> 
> I am working form validation using the example give on chapter 15 of 
> Wrox's Begining ASP 3.0 pages, and I recieving this error that says Page 
> cannot be displayed.  I am wondering what is this?  I am not getting 
> anywhere?  What causes this error?  Here is the code for the program too 
> thanks. 
> 
> <%
> 
>   Set rsUsers = Server.CreateObject("ADODB.RecordSet")
>   rsUsers.Open Application("SQL_ConnectionString")
>   
>   Response.Write "DEBUG> Form = " & request.Form & "<BR>"
> 	
> 	If Request.Form("CustomerID")<> " " Then
> 		rsUsers.CheckID = "CustomerID = ' " & Request
> ("CustomerID") & "'" 
> 	Else
> 		rsUsers.CheckID = "Email = ' " & Request.Form("Email") 
> & "'" & _
> 		                "AND Password = '" & Request.Form
> ("password") & "'"
>     If rsUsers.EOF Then
>     	rsUsers.AddNew
>     End If
>    End If
>    
>   Response.Write "DEBUG> Form = " & request.Form & "<BR>"
> 	rsUsers("Fname") = Request.Form("Fname")
>  	rsUsers("Lname") = Request.Form("Lname")
> 	rsUsers("Staddress1") = Request.Form("StAddress1")
> 	rsUsers("StAddress2") = Request.Form("StAddress2")
> 	rsUsers("City") = Request.Form("City")
> 	rsUsers("State") = Request.Form("State")
> 	rsUsers("ZipCode") = Request.Form("ZipCode")
> 	rsUsers("Country") = Request.Form("Country")
> 	rsUsers("Email") = Request.Form("Email")
> 	rsUsers("Phone") = Request.Form("Phone")
> 	rsUsers("Active") = True
> 	rsUsers("LastLogin") = Now
> 	rsUsers.Update                                      'Update 
> database
> 
> 	Dim strName, strValue
> 	 For each strField in rsUsers.Field
>  		strName = strField.Name
>  		strValue = strField.value
>  		Request(strName) = strValue
>  	Next
> 	Request("blnValidUser") = True          'verfiy that current user 
> is valid user of the system.
>    Response.Redirect "DisplayItem.asp"     'Takes registered users to 
> display item menu automatically.
> %>
> 
>  
>

Message #5 by ggebre@h... on Tue, 18 Jun 2002 22:20:22

I am working form validation using the example give on chapter 15 of 
Wrox's Begining ASP 3.0 pages, and I recieving this error that says Page 
cannot be displayed.  I am wondering what is this?  I am not getting 
anywhere?  What causes this error?  Here is the code for the program too 
thanks. 

<%

  Set rsUsers = Server.CreateObject("ADODB.RecordSet")
  rsUsers.Open Application("SQL_ConnectionString")
  
  Response.Write "DEBUG> Form = " & request.Form & "<BR>"
	
	If Request.Form("CustomerID")<> " " Then
		rsUsers.CheckID = "CustomerID = ' " & Request
("CustomerID") & "'" 
	Else
		rsUsers.CheckID = "Email = ' " & Request.Form("Email") 
& "'" & _
		                "AND Password = '" & Request.Form
("password") & "'"
    If rsUsers.EOF Then
    	rsUsers.AddNew
    End If
   End If
   
  Response.Write "DEBUG> Form = " & request.Form & "<BR>"
	rsUsers("Fname") = Request.Form("Fname")
 	rsUsers("Lname") = Request.Form("Lname")
	rsUsers("Staddress1") = Request.Form("StAddress1")
	rsUsers("StAddress2") = Request.Form("StAddress2")
	rsUsers("City") = Request.Form("City")
	rsUsers("State") = Request.Form("State")
	rsUsers("ZipCode") = Request.Form("ZipCode")
	rsUsers("Country") = Request.Form("Country")
	rsUsers("Email") = Request.Form("Email")
	rsUsers("Phone") = Request.Form("Phone")
	rsUsers("Active") = True
	rsUsers("LastLogin") = Now
	rsUsers.Update                                      'Update 
database

	Dim strName, strValue
	 For each strField in rsUsers.Field
 		strName = strField.Name
 		strValue = strField.value
 		Request(strName) = strValue
 	Next
	Request("blnValidUser") = True          'verfiy that current user 
is valid user of the system.
   Response.Redirect "DisplayItem.asp"     'Takes registered users to 
display item menu automatically.
%>

Return to Index

P2P Archives