Question

ASP怎样读取和更新表格中部分数据

我的一个表里面有多个记录,我只想更新adderss,tel,name这三个字段,可里面还有id等其它数据,<%
if request("submit")="确认修改" then
id=request("id")
names=request("names")
adders=request("adders")
tel=request("tel")
if adders="" or tel="" or names="" then
Response.Write("<script language=""javascript"">alert('请把信息填写完全！');location='"&myself&"?id="&id&"';</script>")
Response.End()
else
set rs=Server.CreateObject("Adodb.RecordSet")
sql="select id names adders tel zips from sales"
rs.open sql,conn,3,3
rs("names")=names
rs("adders")=adders
rs("tel")=tel
rs.update%>
这是我的部分代码,可是会出错:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'id names adders tel' 中。
/abc/member/umember.asp, 第 26 行

Answer 1

,<%
if request("submit")="确认修改" then
id=request("id")
names=request("names")
adders=request("adders")
tel=request("tel")
if adders="" or tel="" or names="" then
Response.Write("<script language=""javascript"">alert('请把信息填写完全！');location='"&myself&"?id="&id&"';</script>")
Response.End()
else

field1=array("names","adders")
value1=array(names,adders)
sql="UPDATE " & table & " SET "
for i=0 to ubound(field1)
sql = sql & field1(i) & "='" & replace(value1(i),"'","''") & "'"
if i <> ubound(field1) then
sql=sql & ","
else
sql=sql & " where id=" & id
end if
next

Answer 2

用3，3更新的话 这样写
sql="select * from [sales] where id="&id&" "
rs.open sql,conn,3,3
rs("names")=names
rs("adders")=adders
rs("tel")=tel
rs.update

Answer 3

这样写：
sql="update sales set names='newname',adders='newaddr',tel='newtel',zips='newzips' where id=123"
rs.execute sql,conn

Answer 4

ID是不能更新的吧.不要把ID放进去看行不行.

Answer 5

狗狗狗狗乖 - 试用期 一级

回答的很好了