|
| |
|
|
R Clark
Posts: 161
From: USA
Status: offline
 |
' Same page' bookmark scenario on a DB results page - 11/21/2002 20:56:32
Let' s say you have a static page that lists 30 items
item 1
item ...
item ...
item 10
item ...
item ...
item 20
item ...
item ...
item 30
and lets say you have bookmarks at item 10, item 20 and item 30.
and lets say that you have these because item 5 and beyond are out of view down the screen and you want to give the viewer a quick jump to the records below.
At the top of the page you have a horizontal (bookmark navigation if you will) line of text;
10..........20............30
and you put hyperlinks to each of the bookmarks that correspond to these numbers to jump down to the corresponding line item.
This is no problem, I do it all the time on the static page, but, now that I am diving into database scenario' s, how would I do the same actions (scenario) in a DB results page allowing me to just jump down the page to an item that is out of view? I am being asked to retain the old static page look (format) and that is why I a looking to do this.
any help would be appreciated.
I hope it' s not another ' not seeing the forest through the trees' thing! [:p]
Thanks
R Clark
Oops, forgive me. I suppose this should have gone in the DB forum.
My bad.
< Message edited by R Clark -- 11/21/2002 5:59:41 PM >
|
|
|
|
J-man
Posts: 936
From: Canada
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 11/22/2002 2:13:48
so you want to pull images or something from a db, can' t you use hyperlinks on the html page to the db
| |
|
|
|
J-man
Posts: 936
From: Canada
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 11/22/2002 12:35:47
hi, bobby ..... i used the invisible form to auto submit info about a user to a database.
sry, R Clark .... just had to get that off my head.
< Message edited by J-man -- 11/22/2002 12:50:27 PM >
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 11/22/2002 13:22:37
Interesting post. I just tried it myself and quickly got it to work (or something like it) using 2 dieted DRW' s. I tried DRW' s ' cause it sounds like you' re not doing a whole lot of hand coding. I was sucessful setting the bookmarks.
The page here lists items sorted by their ID. (There are gaps!) There is a line like you spoke of (...10...20..) What it does in both DRW' s is to check to see if the ID number is evenly divisible by 10:
<%IF (FP_FieldVal(fp_rs," LinkID" )/10)=Fix(FP_FieldVal(fp_rs," LinkID" )/10) THEN%>
If it is, do one thing; if not, do something else. The full code of the page is here.
If this is a heavy traffic site, I would strongly suggest considering some ASP (try to move away from the DRW if possible) since 2 DRW' s can be a significant waste of server resources.
Hope this helps...
| |
|
|
|
R Clark
Posts: 161
From: USA
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 11/26/2002 21:06:08
Just to clarify...
I guess I just assumed that DRW on a diet was " straight asp" .
Let me see if I understand this correctly;
level 1 is DRW straight from FrontPage?
level 2 is DRW on the Spooky Diet?
Level 3 is straight ASP?
My question would be...
Is your scenario of straight ASP, not having to rely on the following?;
<!--#include file=" _fpclass/fpdblib.inc" -->
<!--#include file=" _fpclass/fpdbrgn1.inc" -->
<!--#include file=" _fpclass/fpdbrgn2.inc" -->
Your ASP pages are all inclusive?
I guess I' m just trying to educate myself (expand my knowledge).
Am I in the ball park of how you are thinking when you are describing these scenarios?
Thanks
R Clark
< Message edited by R Clark -- 11/26/2002 6:07:10 PM >
| |
|
|
|
R Clark
Posts: 161
From: USA
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 11/27/2002 16:04:18
quote:
ORIGINAL: Spooky
So, in a heavily trafficed site, this would put additional load on the server performing processes that could be run more efficiently with straight asp.
Makes sense but just so I am absolutely clear, when you say ' with straight asp' , this means you have written the functions that FrontPage has tried to do for you in the includes page, into your .asp page to eliminate the need for the include?
Would I learn much from the processes in the includes pages if I were to study them in an attempt to learn the coding of the necessary functions that take place or is it more FrontPage talking to itself and it would do more to confuse than to educate?
Thanks Spooky!
R Clark
| |
|
|
|
R Clark
Posts: 161
From: USA
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 12/10/2002 16:19:29
quote:
Let' s say you have a static page that lists 30 items
item 1
item ...
item ...
item 10
item ...
item ...
item 20
item ...
item ...
item 30
and lets say you have bookmarks at item 10, item 20 and item 30.
and lets say that you have these because item 5 and beyond are out of view down the screen and you want to give the viewer a quick jump to the records below.
At the top of the page you have a horizontal (bookmark navigation if you will) line of text;
10..........20............30
and you put hyperlinks to each of the bookmarks that correspond to these numbers to jump down to the corresponding line item.
OK, I' m Back
In regards to the above scenario, I' d like to clarify a little bit. I can' t just do a count and grab ten at a time.
Let me explain using a similar scenario:
instead of this...
item 1
item ...
item ...
item 10
item ...
item ...
item 20
item ...
item ...
item 30
What if we had this (I' m using the item numbers to illustrate the results listing), the 7 digit number is my focus...
(item 1 of db results) 6230001
(item 2 of db results) 6230002
(item 3 of db results) 6310001
(item 4 of db results) 6310002
(item 5 of db results) 6310003
(item 6 of db results) 6520001
(item 7 of db results) 6520002
(item 8 of db results) 6520003
(item 9 of db results) 6790001
(item 10 of db results) 6790002
OK, This would be on a much larger scale probably, the results may show a hundred items or so. Notice that the second number is grouped by the first three digits. If the group with 652 as the first three digits was off the screen, I would try and have a link at the top of the page that says " 52" . When someone clicked on 52 at the top of the page, they would jump down to 6520001. These groups could be anywhere from 2 or 3 (as in this example) to 40 or 50 in a ' like' group so I can' t count on an identical count each time. Most people would do a text search or something and the page would produce only the group that you want to look at. However, in my scenario, I am being asked to modernize by using a database and dynamic page but have it look and act the same as the old static page that had bookmarks.
Thanks for any help!
R Clark
PS
Should I tell them no way? 
< Message edited by R Clark -- 12/10/2002 1:20:50 PM >
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 12/10/2002 16:30:35
quote:
Makes sense but just so I am absolutely clear, when you say ' with straight asp' , this means you have written the functions that FrontPage has tried to do for you in the includes page, into your .asp page to eliminate the need for the include?
Yes, the includes are used for various functions - some not required by a simple ask and display. The formatting functions are also generic, they can do many things.
ASP code would be asked to do one thing - display your code the way you want it, not one of 5 or more options.
With coding it yourself, you can use .getrows to more efficiently display it.
quote:
Would I learn much from the processes in the includes pages if I were to study them in an attempt to learn the coding of the necessary functions that take place or is it more FrontPage talking to itself and it would do more to confuse than to educate?
Quite frankly, dont bother. If you want to, concentrate on the parts outside of the includes, and as soon as you feel the need to look inside, resist, and go to www.learnasp.com/learn/ for some classic asp tutorials.
< Message edited by Spooky -- 12/10/2002 4:31:16 PM >
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
| |
|
|
|
R Clark
Posts: 161
From: USA
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 12/10/2002 17:54:54
quote:
Quite frankly, don' t bother. If you want to, concentrate on the parts outside of the includes, and as soon as you feel the need to look inside, resist, and go to www.learnasp.com/learn/ for some classic asp tutorials.
That' s pretty much what I have been doing. I can copy and paste snippets and I am not to bad at editing problems out but I just seem to have this writers block about ' thinking up code' . I can' t seem to cross the hurdle of generating code for my scenario' s instead of plagiarizing and editing. Someday I hope.
I do a lot of tutorials and understand them but when it comes to applying them, if the scenario is even slightly different than the tutorial, I go into brain freeze. I just need to get over the intimidation factor that is plaguing me. I' ll keep at it though!
Thanks for the info.
R Clark
< Message edited by R Clark -- 12/10/2002 2:55:21 PM >
| |
|
|
|
R Clark
Posts: 161
From: USA
Status: offline
|
RE: ' Same page' bookmark scenario on a DB results page - 12/10/2002 18:04:42
quote:
Have you considered paging the results instead of bookmarks?
<< Page 1 of 10 >>
I think that it would annoy the users (believe it or not) to do that. For example, I changed a few buttons for more convenience and they wanted it back the way they were used to seeing it.
Once in a rut...!
It is an interesting design tip.
I designed this site from square one, but I can' t seem to get the users to allow me to evolve now. Once they got nestled in...they don' t want any changes in the look or function that they are used to. I' m now forced to make changes programmatically to make it more efficient but doesn' t change the function of process that they see and do.
Can be frustrating at times.
I' ve rambled enough.
As always thanks for your help!
R Clark
< Message edited by R Clark -- 12/10/2002 3:05:29 PM >
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
I just meant that it was rough - needed ' polish' ; not that it was easy - and quickly done...
