如何在一个asp文件中同时实现多表的更新？

[howmily]

如何在一个asp文件中同时实现多表的更新？
初学asp，不知下面的语句哪里出错了？
FType=REQUEST.form("FType")
FTippro=REQUEST.form("FTippro")
……
set rs=server.CreateObject("adodb.recordset")
sql="select * from users where FItemID="&xiugai
rs.open sql,conn,3,3

rs("FuserName")=FuserName
rs("Fpassword")=Fpassword
……
rs.update

set rss=server.CreateObject("adodb.recordset")
if FType=1 then
sql2="select * from Company where FItemID="&xiugai
rss.open sql2,conn,3,3

rss("FCompany")=FCompany
rss("FCorporation")=FCorporation
……
rss.update
else
sql2="select * from Consignor where FItemID="&xiugai
rss.open sql2,conn,3,3
rss("FCompany")=FCompany
rss("FCorporation")=FCorporation
……
rss.update

end if

[胖河马]

什么错误提示？

[ttt2]

rs.open sql,conn,1,3

[pp4u]

不用定义这么多recordset直接用conn的update语句就好了

[xxrl]

FType=trim(REQUEST.form("FType"))
FTippro=trim(REQUEST.form("FTippro"))
……
set rs=server.CreateObject("adodb.recordset")
sql="select * from users where FItemID='"&xiugai&"'"
rs.open sql,conn,1,2

rs("FuserName")=FuserName
rs("Fpassword")=Fpassword
……
rs.update

set rss=server.CreateObject("adodb.recordset")
if FType=1 then
sql2="select * from Company where FItemID='"&xiugai&"'"
rss.open sql2,conn,1,2
rss("FCompany")=FCompany
rss("FCorporation")=FCorporation
……
rss.update
else
sql2="select * from Consignor where FItemID='"&xiugai&"'"
rss.open sql2,conn,1,2
rss("FCompany")=FCompany
rss("FCorporation")=FCorporation
……
rss.update

end if
rs.close
rss.close

[huiyuehuiyue]

sql="select * from users where FItemID='"&xiugai&"'"

sql2="select * from Company where FItemID='"&xiugai&"'"

sql2="select * from Consignor where FItemID='"&xiugai&"'"

查找字符串字段的时候一定要加上单引号