查询

[sisiz]

查询一个表里的两个字段的值都等于ID 的记录集怎么写？我是这样写的

newpage.asp里写的是
<a href="huifu-info.asp?ID=<%=reco("ID")%>"><%=reco("biaoti")%></A>

huifu-info.asp页里写的是
session("djhf")=request.QueryString("ID")
authorid=trim(request.QueryString("ID"))

sql="select * from luntan where ID=" & authorid & " OR djhf="& authorid & "order by riqi ASC"
reco.open sql,conn,1,1
但是总是提示reco.open sql,conn,1,1有错误！是不是参数传递错误！

[cqfeng]

response.write sql
response.end

sql="select * from luntan where ID="& authorid &" OR djhf="&authorid & " order by riqi ASC"
字符型加''

[sisiz]

ID 和djhf是数字行的！

[enthuris]

session("djhf")=request.QueryString("ID")
authorid=trim(request.QueryString("ID"))
set rsco=server.createobject("adodb.recordset")
sql="select * from luntan where ID=" & authorid & " OR djhf="& authorid & "order by riqi ASC"
reco.open sql,conn,1,1
字符型加''

[cqfeng]

try:

sql="select * from [luntan] where [ID]="& authorid &" OR [djhf]="&authorid & " order by [riqi] ASC"