[thelist] SQL & ASP my favorite combination :-)
Elfur Logadóttir
elfur at lists.evolt.org
Thu May 10 06:44:30 CDT 2001
From: "Don Makoviney" <DonM at allensysgroup.com>
| You need to make sure that the directory the DB is in has write permissions.
|
| DM
thanks Don,
that is the case, the directory has write permissions, but the code is still
barfing.
the url is as before
http://www.el.is/cole/tellmemore.asp
try to submit anything and you get the error:
"Operation must use an updateable query"
where the error line is the "objConn.Execute strsql"
elfur.is || elfur.com
######### reposting the changed offending code #############
Dim strPhysicalPath 'physical path to DB
Dim objConn 'object Connection
strPhysicalPath = Server.MapPath("pathtodb")
set objConn = server.CreateObject("ADODB.connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source= " & strPhysicalPath
Dim strName, strEmail, strType, strContent
strName = Request.form("name")
strEmail = Request.form("email")
strType = Request.form("type")
strContent = Request.form("content")
strsql = "INSERT INTO tellmemore (name,email,type,content) VALUES ('" & strName
& "', '" & strEmail & "', '" & strType & "', '" & strContent & "')"
objConn.Execute strsql
objConn.Close
set objConn = Nothing
More information about the thelist
mailing list