ORDER BY子句有问题 [英] Trouble with ORDER BY clause
问题描述
大家好
我不确定ASP是不是问题，但我的SQL语句对我来说似乎很好。
这个工作正常：
strSQL =" SELECT [_RechPat]。* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri.cod_niv WHERE NivPatri.position = 2" ;
set rs = CreateRecordset（strSQL）
这不起作用：
strSQL =" SELECT [_RechPat ]。*来自_RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri.cod_niv WHERE NivPatri.position = 2 ORDER BY
[_RechPat] .cod_patrim ASC"
设置rs = CreateRecordset（strSQL）
错误号码：-2147467259
错误描述：未指定错误（法语：Erreur non spécifiée）
1. ORDER BY子句在其他一些记录集中工作正常。
2.这个SQL语句工作正常（我用MS设计和测试我的SQL查询
ACCESS）
3.数据库是MS ACCESS 2000
4.服务器= IIS 5.0
任何想法？
Hi all
I''m not sure ASP is the problem, but my SQL statement seems fine to me.
This works fine :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2"
set rs = CreateRecordset(strSQL)
This doesn''t work :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2 ORDER BY
[_RechPat].cod_patrim ASC"
set rs = CreateRecordset(strSQL)
Error Number : -2147467259
Error Description : Unspecified Error (in french : Erreur non spécifiée)
1. ORDER BY clauses work fine in some other recordsets.
2. This SQL statement works fine ( i design and test my SQL queries with MS
ACCESS)
3. Database is MS ACCESS 2000
4. Server = IIS 5.0
Any ideas ?
推荐答案
Peroq写道：
大家好
我不确定ASP是不是问题，但我的SQL语句对我来说似乎很好。
这很好用：
strSQL =" SELECT [_RechPat]。* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri.cod_niv WHERE NivPatri.position = 2"
set rs = CreateRecordset（strSQL）
这不起作用：
strSQL =" SELECT [_RechPat]。* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri.cod_niv WHERE NivPatri.position = 2 ORDER
BY [_RechPat] .cod_patrim ASC"
设置rs = CreateRecordset（strSQL）
错误编号：-2147467259
错误说明：未指定错误（法语：Erreur non
spécifiée）
1. ORDER BY子句在其他一些记录集中工作正常。
2.此SQL语句工作正常（i设计用MS ACCESS测试我的SQL查询
3.数据库是MS ACCESS 2000
4.服务器= IIS 5.0
任何想法？
Hi all
I''m not sure ASP is the problem, but my SQL statement seems fine to
me.
This works fine :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2"
set rs = CreateRecordset(strSQL)
This doesn''t work :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2 ORDER
BY [_RechPat].cod_patrim ASC"
set rs = CreateRecordset(strSQL)
Error Number : -2147467259
Error Description : Unspecified Error (in french : Erreur non
spécifiée)
1. ORDER BY clauses work fine in some other recordsets.
2. This SQL statement works fine ( i design and test my SQL queries
with MS ACCESS)
3. Database is MS ACCESS 2000
4. Server = IIS 5.0
Any ideas ?
第一步是response.write strsql所以你可以验证是否已经正确创建了sql
语句字符串。
如果response.written字符串是可以执行的有效sql语句
在Access Query Builder中没有问题，然后我怀疑是一个保留字
问题。尝试将cod_patrim字段名称括起来： ...
[_RechPat]。[cod_patrim] ASC"
HTH，
Bob Barrows
PS。我建议你不要在你的选择列表中使用*，因为ADO必须为了获得列名而额外访问数据库，这会损害
的性能。应用。您应该指定希望查询返回的列的名称
。
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。我的From
标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。
The first step is to "response.write strsql" so you can verify that the sql
statement string has been created correctly.
If the response.written string is a valid sql statement that can be executed
with no problem in the Access Query Builder, then I suspect a reserved word
problem. Try bracketing the cod_patrim field name: " ...
[_RechPat].[cod_patrim] ASC"
HTH,
Bob Barrows
PS. I urge you to avoid using * in your select list, because ADO has to make
an extra trip to the database to get the column names, impairing the
performance of the application. You should specify the names of the columns
you wish the query to return.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don''t check it very often. You will get a
quicker response by posting to the newsgroup.
我没有看到任何问题。我建议安装最新版本的MDAC
和/或确保你使用OLEDB驱动程序连接到你的数据库，
而不是ODBC。 />
Ray在工作
" Peroq" < FR ***** @ yahoo.com>在消息中写道
新闻：3f *********************** @ nan-newsreader-01.noos.net ...
I don''t see any issues. I suggest installing the latest version of MDAC
and/or making sure you''re using an OLEDB driver to connect to your database,
as opposed to ODBC.
Ray at work
"Peroq" <fr*****@yahoo.com> wrote in message
news:3f***********************@nan-newsreader-01.noos.net...
大家好
我不确定ASP是不是问题，但我的SQL语句对我来说似乎很好。
这很好用：
strSQL =" SELECT [_RechPat]。* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri.cod_niv WHERE NivPatri.position = 2"
set rs = CreateRecordset（strSQL ）
这不起作用：
strSQL =" SELECT [_RechPat]。* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri.cod_niv WHERE NivPatri.position = 2 ORDER BY
[_RechPat] .cod_patrim ASC"
设置rs = CreateRecordset（strSQL）
错误号：-2147467259
错误描述：未指定错误（法语：Erreurnonspécifiée）
1. ORDER BY子句在其他一些记录集中工作正常。
2.这个SQL语句工作正常（我用$设计和测试我的SQL查询b $ b MS ACCESS）
3.数据库是MS ACCESS 2000
4.服务器= IIS 5.0
任何想法？
Hi all
I''m not sure ASP is the problem, but my SQL statement seems fine to me.
This works fine :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2"
set rs = CreateRecordset(strSQL)
This doesn''t work :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2 ORDER BY
[_RechPat].cod_patrim ASC"
set rs = CreateRecordset(strSQL)
Error Number : -2147467259
Error Description : Unspecified Error (in french : Erreur non spécifiée)
1. ORDER BY clauses work fine in some other recordsets.
2. This SQL statement works fine ( i design and test my SQL queries with MS ACCESS)
3. Database is MS ACCESS 2000
4. Server = IIS 5.0
Any ideas ?
感谢鲍勃和雷的答案。
但目前，它仍然无法正常工作。
" Peroq" < FR ***** @ yahoo.com> écritdansle message de
news：3f *********************** @ nan-newsreader-01.noos.net ...
Thanks bob and ray for your answers.
But for the moment, it still doesn''t work.
"Peroq" <fr*****@yahoo.com> a écrit dans le message de
news:3f***********************@nan-newsreader-01.noos.net...
大家好
我不确定ASP是不是问题，但我的SQL语句对我来说似乎很好。
这个工作正常：
strSQL =" SELECT [_RechPat]。* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri.cod_niv WHERE NivPatri.position = 2"
set rs = CreateRecordset（strSQL）
这不起作用：
strSQL =" SELECT [_RechPat]。* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat] .cod_niv = NivPatri .cod_niv WHERE NivPatri.position = 2 ORDER BY
[_RechPat] .cod_patrim ASC"
设置rs = CreateRecordset（strSQL）
错误号：-2147467259
错误描述：未指定的错误（法语：Erreurnonspécifiée）
1. ORDER BY子句在其他一些记录集中工作正常。
2.这个SQL语句工作正常（我设计和测试我的SQL查询
MS ACC ESS）
3.数据库是MS ACCESS 2000
4.服务器= IIS 5.0
任何想法？
Hi all
I''m not sure ASP is the problem, but my SQL statement seems fine to me.
This works fine :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2"
set rs = CreateRecordset(strSQL)
This doesn''t work :
strSQL = "SELECT [_RechPat].* FROM _RechPat INNER JOIN NivPatri ON
[_RechPat].cod_niv = NivPatri.cod_niv WHERE NivPatri.position=2 ORDER BY
[_RechPat].cod_patrim ASC"
set rs = CreateRecordset(strSQL)
Error Number : -2147467259
Error Description : Unspecified Error (in french : Erreur non spécifiée)
1. ORDER BY clauses work fine in some other recordsets.
2. This SQL statement works fine ( i design and test my SQL queries with MS ACCESS)
3. Database is MS ACCESS 2000
4. Server = IIS 5.0
Any ideas ?
这篇关于ORDER BY子句有问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
