By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,953 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,953 IT Pros & Developers. It's quick & easy.

what is the error here?

P: n/a
here is a piece of form field and an asp action codes so the thing is
when i started working on this, at first it was working but after i
formatted my c drive of my computer. i started recieving errors like
this "operations must use an updateable query"

here is the form part:-

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<title></title>
<meta http-equiv="content-type"
content="text/html";charset=windows-1252"/>

<LINK REl="stylesheet" HREF="style_cin.css" TYPE="text/css"/>
<style type="text/css">
<!--
td.heading{font-family:times new roman;font-size:12pt;color:#858585}
-->

</style>
<script type="text/javascript">
<!--
function validate()
{
if (document.form1.feedbackby.value == "")
{
alert('Please enter your Name');
return false;
}
if(document.form1.subject.value == "")
{
alert('Please enter the Subject');
return false;
}

if(document.form1.feedback.value == "")
{
alert('Please enter the Feedback');
return false;
}

else
return true;
}
//-->
</script>
</head>
<body>
<form action="feedbackresponse.asp" name="form1" method="post"
onsubmit="return validate();">
<!-- #include file="includes\footlinks.asp" -->
<!-- #include file="includes\copyright.html" -->
<!--LEFT THINGS-->
<table border="0" width="733" cellspacing="0" cellpadding="0"
align="center">
<tr>
<td><img src="images\feedback.jpg" width="747"></td>
</tr>
</table>
<br>
<table border="0" style="border-collapse:collapse" cellspacing="0"
cellpadding="0" align="left" width="150">

<tr>
<td><embed src="images\buttonList.swf" border="0"></embed>
</td>
</tr>
<tr>
<td valign="top" halign="center">
<img src="images\pic.jpg" border="0">
</td>
</tr>
<tr>
<td align="left">
<a href="images\boysHostellers.jpg" title="click to see a larger
view"><img src="images\boysHostellers.jpg" width="187" height="133"
border="0"></a>
</td>
</tr>
<tr>
<td align="center">&nbsp;<img src="images\line.jpg">
</td>
</tr>
<tr>
<td><embed src="images\icitAD.swf" border="0" >
</td>
</tr>
</table>
<table width="500" align="center" border="0" cellspacing="0"
cellpadding="0" style="border-collpase:collapse" >
<tr>
<td colspan="2"><p
align="justify">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;Please
feel free to give any suggestions as it would help us to improve the
site.&nbsp;If you have any problem regarding your account then this
place would help you to contact or give feedback to the SITE
ADMINISTRATOR directly.</p></td>
</tr>
<tr>
<td height="15">
</td>
</tr>
<tr>
<td width="30%"><p
align="center">Name&nbsp;:&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;</p></td>
<td width="70%" align="left" ><input type="text" size="25"
maxlength="25" name="feedbackby">
</td>
</tr>
<tr>
<td width="30%"><p
align="center">Subject&nbsp;:&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p></td>
<td width="70%" align="left" ><input type="text" size="25"
maxlength="25" name="subject">
</td>
</tr>
<tr>
<td width="30%" valign="top"><p
align="center">Feedback&nbsp;:&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;</p></td>
<td width="70%" align="left" ><textarea cols="30" rows="10"
name="feedback"></textarea>
</td>
</tr>
<tr>
<td align="center" colspan="2"><input type="submit" value="submit">
</td>
</tr>
</table>
</form>
</body>
</html>
AND HERE's THE ASP ACTION PART:-

here the DSN is "login"

<%

dim db
dim strConn
strConn = "login"
Set db = Server.CreateObject("ADODB.Connection")
'db.open strConn

'Set db = Server.CreateObject("ADODB.Connection")
'strConn="DRIVER={Microsoft Access Driver (*.mdb)}; "
'strConn=strConn & "DBQ=" & Server.mappath("login.mdb")
'strConn=strConn & "DBQ=" & "C:\Inetpub\wwwroot\login.mdb"

db.Open strConn
%>

<%
feedbackby=request.form("feedbackby")
subject=request.form("subject")
feedback=request.form("feedback")


db.Execute "insert into admins (feedbackby,subject,feedback) VALUES
('" & feedbackby & "','" & subject & "','" & feedback &"')"
response.write("thank you for the feedback")
%>

please HELP ME

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.