if act="auc" then
sqldel="delete from auctions where aucid in (" & uid & ")"
sqldel="delete from msg where aucid in (" & uid & ")"
elseif act="ly" then
sqldel="delete from msg where msgid in ("& uid &")"
else
response.write"<script language=javascript>alert('数据删除失败！');history.back(-1);</script>"
response.end
end if



前三句是要删除auctions和msg表中auicd等于请求uid的所有记录，但执行下来却没有删除任任何记录，如何改成以下语句，则只删除一个表中的记录，如何才能删除两表中aucid等于请求uid的语句

if act="auc" then
sqldel="delete from auctions where aucid in (" & uid & ")"
elseif act="auc" then
sqldel="delete from msg where aucid in (" & uid & ")"
elseif act="ly" then
sqldel="delete from msg where msgid in ("& uid &")"
else
response.write"<script language=javascript>alert('数据删除失败！');history.back(-1);</script>"
response.end
end if

请朋友们看一下，先谢谢了

这个是你PHP语言逻辑上的错误，不是SQL语句的问题。

一句T-SQL语句无法对多张表格执行更新、插入、删除操作，如欲达到前述目的，请参考触发器的用法