在server sql中调试通过的sql语句为什么在asp中无法运行?

[anneyang]

sql语句如下:
SELECT reportinfo.title AS title, username.username AS username
FROM reportindex, reportinfo, username
WHERE reportindex.readflag = 1 AND reportindex.root = 203161409 AND
reportindex.reportid = reportinfo.infoid AND reportindex.userid = username.id

在asp中的错误提示如下:
ADODB.Recordset 错误 '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

[苛子]

server sql中调试通过的sql语句为什么在asp中无法运行?
作　　

因为SQL SERVER中可以以忽略单引号而 ASP中则不能
所以会提示类型出错

[tripofdream]

你的Connection和Recordset都沒有問題嗎?

[canbo]

root:=Request.QueryFields.Values['reportid'];'这是什么意思，在ASP2。0里只有 REQUEST。QUERYSTRING("")还有AND reportindex.root=:root AND
这个好像有错吧。
Queryanswer.Parameters.ParamByName('root').Value:=root'queryanswer是什么对像？
其后的value:=root好像不懂得 ，我也不懂，解决了不要忘了告诉我一声。

[anneyang]

我的程序如下:
TADOQuery中的SQL为:
SELECT reportindex.root AS root, reportinfo.title AS title, reportinfo.rcontent AS rcontent,
reportindex.reportdate AS reportdate, username.username AS username
FROM reportindex, reportinfo, username
WHERE reportindex.readflag = 1 AND reportindex.root=:root AND
reportindex.reportid = reportinfo.infoid AND reportindex.userid = username.id
其中reportindx.root为integer.
程序部分如下:
root integer;
root:=Request.QueryFields.Values['reportid'];
Queryanswer.Parameters.ParamByName('root').Value:=root;//在这条语句中出了问题

请高手帮忙改正.

[tripofdream]

僅這一部分看不出來有什么問題.

[anneyang]

我终于发现问题所在了.
原来不能用root做变量名.