Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: server error


Message #1 by elizabetas@m... on Fri, 4 Jan 2002 03:46:29
hi,



i keep on getting a error message from wrox list manager that my message 

is rejected because it has attachment. i'm not trying to attach 

anything , what can be the problem?



any way,



i have a page that is attempting to add new row to a table. i'm 

getting "500 internal server error"

what can be wrong?



here is the code:



<!-- #include file="Connection.asp" -->





<!-- METADATA TYPE="typelib" 

FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->



              

<HTML>

<HEAD><LINK rel="stylesheet" type="text/css" href="Style.css">

<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">

<body>

<%

dim Room

Room = Request.Form ("Room")



dim Equipment

Equipment = Request.Form ("Equipment")



dim Part

Part = Request.Form ("Part")



dim Description

Description = Request.Form ("Description")



Response.Write Room 



Response.Write Equipment

 

Response.Write Part



Response.Write Description 



dim ServDate 

ServDate = Date



dim rsUpdate

set rsUpdate = Server.CreateObject ("ADODB.Recordset")

rsUpdate.Open "ProblemLog", strConnect, adOpenDynamic, adLockOptimistic

rsUpdate.AddNew



rsUpdate!LogEquipment = Equipment

rsUpdate!LogDate = ServDate 

rsUpdate!LogPart = Part

rsUpdate!LogUser = Session ("Passw")

rsUpdate!LogDescription = Description

rsUpdate!LogRoom = Room

 



%>

ok

</body>

</html> 
Message #2 by Sam Clohesy <sam@e...> on Fri, 4 Jan 2002 09:01:45 -0000
Try this (in IE) 



Tools

Internet Options

Advanced

and untick the 'show friendly HTTP error messages'



That will give you the error message



Thanks



Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: elizabetas@m... [mailto:elizabetas@m...]

Sent: 04 January 2002 03:46

To: ASP Databases

Subject: [asp_databases] server error





hi,



i keep on getting a error message from wrox list manager that my message 

is rejected because it has attachment. i'm not trying to attach 

anything , what can be the problem?



any way,



i have a page that is attempting to add new row to a table. i'm 

getting "500 internal server error"

what can be wrong?



here is the code:



<!-- #include file="Connection.asp" -->





<!-- METADATA TYPE="typelib" 

FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->



              

<HTML>

<HEAD><LINK rel="stylesheet" type="text/css" href="Style.css">

<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">

<body>

<%

dim Room

Room = Request.Form ("Room")



dim Equipment

Equipment = Request.Form ("Equipment")



dim Part

Part = Request.Form ("Part")



dim Description

Description = Request.Form ("Description")



Response.Write Room 



Response.Write Equipment

 

Response.Write Part



Response.Write Description 



dim ServDate 

ServDate = Date



dim rsUpdate

set rsUpdate = Server.CreateObject ("ADODB.Recordset")

rsUpdate.Open "ProblemLog", strConnect, adOpenDynamic, adLockOptimistic

rsUpdate.AddNew



rsUpdate!LogEquipment = Equipment

rsUpdate!LogDate = ServDate 

rsUpdate!LogPart = Part

rsUpdate!LogUser = Session ("Passw")

rsUpdate!LogDescription = Description

rsUpdate!LogRoom = Room

 



%>

ok

</body>

</html> 




$subst('Email.Unsub').

Message #3 by "Drew, Ron" <RDrew@B...> on Fri, 4 Jan 2002 08:37:12 -0500
I think 500 is Variable Not Assigned



-----Original Message-----

From: elizabetas@m... [mailto:elizabetas@m...]

Sent: Thursday, January 03, 2002 10:46 PM

To: ASP Databases

Subject: [asp_databases] server error





hi,



i keep on getting a error message from wrox list manager that my message



is rejected because it has attachment. i'm not trying to attach

anything , what can be the problem?



any way,



i have a page that is attempting to add new row to a table. i'm

getting "500 internal server error"

what can be wrong?



here is the code:



<!-- #include file=3D"Connection.asp" -->





<!-- METADATA TYPE=3D"typelib"

FILE=3D"C:\Program Files\Common Files\System\ado\msado15.dll" -->



             

<HTML>

<HEAD>

<LINK rel=3D"stylesheet" type=3D"text/css" href=3D"Style.css">

<META NAME=3D"GENERATOR" Content=3D"Microsoft Visual Studio 6.0">

<body>

<%

dim Room

Room =3D Request.Form ("Room")



dim Equipment

Equipment =3D Request.Form ("Equipment")



dim Part

Part =3D Request.Form ("Part")



dim Description

Description =3D Request.Form ("Description")



Response.Write Room

Response.Write Equipment

Response.Write Part

Response.Write Description



dim ServDate

ServDate =3D Date



dim rsUpdate

set rsUpdate =3D Server.CreateObject ("ADODB.Recordset")

rsUpdate.Open "ProblemLog", strConnect, adOpenDynamic, adLockOptimistic

rsUpdate.AddNew



rsUpdate!LogEquipment =3D Equipment

rsUpdate!LogDate =3D ServDate

rsUpdate!LogPart =3D Part

rsUpdate!LogUser =3D Session ("Passw")

rsUpdate!LogDescription =3D Description

rsUpdate!LogRoom =3D Room





%>

ok

</body>

</html>




$subst('Email.Unsub').


  Return to Index