November 4th, 2009, 11:27 PM
|
|
Contributing User
|
|
Join Date: Nov 2005
Posts: 102
Time spent in forums: 23 h 31 m 14 sec
Reputation Power: 5
|
|
|
VBScript - Database - Recordset - Saving new record
Code:
<!--#include file="db.asp" -->
<%
Dim LastName, FirstName, MI
LastName = request.Form("txtLastName")
FirstName = request.Form("txtFirstName")
MI = request.Form("txtMI")
if LastName <> "" then
sql="Insert into tblStudent(LastName, FirstName, MI) Values('"&LastName&"','"&FirstName&"','"&MI&"')"
db.Execute (sql)
end if
%>
I've tried the code above but i encounter the following error:
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/websiteko/student.asp, line 16
pls see the attached file for you to be able to check my asp file.
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
