473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Help!! I've fallen and I can't reach my ASP 3.0 manual...

Can anyone point me to a code sample where a single page in an ADO recordset is sorted independantly on a different field.

Example:

An ADO recordset is populated and sorted on[ListingDate]. I need to sort the 20 records on recordset.absolutepage 5 by let's say [AskingPrice]. This subsort should only sort those 20 records AND maintain the original paging so the user sees the original 20 records in recordset.absolutepage 5 but sorted by [AskingPrice]. Have I explained it OK?

I thought I had about 50 times but now I'm loosing it...

Kev
Nov 19 '05 #1
1 1314
Hi Kev,

Unfortunately, this is not the ASP newsgroup. It is the ASP.Net newsgroup,
so you're not likely to get much help with ASP here. The ASP newsgroup can
be found at microsoft.public.inetserver.asp.db (in your case, as you're
doing ADO stuff).

In the meantime, I can help you a little: A RecordSet can be sorted, but
there is no such thing as a Page in a RecordSet. There is an AbsolutePage
property that can be used toget or set the current Page of the RecordSet,
but the RecordSet cannot be sorted differently by Page. So, your only
alternative is to sort the records in the Page "by hand" in any number of
ways, such as reading the Records in a Page into an Array and sorting the
Array, etc.

See the following for more help on using ADO RecordSets:
http://msdn.microsoft.com/library/de...dobjodbrec.asp

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
The sun never sets on
the Kingdom of Heaven

"Kevin" <ke***@DearingerAM.com> wrote in message
news:uY***************@TK2MSFTNGP15.phx.gbl...
Can anyone point me to a code sample where a single page in an ADO recordset
is sorted independantly on a different field.

Example:

An ADO recordset is populated and sorted on[ListingDate]. I need to sort
the 20 records on recordset.absolutepage 5 by let's say [AskingPrice]. This
subsort should only sort those 20 records AND maintain the original paging
so the user sees the original 20 records in recordset.absolutepage 5 but
sorted by [AskingPrice]. Have I explained it OK?

I thought I had about 50 times but now I'm loosing it...

Kev
Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: SouthVN | last post by:
Hi All ! In my project, there is a request is how to can we know any user had loged in to Oracle Database System, what's the time they log in, log out ?; What did they do in database, example:...
5
by: joshnosh | last post by:
I have two tables tblLogin and tblTrades I have 3 fields in each table, for thr purpose of this question tblLogin Fields are MemberNo RegNo Country tblTrades fields are
2
by: Support | last post by:
in asp.net If I have a web usercontrol WUC with code behind Class CLASSWUC and I have a web page that loads the control Private Sub Page_Init(ByVal sender As System.Object, ByVal e As...
8
by: GabrielESandoval | last post by:
i currently use the code below to create a slideshow of images. i edited it so that its not as long. i currently have over 20 images i want to change it so that the images dont appear in the...
2
by: g35rider | last post by:
Hi, I have the following code that is giving this error, I cant simplify the code, I was just testing some theory for something we are doing and was getting an issue here. Please someone point out...
4
by: dasarisrikar | last post by:
hello..can anybody help me.. i cant understood the meaning of *(int *)p=2; so pls hepl me...wt it actully do....
3
by: nick77 | last post by:
yo guys please help..... ive been trying to solve this pro for days: Write a C++ program to convert temperature from degree Celsius (TC) to 1) degrees Fahrenheit (TF) or 2 degrees Kelvin...
1
by: durjoy | last post by:
dunno is the right forum to ask for help , but i cant see any category for html help . dont know any other site as well . this site is my last hope dear experts . i was hosting my site with...
2
by: Gerald07 | last post by:
If ComboBox1.Text = "Manual" Then Form2.Show() End If If ComboBox1.Text = "Non-Manual" Then Form3.Show() End If If ComboBox1.Text =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.