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.dt d">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<title></title>
<meta http-equiv="content-type"
content="text/html";charset=w indows-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.val ue == "")
{
alert('Please enter your Name');
return false;
}
if(document.for m1.subject.valu e == "")
{
alert('Please enter the Subject');
return false;
}
if(document.for m1.feedback.val ue == "")
{
alert('Please enter the Feedback');
return false;
}
else
return true;
}
//-->
</script>
</head>
<body>
<form action="feedbac kresponse.asp" name="form1" method="post"
onsubmit="retur n 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\fee dback.jpg" width="747"></td>
</tr>
</table>
<br>
<table border="0" style="border-collapse:collap se" cellspacing="0"
cellpadding="0" align="left" width="150">
<tr>
<td><embed src="images\but tonList.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\bo ysHostellers.jp g" title="click to see a larger
view"><img src="images\boy sHostellers.jpg " width="187" height="133"
border="0"></a>
</td>
</tr>
<tr>
<td align="center"> <img src="images\lin e.jpg">
</td>
</tr>
<tr>
<td><embed src="images\ici tAD.swf" border="0" >
</td>
</tr>
</table>
<table width="500" align="center" border="0" cellspacing="0"
cellpadding="0" style="border-collpase:collap se" >
<tr>
<td colspan="2"><p
align="justify" > &n bsp;   ; &n bsp; Pleas e
feel free to give any suggestions as it would help us to improve the
site. 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 :&nbs p; & nbsp; &nbs p; </p></td>
<td width="70%" align="left" ><input type="text" size="25"
maxlength="25" name="feedbackb y">
</td>
</tr>
<tr>
<td width="30%"><p
align="center"> Subject :& nbsp; &nbs p; & nbsp; &nbs p; & 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 : &nb sp; &nb sp; &nb sp; </p></td>
<td width="70%" align="left" ><textarea cols="30" rows="10"
name="feedback" ></textarea>
</td>
</tr>
<tr>
<td align="center" colspan="2"><in put 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.CreateOb ject("ADODB.Con nection")
'db.open strConn
'Set db = Server.CreateOb ject("ADODB.Con nection")
'strConn="DRIVE R={Microsoft Access Driver (*.mdb)}; "
'strConn=strCon n & "DBQ=" & Server.mappath( "login.mdb" )
'strConn=strCon n & "DBQ=" & "C:\Inetpub\www root\login.mdb"
db.Open strConn
%>
<%
feedbackby=requ est.form("feedb ackby")
subject=request .form("subject" )
feedback=reques t.form("feedbac k")
db.Execute "insert into admins (feedbackby,sub ject,feedback) VALUES
('" & feedbackby & "','" & subject & "','" & feedback &"')"
response.write( "thank you for the feedback")
%>
please HELP ME
