[thelist] SQL & ASP my favorite combination :-)

[Elfur Logadóttir]

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