Am having problem with my queries. Thought it was okay, after testing
it on a different host but trying it out on my host always give this
error :
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/module/cms/cmsupdate.asp, line 28
this is the code below:
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>content management system</title>
</head>
<body bgcolor="#000080" text="#FFFFFF">
<!-- #include file="conn.asp" -->
<%
id=request("id")
title=request("title")
header=request("header")
content=request("content")
id=request("id")
sql="UPDATE cmstb "
sql=sql & "SET title=" '"& title &"' "
sql= sql & "header='" & header & "' ,"
sql= sql & "content='" & content &"' "
sql=sql & " WHERE id="& id
set rs=conn.execute ( sql)
if err < 0 then
response.write " The page with " & title & " as title has been
updated"
else
response.write "error occured : " & err.description
end if
rs.close
rs=nothing
conn.close
set conn=nothing
%>
hope anyone can help out.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
