还是解决不了update问题！急死人了！

[jacbey]

<%

set update = Server.CreateObject("ADODB.Command")
update.ActiveConnection = MM_connContest_STRING
update.CommandText = "UPDATE 020421Contest SET selected = 1 WHERE id = " + Replace(update__MMColParam2, "'", "''") + ""
update.CommandType = 1
update.CommandTimeout = 0
update.Prepared = true
update.Execute()////这行的错误信息：Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
%>
到底是什么原因呢？*mdb的属性已经设为什么都没有了。asp的其他功能都没有问题。

[freezwy]

最好不要使用关键字做为变量的名字。
你可以这样试试。
sql="update....."
MM_connContest_STRING.execute(sql)

[jinyefeng]

也许数据库不好呢

[fdzxb]

UpSql = "UPDATE 020421Contest SET selected = 1 WHERE id = " + Replace(update__MMColParam2, "'", "''") + ""

conn.execute UpSql

[Lostinet]

你是VBSCRIPT啊。。怎么用+号？

[jacbey]

<%

set UpSelected = Server.CreateObject("ADODB.Command")
UpSelected.ActiveConnection = MM_connContest_STRING
UpSelected.CommandText = "UPDATE 020421Contest SET selected =1 WHERE id =" + Replace(UpSelected__MMColParam2, "'", "''") + ""
UpSelected.CommandType = 1
UpSelected.CommandTimeout = 0
UpSelected.Prepared = true
UpSql = "UPDATE 020421Contest SET selected = 1 WHERE id = " + Replace(update__MMColParam2, "'", "''") + ""
UpSelected.Execute UpSql/////这行还是出错：Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

%>
我使用dreamweaver ultradev生成代码在修改的，VBSCRIPT不太会，请高手一定帮我那忙啊！！！

[Lostinet]

UpSelected.CommandText = "UPDATE 020421Contest SET selected =1 WHERE id =" + Replace(UpSelected__MMColParam2, "'", "''") + ""
=>
UpSelected.CommandText = "UPDATE 020421Contest SET selected =1 WHERE id =" & Replace(UpSelected__MMColParam2, "'", "''") & ""

[jacbey]

Lostinet(www.lostinet.com) 的方法没有用，我见我其他页的代码用+是没有问题的。我的问题是：
1.无论我怎么改，update.Execute()////这行都出错
2.where id 到底怎么写呢？生成代码有错吗？