Author |
Topic |
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 07 April 2002 : 14:17:29
|
i am trying to write a sql statment and I am having a hard time doing it, so I am wondering if someone can help. Here is what I am trying to do.....
1. List all records on a page going down (DONE). 2. The user can sort the list by any of the columns (DONE) 3. The user can click on any of the items to view the details about that item (DONE) 4. There would be a next and previous button that would take them to the correct record in the database. This would be the next record in line on which ever way they sorted it. (NEED HELP)
So number 4 is what I do not know how to do. I know it would probley have to be paging, with the page size set at one. But I dont know how to tell it what record to start with. Any ideas?
Brad Web Hosting with SQL Server @ $24.95 per month
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 07 April 2002 : 15:45:27
|
This article discusses paging N records at a time. It might help.
You could also create a delimited string ordered the records in the selected sort order. Then pass that string value along with the record id they chose in step 3. Then parse the string to find the current record and subsequently get the previous and next record ids.
Nikkol |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 07 April 2002 : 23:20:59
|
thanks for that article, but i can do regular paging. you can see what i want to do when you click on the subject of any of these messages on this page...
http://www.buddyconnections.com/new/messages/inbox.asp
excuse the site layout, its just a joke
So when you view the Private Message I want it to allow you to click on next or previous message. What I am thinking is I can set the page size to 1, set all the same sql information, and if i can just tell it which page to start off with, then ill be in good shape.
Brad Web Hosting with SQL Server @ $24.95 per month
|
|
|
Bunce
New Member
Australia
84 Posts |
Posted - 08 April 2002 : 00:48:12
|
How about retrieving the ID of the previous and next records in the initial query. You could then use that in the querystring of the next call.
Cheers,
Andrew
====================================================== There have been many, many forum posts made throughout the world... This was one of them! |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 08 April 2002 : 07:02:13
|
Try using GetRows. Since you are passing the sort order through the query string, you can execute an sql to return a recordset of the message ids. Turn the recordset into an array using getrows. Find the index current message being viewed (i). Then the previous is i-1 and next is i+1.
Nikkol |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 08 April 2002 : 09:38:42
|
Copy the code from topic.asp that does the next message/previous message stuff ?
Failing that just use a querystring variable say "offset" save it using an hidden field type on the page, and if the user clicks next then increment by 1 and index into your recordset by the new value of "offset" likewise for going backwards just subtract 1
www.daoc-halo.com |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 08 April 2002 : 17:32:31
|
Where is the next/previous in topic.asp? I don't see it.
Nikkol |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 08 April 2002 : 17:54:17
|
if you are viewing this topic the its at the very top where it says topic. it was have an arrow to the right, and if a new topic gets posted then the arrow to the left will be posted.
i was looking at the way this code was written and it would work IF it the columns could not be sorted by different fields. maybe i just cant think right now but if someone would like to see if they could get this to work then let me know and i will show you the code. otherwise i will put this off till the VERY end.
Brad Web Hosting with SQL Server @ $24.95 per month
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 08 April 2002 : 20:50:47
|
Dang, you learn something new everyday. I think you might want to consider what I said about GetRows to include the sort order. Seems like that might be the way to go.
Nikkol |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 09 April 2002 : 01:26:25
|
GetRows will definately make it easier, dissconected recordsets could probably be used here also.
www.daoc-halo.com |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 09 April 2002 : 15:41:45
|
well the problem is i really dont know much about the getrows function. If you want to view what this is going on then look at...
http://www.buddyconnections.com/new/messages/mailbox.asp
you can do anything you want on this PM, because i will just run the setup.asp file i made and return everything back to normal. i think the only things i have left is to do the next and prev message buttons, and then format the text when its inserted and displayed so you can insert ' and it will keep the formating with the way you entered it. what do yall think?
Brad Web Hosting with SQL Server @ $24.95 per month
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 09 April 2002 : 15:47:22
|
oh by the way, i know it looks just like hotmail. i liked all the functions of hotmail and then as i stated in another topic, me and roland were joking around and so i put the hotmail icons at the top to make it look exactly like it.
Brad Web Hosting with SQL Server @ $24.95 per month
|
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 09 April 2002 : 15:55:07
|
looks like Hotmail Looks nice, will this be a MOD, just curious, or a personal MOD?
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 09 April 2002 : 16:10:53
|
well its going on one of my personal sites (buddyconnections.com) which is not going to have a forum (well at least at this point). so the code is not written or using anything with snitz, so it might be hard for someone to convert it over. but i have put some great features in it that does not come with the PM Mod here at Snitz.
I think this one might run a little better also, but who knows, only time will tell.
Brad Web Hosting with SQL Server @ $24.95 per month
|
|
|
|
Topic |
|