怎么错了

[bbkaren]

FROM 子句语法错误。

sql="select * from user where id='"&u_id&"'"



＿＿＿＿＿＿＿＿＿＿＿＿＿＿＿
user是一个表

<!--#include file="conn.asp"-->
<%
dim sql
dim rs
dim u_id
dim u_pwd
u_id=trim(request("id"))
u_pwd=cstr(request("pwd"))
sql="select * from user where id='"&u_id&"'"
set rs=conn.execute(sql)
...

[say1no2]

sql="select * from user where id='"&u_id&"'"
改成

sql="select * from [user] where id="&u_id

[say1no2]

user是关键字

[bbkaren]

对啊，竟然...
谢谢