[thelist] SQL & ASP my favorite combination :-)
Elfur Logadóttir
elfur at lists.evolt.org
Wed May 9 10:35:50 CDT 2001
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*
More information about the thelist
mailing list