Re: radio button ASP question??

•

•

•

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 423,879 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,197 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

radio button ASP question??

•

•

Join Date: Jun 2005

Location: California

Posts: 92

Reputation: djbsabkcb is an unknown quantity at this point

djbsabkcb is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

djbsabkcb is offline

Offline

Junior Poster in Training

Re: radio button ASP question??

#26

Aug 25th, 2005

This is the error message I am receiving now. Someone told me to check to make sure that they have permission for that folder. So I went to the inetpub and elms folders and allowed web sharing for those folders but still received same error message. I am going to keep at it. I posted the error code and html/asp code below.

This is the error code.

Help with Code Tags

(Toggle Plain Text)

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft JET Database Engine (0x80004005)
'C:\Inetpub\wwwroot\eLMS\eLMS Table 1\eLMS Database Table.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/eLMS/processform.asp, line 65


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) 

Page:
POST 156 bytes to /eLMS/processform.asp

POST Data:
reason=Received+e-mail+message+concerning+Learning+Expiration+Notification&response=6+-+12+hours&resolved=No&rate=Satisfied&comments=tuyjtyujt&action=SUBMIT 

Time:
Thursday, August 25, 2005, 11:49:15 AM 


More information:
Microsoft Support

This is the ASP code.

Help with Code Tags

(Toggle Plain Text)



			
	
				
		
<html>
<head>

<body>
<title>
  eLMS Feedback Form Process
</title>



<body bgcolor = "white">

<hr>
<h1>
eLMS Survey
</h1>

<blockquote>

	<b>  Reason for contacting:</b> <%=Request.Form("reason")%> <br><br>


 		
	
 	<b>  Response Time:</b> <%=Request.Form("response")%> <br><br>

		


	<b>  Issue Resolved:</b> <%=Request.Form("resolved")%> <br><br>

		

	<b>  Rate Service:</b> <%=Request.Form("rate")%> <br><br>

		
	

	<b>  Comments: </b>  <%=Request.Form("comments")%> <br><br><br>

</blockquote>



<!-- The following code writes data to the Microsoft Access database -->
<%

	<!--DIMENSION VARIABLES-->
	Dim adoCon		<!-- HOLDS THE DATABASE CONNECTION OBJECT-->     
	Dim strSQL		<!-- HOLDS THE SQL QUERY FOR THE DATABASE-->



	Set adoCon  = Server.CreateObject("ADODB.Connection")


	<!-- SET AN ACTIVE CONNECTION TO THE CONNECTION OBJECT-->

			adoCon.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("eLMS Table 1\eLMS Database Table.mdb")

		 <!-- 	adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\eLMS Table 1\eLMS Database Table" & Server.MapPath("eLMS Table 1\eLMS Database Table.mdb") -->



	<!--the "blank" data value ( '' ) is intented for an "auto value" field like and id auto increment column.-->
	<!--Using this method the number of values in the strSQL string must be the same as the number of columns in the table.-->
	<!--Initialize the strSQL variable with an SQL statement to query the database-->
	
		strSQL = "INSERT INTO eLMS Table 1 VALUES('', '" & Request.Form("reason") & "', '" & Request.Form("response") & "', '" & Request.Form("resolved") & "', '" & Request.Form("rate") & "', '" & Request.Form("comments") & "');"




	
	<!--insert new data into table--> 
	
		adoCon.Execute strSQL


	<!--Reset server objects-->

		Set adoCon = Nothing


	<!--Redirect to some page -->
		
		Response.Redirect " thanks.htm"


%>
 <!--The end of the code for writing to the Microsoft Access Database-->




	

</body>
</html>

</head>



			
	
				
		
<html>
<head>

<body>
<title>
  eLMS Feedback Form Process
</title>



<body bgcolor = "white">

<hr>
<h1>
eLMS Survey
</h1>

<blockquote>

	<b>  Reason for contacting:</b> <%=Request.Form("reason")%> <br><br>


 		
	
 	<b>  Response Time:</b> <%=Request.Form("response")%> <br><br>

		


	<b>  Issue Resolved:</b> <%=Request.Form("resolved")%> <br><br>

		

	<b>  Rate Service:</b> <%=Request.Form("rate")%> <br><br>

		
	

	<b>  Comments: </b>  <%=Request.Form("comments")%> <br><br><br>

</blockquote>



<!-- The following code writes data to the Microsoft Access database -->
<%

	<!--DIMENSION VARIABLES-->
	Dim adoCon		<!-- HOLDS THE DATABASE CONNECTION OBJECT-->     
	Dim strSQL		<!-- HOLDS THE SQL QUERY FOR THE DATABASE-->



	Set adoCon  = Server.CreateObject("ADODB.Connection")


	<!-- SET AN ACTIVE CONNECTION TO THE CONNECTION OBJECT-->

			adoCon.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("eLMS Table 1\eLMS Database Table.mdb")

		 <!-- 	adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\eLMS Table 1\eLMS Database Table" & Server.MapPath("eLMS Table 1\eLMS Database Table.mdb") -->



	<!--the "blank" data value ( '' ) is intented for an "auto value" field like and id auto increment column.-->
	<!--Using this method the number of values in the strSQL string must be the same as the number of columns in the table.-->
	<!--Initialize the strSQL variable with an SQL statement to query the database-->
	
		strSQL = "INSERT INTO eLMS Table 1 VALUES('', '" & Request.Form("reason") & "', '" & Request.Form("response") & "', '" & Request.Form("resolved") & "', '" & Request.Form("rate") & "', '" & Request.Form("comments") & "');"




	
	<!--insert new data into table--> 
	
		adoCon.Execute strSQL


	<!--Reset server objects-->

		Set adoCon = Nothing


	<!--Redirect to some page -->
		
		Response.Redirect " thanks.htm"


%>
 <!--The end of the code for writing to the Microsoft Access Database-->




	

</body>
</html>

</head>

Reply With Quote

Forum Highlights

ASP Forum
Today's Posts
Unanswered Threads

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 423,879

Users Online Now: 4,197

Active IRC Users: 26

Forum Threads: 135,723

Forum Posts: 689,920

Code Snippets: 903

Blogs: 150

Blog Entries: 2,286

Directory Links: 569