数据库操作???????????????????????????????????????????????????????????????????????????????

[jack9527]

set conn=server.CreateObject("adodb.connection")
conn.open(MM_Conn_String)
if ordx<>"" then
sql="select * from workrep where recdate>"&datex&" and username='"&username&"' order by '"&ordx&"' desc"
else
sql="select * from workrep where recdate>"&datex&" and username='"&username&"' order by id desc"
end if
set rsxx=server.CreateObject("adodb.recordset")
rsxx.open sql,conn,1,1
end if
报错:

错误类型：
Microsoft VBScript 运行时错误 (0x800A000D)
类型不匹配: 'rsxx'
/oa1/repselect.asp, 第 88 行

[jack9527]

if request.Form("sure")="sure" then
datex=request.Form("repdate")
autor=request.Form("username")
ordx=""
ordx=trim(request.QueryString("ord"))
set conn=server.CreateObject("adodb.connection")
conn.open(MM_Conn_String)
if ordx<>"" then
sql="select * from workrep where recdate>"&datex&" and username='"&username&"' order by '"&ordx&"' desc"
else
sql="select * from workrep where recdate>"&datex&" and username='"&username&"' order by id desc"
end if
set rsxx=server.CreateObject("adodb.recordset")
rsxx.open sql,conn,1,1
end if

[jack9527]

..................

[wangjinmin1982]

Microsoft VBScript 运行时错误 (0x800A000D) --> 错误引用rs变量(rs对像已关闭或未定义)

[liuyangxuan]

sql="select * from workrep where recdate>"&datex&" and username='"&username&"' order by '"&ordx&"' desc"


'"&ordx&"' 按字符型排序？如果是文本型不用单引号。

[lienzhu]

把你的sql语句输出来

字符串型：两边要加单引号
日期类型：access数据库是两边加“#”；sql server数据库两边加单引号

[jack9527]

lienzhu(李强) 正解,谢谢