参数类型错误 [英] Arguments are of the wrong type

问题描述

我收到以下错误：


ADODB.Recordset错误''800a0bb9''


参数错误类型，超出可接受的范围，或者在
彼此冲突。


/shop/results.asp,line 15


第15行是记录集的开放行。有人可以帮助


if isnull（session（whois））然后

response.Redirect（" ../ default.asp"）

else

getCon =应用程序（" connectionObject"）

set objshop = server.CreateObject（" adodb.recordset"）

dim categoryid

categoryid = request.querystring（" cat"）

objshop.open" select * from tblproducts其中catkey =" &安培; categoryid&"

order by catkey"，getcon，3,3

I''m getting the following error:

ADODB.Recordset error ''800a0bb9''

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/shop/results.asp, line 15

line 15 is the recordset open line. Can someone please help

if isnull(session("whois")) then
response.Redirect("../default.asp")
else
getCon=Application("connectionObject")
set objshop=server.CreateObject("adodb.recordset")
dim categoryid
categoryid = request.querystring("cat")
objshop.open "select * from tblproducts where catkey = " & categoryid &"
order by catkey",getcon,3,3

推荐答案

<％

categoryid = request.querystring（" cat"）

RESPONSE.WRITE" select * from tblproducts其中catkey =" &安培; categoryid&"

by catkey"

RESPONSE.END

％>


加载。你的查询看起来对吗？如果是这样，打开工具，对您的数据库运行

查询并尝试运行它。您没有说明您使用的是什么数据库类型，所以如果这是SQL，请使用查询分析器。访问，

查询编辑器窗口等。


雷在工作


" Erica" <尔*** @ discussions.microsoft.com>在消息中写道

news：34 ********************************** @ microsof t.com ...

<%
categoryid = request.querystring("cat")
RESPONSE.WRITE "select * from tblproducts where catkey = " & categoryid &"
order by catkey"
RESPONSE.END
%>

Load that. Does your query look right? If so, open up tool for running
queries against your database and try running it. You didn''t indicated what
database type you''re using, so if this is SQL, use Query Analyzer. Access,
the query editor window, etc.

Ray at work

"Erica" <Er***@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...

我收到以下错误：

ADODB.Recordset错误''800a0bb9''

参数是错误类型，超出可接受范围，或彼此冲突。

/shop/results.asp，第15行

第15行是记录集的开放行。有人可以请帮助

如果isnull（会话（whois））那么
response.Redirect（" ../ default.asp"）
else
getCon = Application（" connectionObject"）
设置objshop = server.CreateObject（" adodb.recordset"）
dim categoryid
categoryid = request.querystring（" cat"）
objshop.open" select * from tblproducts其中catkey =" &安培; categoryid&"
order by catkey"，getcon，3,3

I''m getting the following error:

ADODB.Recordset error ''800a0bb9''

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/shop/results.asp, line 15

line 15 is the recordset open line. Can someone please help

if isnull(session("whois")) then
response.Redirect("../default.asp")
else
getCon=Application("connectionObject")
set objshop=server.CreateObject("adodb.recordset")
dim categoryid
categoryid = request.querystring("cat")
objshop.open "select * from tblproducts where catkey = " & categoryid &"
order by catkey",getcon,3,3

sql语句是正确的。我正在使用Access数据库。


Ray Costanzo [MVP]"写道：

The sql statement is correct. I am using Access database.

"Ray Costanzo [MVP]" wrote:

<％
categoryid = request.querystring（" cat"）
RESPONSE.WRITE" select * from tblproducts where catkey =" &安培; categoryid&"
order by catkey"
RESPONSE.END
％>

加载它。你的查询看起来对吗？如果是这样，打开工具以对数据库运行查询并尝试运行它。您没有说明您正在使用的数据库类型，因此如果这是SQL，请使用查询分析器。访问，查询编辑器窗口等。

Ray在工作中

Erica <尔*** @ discussions.microsoft.com>在消息中写道
新闻：34 ********************************** @ microsof t.com。 ..

<%
categoryid = request.querystring("cat")
RESPONSE.WRITE "select * from tblproducts where catkey = " & categoryid &"
order by catkey"
RESPONSE.END
%>

Load that. Does your query look right? If so, open up tool for running
queries against your database and try running it. You didn''t indicated what
database type you''re using, so if this is SQL, use Query Analyzer. Access,
the query editor window, etc.

Ray at work

"Erica" <Er***@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...

我收到以下错误：

ADODB.Recordset错误''800a0bb9''

参数类型错误，超出可接受范围，或者彼此冲突。

/ shop/results.asp，第15行
第15行是记录集打开线。有人可以请帮助

如果isnull（会话（whois））那么
response.Redirect（" ../ default.asp"）
else
getCon = Application（" connectionObject"）
设置objshop = server.CreateObject（" adodb.recordset"）
dim categoryid
categoryid = request.querystring（" cat"）
objshop.open" select * from tblproducts其中catkey =" &安培; categoryid&"
order by catkey"，getcon，3,3

I''m getting the following error:

ADODB.Recordset error ''800a0bb9''

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/shop/results.asp, line 15

line 15 is the recordset open line. Can someone please help

if isnull(session("whois")) then
response.Redirect("../default.asp")
else
getCon=Application("connectionObject")
set objshop=server.CreateObject("adodb.recordset")
dim categoryid
categoryid = request.querystring("cat")
objshop.open "select * from tblproducts where catkey = " & categoryid &"
order by catkey",getcon,3,3

你验证了它通过复制和粘贴那个确切的查询是正确的吗？

在Access查询窗口中运行它？


Ray在家里


Erica <尔*** @ discussions.microsoft.com>在消息中写道

新闻：9F ********************************** @ microsof t.com ...

You verified that it is correct by copying and pasting that exact query and
running it in the Access query window?

Ray at home

"Erica" <Er***@discussions.microsoft.com> wrote in message
news:9F**********************************@microsof t.com...

sql语句是正确的。我正在使用Access数据库。

Ray Costanzo [MVP]"写道：

The sql statement is correct. I am using Access database.

"Ray Costanzo [MVP]" wrote:

<％
categoryid = request.querystring（" cat"）
RESPONSE.WRITE" select * from tblproducts where catkey =" &安培; categoryid
&"
按catkey排序"
RESPONSE.END
％>

加载它。你的查询看起来对吗？如果是这样，打开工具以对数据库运行查询并尝试运行它。你没有说明你正在使用什么数据库类型，所以如果这是SQL，请使用查询分析器。
访问，查询编辑器窗口等。

Ray在工作中

Erica <尔*** @ discussions.microsoft.com>在消息中写道
新闻：34 ********************************** @ microsof t.com。 ..

<%
categoryid = request.querystring("cat")
RESPONSE.WRITE "select * from tblproducts where catkey = " & categoryid
&"
order by catkey"
RESPONSE.END
%>

Load that. Does your query look right? If so, open up tool for running
queries against your database and try running it. You didn''t indicated
what
database type you''re using, so if this is SQL, use Query Analyzer.
Access,
the query editor window, etc.

Ray at work

"Erica" <Er***@discussions.microsoft.com> wrote in message
news:34**********************************@microsof t.com...

>我收到以下错误：
>
> ADODB.Recordset错误''800a0bb9''
>
>参数类型错误，超出可接受的范围，或者在
>中。相互冲突。
>
> /shop/results.asp，第15行
>
>第15行是记录集开放行。有人可以帮忙
>
> if isnull（session（" whois）））然后
> response.Redirect（" .. / default.asp"）
>否则
> getCon = Application（" connectionObject"）
> set objshop = server.CreateObject（" adodb.recordset"）
>昏暗的类别
> categoryid = request.querystring（" cat"）
> objshop.openselect * from tblproducts其中catkey =" &安培; categoryid
> &"
>按catkey命令，getcon，3,3

> I''m getting the following error:
>
> ADODB.Recordset error ''800a0bb9''
>
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
> /shop/results.asp, line 15
>
> line 15 is the recordset open line. Can someone please help
>
> if isnull(session("whois")) then
> response.Redirect("../default.asp")
> else
> getCon=Application("connectionObject")
> set objshop=server.CreateObject("adodb.recordset")
> dim categoryid
> categoryid = request.querystring("cat")
> objshop.open "select * from tblproducts where catkey = " & categoryid
> &"
> order by catkey",getcon,3,3

这篇关于参数类型错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！