Code:<html> <body> <form action="feedbacksent.asp" method="get" enctype="text/plain"> <h3>Your feedback is important.</h3> <h5>To send your comments put your:</h5><br> Name:<br> <input type="text" name="name" size="18" value="Put your name" class="form-input" onBlur="if(this.value==''){this.value='Put your name';}" onFocus="if(this.value=='Put your name'){this.value='';}"> <br> Email:<br> <input type="text" name="email" size="22" value="Put your email address" class="form-input" onBlur="if(this.value==''){this.value='Put your email address';}" onFocus="if(this.value=='Put your email address'){this.value='';}"> <br> Subject:<br> <input type="text" name="subject" size="40" value="Put your subject" class="form-input" onBlur="if(this.value==''){this.value='Put your subject';}" onFocus="if(this.value=='Put your subject'){this.value='';}"> <br> <textarea rows="10" name="comment" cols="60" value="Put your comments" class="form-input" onBlur="if(this.value==''){this.value='Put your comments';}" onFocus="if(this.value=='Put your comments'){this.value='';}"></textarea> <br><br> <input type="submit" value="Send"> <input type="reset" value="Reset"> </form> </body> </html>Code:<html> <body> <% 'Dim connStr 'connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Kjv.mdb") set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "kjv.mdb" sql="INSERT INTO feedback (ID,name," sql=sql & "subject,email,comment)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("ID") & "'," sql=sql & "'" & Request.Form("name") & "'," sql=sql & "'" & Request.Form("email") & "'," sql=sql & "'" & Request.Form("subject") & "'," sql=sql & "'" & Request.Form("comment") & "')" on error resume next conn.Execute sql,recaffected if err<>0 then Response.Write("No update permissions!") else Response.Write("<h3>" & recaffected & " record added</h3>") end if conn.close %> </body> </html>




Reply With Quote