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

[Elfur Logadóttir]

ok, so I'm doing what I thought would be a simple update query.

I'm just supposed to be grabbing the content from the form and inserting it into
the db.

The error I get is "Operation must use an updateable query. "

this is the code:
(and the error line is the objCmd.Execute line)

set objCmd = server.CreateObject("adodb.command")
objCmd.ActiveConnection = objConn

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 &
"')"

objCmd.CommandText = strsql
objCmd.Execute    'here the darn thing barfs

set objCmd = Nothing

the page can be found at:
http://www.el.is/cole/tellmemore.asp

where you can test the offending code

thanks
elfur.is
*the ever-trying one*