更改记录集的顺序会产生不良结果 [英] Changing order of recordsets creates non results
问题描述
我已经使用ASP多年使用MS Access并且已经使用了很多MSSQL作为
。我之前从未遇到过这样的事情。
MSSQL表名和类型:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
等
如果订单中的记录集如下,一切正常:
(Recordset2.Fields.Item(" ProductName")。Value)
(Recordset2.Fields.Item(" ShortDescription")。Value)
(Recordset2.Fields.Item(" Thumbnail")。。值)
虽然如果我首先有缩略图,但说明并没有显示。
有人对此有什么想法吗?
最基本的问候,
凯文
Hi,
I have used ASP for years using MS Access and have used MSSQL quite a lot as
well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does''nt show.
Anybody got any ideas on this?
Kindest regards,
Kevin
推荐答案
Kevin写道:
我已经使用ASP多年使用MS Access并且使用了MSSQL很多
很多好。我之前从未遇到过这样的事情。
MSSQL表名和类型:
产品名称nvarchar
ShortDescription nText
ThumbNail nvarchar
等等
当我按顺序打开记录集时,一切正常:
你是什么意思按顺序记录集?你的意思是如果你将
生成记录集的select语句中的字段放在
order"?
(Recordset2.Fields.Item(" ProductName") ;)。值)
(Recordset2.Fields.Item(" ShortDescription")。Value)
(Recordset2.Fields.Item(" Thumbnail")。Value)
>虽然如果我首先有缩略图,说明就不会显示。
Hi,
I have used ASP for years using MS Access and have used MSSQL quite a
lot as well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
What do you mean "have the recordset in order"? Do you mean if you " put
the fields in the select statement that produces the recordset in that
order"?
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does''nt show.
我们只是有一个很长的线索。这是aspfaq的文章:
http:// www.aspfaq.com/show.asp?id=2188
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我
不经常检查它。如果您必须离线回复,请删除
无垃圾邮件
We just had a long thread about this. Here''s the aspfaq article:
http://www.aspfaq.com/show.asp?id=2188
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
您好Bob,
谢谢你的快速回复。我的意思是,取决于什么顺序
,记录集用于在页面上显示数据取决于是否显示所有数据。我会读你推荐的那篇文章。从
我到目前为止所读到的我将尝试添加所有的colums而不是
只是SELECT *。
最基本的问候,
Kevin
" Bob Barrows [MVP]" <再****** @ NOyahoo.SPAMcom>在消息中写道
新闻:eV ************** @ TK2MSFTNGP05.phx.gbl ...
Hi Bob,
Thanks for your speedy reply. What I mean is that depending on what order
the recordesets are used to display data on the page is dependant on whther
all the data is displayed. I will read that article you recommended. from
what i have read so far i am going to try adding all the colums instead of
just SELECT *.
Kindest regards,
Kevin
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eV**************@TK2MSFTNGP05.phx.gbl...
Kevin写道:
我已经使用ASP多年使用MS Access并且使用了很多MSSQL。我之前从未遇到过这样的事情。
MSSQL表名和类型:
产品名称nvarchar
ShortDescription nText
ThumbNail nvarchar
等等。
当我按顺序记录集时,一切正常:
Hi,
I have used ASP for years using MS Access and have used MSSQL quite a
lot as well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
你的意思是按顺序记录集?你的意思是如果你将
字段放在select语句中,按照该命令生成记录集"?
What do you mean "have the recordset in order"? Do you mean if you " put
the fields in the select statement that produces the recordset in that
order"?
(Recordset2.Fields.Item(" ProductName")。 )
(Recordset2.Fields.Item(" ShortDescription")。Value)
(Recordset2.Fields.Item(" Thumbnail")。Value)
虽然如果我有缩略图首先描述没有显示。
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does''nt show.
我们只是有一个很长的线程关于此。这是aspfaq的文章:
http:// www.aspfaq.com/show.asp?id=2188
- Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我不经常检查它。如果您必须离线回复,请删除
NO SPAM
We just had a long thread about this. Here''s the aspfaq article:
http://www.aspfaq.com/show.asp?id=2188
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
>我到目前为止所读到的我将尝试添加所有的colums而不是
> what i have read so far i am going to try adding all the colums instead of
只是SELECT *。
just SELECT *.
是的,从来没有,永远在生产代码中使用select *。
Yes, NEVER, EVER use select * in production code.
这篇关于更改记录集的顺序会产生不良结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!