从SQL / ASP订购数据 [英] Ordering data from SQL/ASP
问题描述
您好，
我有一个应用程序从SQL服务器中删除数据并在ASP页面上以
柱状形式显示，使用
直到RS.EOF循环。
我希望为每列添加2个箭头（向上和向下），点击后，订单
该列页面上的数据（向上 - AZ和向下ZA等.....）
这在ASP中是否可行，或者我需要一些Javascript /客户端代码
这样做？
问题是ASP SELECT语句最初订购数据，我只需要
需要知道如何用户可以在页面上重新排序数据吗？
非常感谢任何想法/例子。
-
提前致谢
Fawke
请在给我发电子邮件之前从我的电子邮件地址中删除ANTI和SPAM
。
www.bradflack.com
Hi there,
I have an application that rips data from an SQL server and displays it in
columnar form on an ASP page, using a
Do until RS.EOF loop.
I wish to add 2 arrows to each column (up and down) and when clicked, orders
the data on the page by that column (up - A-Z and down Z-A etc.....)
Is this possible in ASP or would i need some Javascript/Client side code to
do this?
The problem is the ASP SELECT statement orders the data initially, i just
need to know how the user can re-order the data after it is on the page?
Any ideas/examples much appreciated.
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
推荐答案
Fawke101写道：
Fawke101 wrote:
你好，
我有一个应用程序从SQL服务器中删除数据并在列中显示
表格在ASP页面上，使用
直到RS.EOF循环。
我希望在每一列（向上和向下）添加2个箭头，点击后，
命令该列页面上的数据（向上 - AZ和向下ZA
等.....）
在ASP中这是可能的还是我需要一些Javascript /客户端代码这样做？
问题是ASP SELECT语句最初对数据进行排序，我只需要知道用户在数据打开后如何重新排序数据
页面？
非常感谢任何想法/例子。
Hi there,
I have an application that rips data from an SQL server and displays
it in columnar form on an ASP page, using a
Do until RS.EOF loop.
I wish to add 2 arrows to each column (up and down) and when clicked,
orders the data on the page by that column (up - A-Z and down Z-A
etc.....)
Is this possible in ASP or would i need some Javascript/Client side
code to do this?
The problem is the ASP SELECT statement orders the data initially, i
just need to know how the user can re-order the data after it is on
the page?
Any ideas/examples much appreciated.
您将需要客户端代码。您应该能够通过Google搜索使用关键字找到示例
：
DHTML排序表列
请在客户端新闻组中进行跟进：寻找一个新闻组，其中包含
" dhtml"以其名义，或去其中一个.scripting小组。
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。我的From
标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。
You will need client-side code for this. You should be able to find examples
via a Google search using the keywords:
DHTML sort table columns
Please follow up in a client-side newsgroup: look for a newsgroup with
"dhtml" in its name, or go to one of the .scripting groups.
Bob Barrows
--
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.
我使用ASP来做它只需要另外一次去
服务器。从箭头构建超链接，并通过查询字符串传递
排序说明。我传递U
或D对于Asending或Desending然后构建你的订单
你从中选择语句。
我会发布示例代码，但我的服务器当前已关闭。
如果我把服务器拿起来，我会稍后发回。
Mike
I use ASP to do it it just requires another trip to the
server. Build hyperlinks out of the arrows and pass your
sort instructions through the querystring. I pass "U"
or "D" for Asending or Desending then build your order for
you select statement from that.
I would post sample code but my server is currently off.
If I get my server up I will post back later.
Mike
---- - 原始消息-----
您好，
我有一个应用程序从SQL服务器
中删除数据，并在ASP页面上以单列形式显示它，使用
直到RS.EOF循环。
我希望每列添加2个箭头（向上和向下），点击时为
，按该列对页面上的数据进行排序（向上 - AZ和向下Z-
A等.....）这可能在ASP中，或者我需要一些
Javascript /客户端代码来做这个吗？
问题是ASP SELECT语句最初订购数据
，我只想知道用户如何在页面上显示
之后重新订购数据？
任何想法/示例都非常赞赏。
-
提前致谢
请在给我发电子邮件之前从我的电子邮件地址中删除ANTI和SPAM
www.bradflack.com
。
-----Original Message-----
Hi there,
I have an application that rips data from an SQL server and displays it incolumnar form on an ASP page, using a
Do until RS.EOF loop.
I wish to add 2 arrows to each column (up and down) and when clicked, ordersthe data on the page by that column (up - A-Z and down Z- A etc.....)Is this possible in ASP or would i need some Javascript/Client side code todo this?
The problem is the ASP SELECT statement orders the data initially, i justneed to know how the user can re-order the data after it is on the page?
Any ideas/examples much appreciated.
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
.
感谢Bob，我已经联合发布到客户端新闻组，所以
希望能从那里得到更多的反馈，
再次感谢
-
提前致谢
Fawke
请删除ANTI和垃圾邮件
来自我的电子邮件地址，然后给我发电子邮件。
www.bradflack.com
Bob Barrows [MVP]" <再****** @ NOyahoo.SPAMcom>在消息中写道
新闻：ej ************** @ TK2MSFTNGP09.phx.gbl ...
Thanks for that Bob, i have joint posted this to a client side newsgroup so
hopefully should get some more feedback from there,
Thanks again
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:ej**************@TK2MSFTNGP09.phx.gbl...
Fawke101写道：
Fawke101 wrote:
您好，
我有一个应用程序从SQL服务器中删除数据并在ASP页面上以列式形式显示它，使用
直到RS.EOF循环。
我希望每列添加2个箭头（向上和向下），点击后，
按照该列对页面上的数据进行排序（向上 - AZ和关闭ZA
等.....）
这可能是ASP还是我需要一些Javascript /客户端代码才能做到这一点？
问题是ASP SELECT语句最初对数据进行排序，我只需要知道用户在页面打开后如何重新排序数据？
任何想法/非常感谢。
您将需要客户端代码。您应该能够通过Google搜索使用以下关键字找到
Hi there,
I have an application that rips data from an SQL server and displays
it in columnar form on an ASP page, using a
Do until RS.EOF loop.
I wish to add 2 arrows to each column (up and down) and when clicked,
orders the data on the page by that column (up - A-Z and down Z-A
etc.....)
Is this possible in ASP or would i need some Javascript/Client side
code to do this?
The problem is the ASP SELECT statement orders the data initially, i
just need to know how the user can re-order the data after it is on
the page?
Any ideas/examples much appreciated.
You will need client-side code for this. You should be able to find
示例：
DHTML排序表列
请跟进在客户端新闻组中：寻找具有
dhtml的新闻组以其名义，或去其中一个.scripting组。
Bob Barrows
-
Microsoft MVP - ASP / ASP.NET 请回复新闻组。我的From
标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将得到更快的回复。
examples via a Google search using the keywords:
DHTML sort table columns
Please follow up in a client-side newsgroup: look for a newsgroup with
"dhtml" in its name, or go to one of the .scripting groups.
Bob Barrows
--
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.
这篇关于从SQL / ASP订购数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
