sql问题，在线等

[sisiz]

我想满足三个条件的所有记录，我的代码是：
sql="select * from gw where name=request("name") and dizhi=request("dizhi") and dianhua=request("dianhua")"
但是提示错误，应该怎么写？？？谢谢！！！

[angelheavens]

sql="select * from gw where name='"&trim(request("name"))&"' and dizhi='"&"trim(request("dizhi"))&"' and dianhua='"&trim(request("dianhua"))&"'"

[bananasmiling]

name=request("name")
dizhi=trim(request("dizhi"))
dianhua=request("dianhua")

sql="select * from gw where name='"&name&"'and dizhi='"&dizhi&"' and dianhua='"&dianhua&"'"
conn.execute(sql)

[guiwj]

你的Request("")属于变量，三个Request("")前后都要加上单引号！

[gmlxf]

sql="select * from gw where name='" & request("name") "' and dizhi='" & request("dizhi") & "'and dianhua='" & request("dianhua") & "'"

注意：如果是数字类型，则变量前后的那两个'是不要加的！