Link to a specified spot in a page (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

hhammash -> Link to a specified spot in a page (9/1/2002 6:52:01)

Hi,

I have a database results that lists 6 columns. Two of these columns are important, PageNumber adn ItemNumber. I made the PageNumber field hyperlinked, so when the user click it takes him to the page itself. Now next to the PageNumber field in the DRW, I have the ItemNumber.

Is it possible that the link reads the PageNumber and the ItemNumber then it goes inside the page to the first Occurance of that Itemnumber without the need to insert bookmarks, because I have thousands of ItemNumber?

Example: The page listes is Page40 and the item number is A3454 in the DRW. Whe the user click on the page link Page40.htm opens and the cursor stops on the Item number A3454.

Thanks a lot
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/1/2002 7:54:12)

If page 40 is a DRW returning all of the ItemNumbers I would create ' criteria' on that DRW. Make the criteria 

fp_sQry=" SELECT * FROM Results WHERE (ItemNumber =  ::ItemNumber::)"


Then on you page with the hyperlink, make the link like so: 

<a href=" Page<%=FP_FieldVal(fp_rs," PageNumber" )%>.asp?ItemNumber=<%=FP_FieldVal(fp_rs," ItemNumber" )%>" >Page <%=FP_FieldVal(fp_rs," PageNumber" )%></a>


The key is adding the

?ItemNumber=<%=FP_FieldVal(fp_rs," ItemNumber" )%>

part so that that itemnumber is fetched and displayed on/from page 40



hhammash -> RE: Link to a specified spot in a page (9/1/2002 9:21:38)

Hi Lydecker,

Thank you for your reply.

Page 04.0 is a normal table, filled manually. But the requests go to a DRW, the DRW lists the PageNumber and the Item Number, I just want to click on the page number, and then the cursor or page will view the related ItemNumber. I can' t do it with bookmarks because I have many many ItemNumbers.

The idea: Is there anyway to make the link read the ItemNumber next to the page and search for it in the next page. I mean, something like " Find In page" . In the browser if you have a very big page and you want to look for " Computer" you go to edit/find in page and then type computer, it will find it. Can this be done from one page to another?

Thanks a lot
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/1/2002 10:52:16)

Yea, I see where your coming from but alas, I dont think there is a way to run an ' auto find' on the table. But surely if you have that many records, it would be wiser to place the manual table in a DRW. This lets you do endless things with the results, and you could even ' auto bookmark' them.

But hey, that is just me thinking out aloud[;)] - maybe someone else has some better ideas!



On a seperate note, if this site is the same one which you were talking about password portection in the DBWR post you made a while back, I strongly recomend you use a more secure form of password protection - esspecialy with 40+ pages. If you head over to your post titled DBRW, yesterday I outlined a relatively easy method of securely protecting all pages with some simple .asp which may be worth a read...



hhammash -> RE: Link to a specified spot in a page (9/1/2002 13:17:09)

Hi,

I heared you thinking and I liked something. What did you mean by " You can auto bookmark them" . Can I list the whole DRW and highlight only the selected record.

Suppose I have a search form, and a DRW in another page. Let' s say I was looing for item number A898, and press submit. Can I have the DRW highlight the row while displaying the whole list, instead of giving me one row for the selected item number. It will look nice.

Thanks
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/1/2002 14:38:38)

All you would do is place this inbetween the database fields: 

<a name=" <%=FP_FieldVal(fp_rs," ItemNumber" )%> " ></a>


Then hyperlinnk to page40.asp#<%=FP_FieldVal(fp_rs," ItemNumber" )%>



I' ll get back to you on the highlite lark - just want to give it a go (I seem to remember having problems in the past)



hhammash -> RE: Link to a specified spot in a page (9/1/2002 15:09:25)

Hi,

Your last post will perform what?

- Find the Item number on the other page?
- Or highlights the row in the database results?

Thanks
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/1/2002 15:38:12)

It is the ' auto bookmark' method.



hhammash -> RE: Link to a specified spot in a page (9/1/2002 16:41:38)

Hi Lydecker,

Thanks a lot for your support. I will try it.

Best regards
Hisham

Please see my new posting title " How to do That"

Thanks again
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/1/2002 17:07:18)

give us a shout if you have any querys about the autobookmark.



hhammash -> RE: Link to a specified spot in a page (9/1/2002 17:31:43)

Hi Lydecker,

Thanks a lot.

I will try it and notify you.

Thanks
Hisham



hhammash -> RE: Link to a specified spot in a page (9/4/2002 14:50:43)

Hi Lydecker,

I tried your way.

I opened the Database Resutls in HTML and added the first line:
<a name=" <%=FP_FieldVal(fp_rs," ItemNumber" )%> " ></a>
between the database fields as you can see here:

<!--#include file=" _fpclass/fpdbrgn1.inc" -->
<!--webbot bot=" DatabaseRegionStart" endspan i-checksum=" 20673" --><tr>
<td>
<a href=" 41.0.asp#<%=FP_FieldLink(fp_rs," ItemNumber" )%>" >
<!--webbot bot=" DatabaseResultColumn" s-columnnames=" PageNumber,Description,ItemNumber,Quantity,ExpiryDate" s-column=" PageNumber" b-tableformat=" TRUE" b-hashtml=" FALSE" b-makelink=" FALSE" clientside b-MenuFormat preview=" <font size=" -1" ><<</font>PageNumber<font size=" -1" >>></font>" startspan --><%=FP_FieldVal(fp_rs," PageNumber" )%><!--webbot bot=" DatabaseResultColumn" endspan i-checksum=" 28926" --></a></td>
<td>
<!--webbot bot=" DatabaseResultColumn" s-columnnames=" PageNumber,Description,ItemNumber,Quantity,ExpiryDate" s-column=" Description" b-tableformat=" TRUE" b-hashtml=" FALSE" b-makelink=" FALSE" clientside b-MenuFormat preview=" <font size=" -1" ><<</font>Description<font size=" -1" >>></font>" startspan --><%=FP_FieldVal(fp_rs," Description" )%><!--webbot bot=" DatabaseResultColumn" endspan i-checksum=" 30092" --></td>
<td>
<!--webbot bot=" DatabaseResultColumn" s-columnnames=" PageNumber,Description,ItemNumber,Quantity,ExpiryDate" s-column=" ItemNumber" b-tableformat=" TRUE" b-hashtml=" FALSE" b-makelink=" FALSE" clientside b-MenuFormat preview=" <font size=" -1" ><<</font>ItemNumber<font size=" -1" >>></font>" startspan --><%=FP_FieldVal(fp_rs," ItemNumber" )%><!--webbot bot=" DatabaseResultColumn" endspan i-checksum=" 30924" --></td>
<a name=" <%=FP_FieldVal(fp_rs," ItemNumber" )%> " ></a>
<td>

The line that I added is in green, and after it there is still one or two fields.

Then Linked to the page as you noted.

It is taking me to the page, but it is not stopping at the item number.

The idea of auto bookmark is fantastic.

Best regards
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/4/2002 14:52:56)

will get back to you later tonight - peomise (just got an urgent error on my site i need to fix now[;)])



hhammash -> RE: Link to a specified spot in a page (9/4/2002 14:58:54)

Hi Lydecker,

Of course, take your time.

Thanks a lot.
Hisham




Lydecker -> RE: Link to a specified spot in a page (9/4/2002 16:17:52)

The hyperlink is in the DRW yes?



hhammash -> RE: Link to a specified spot in a page (9/4/2002 16:43:15)

Hi Lydecker,

Thank you for coming back. This is the test page, please take a look:

http://www.fmhs.uaeu.ac.ae/nml/Results.asp

Thank you
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/4/2002 17:00:38)

Okay there is nothing wrong with the Results.asp page. It is the 41.0.asp page causing the problem.

If you could email me the 41.0.asp so I can play around with it, I will be able to send it back tonight fixed.

Please zip it.

Thanks

(email address is in my profile)



Lydecker -> RE: Link to a specified spot in a page (9/4/2002 17:04:51)

Oh - and heres the besh way to download the .asp file from the live server:

File>>New Page or Web>>Empty Web
Create the web on your desktop.

Open up the live web.
Right click on 41.0.asp chose>>Publish selected files
Publish it to your sedktop web (you created)

Zip it![:)]



Lydecker -> RE: Link to a specified spot in a page (9/4/2002 17:22:56)

I think this is your problem - 

<a href=" 41.0.asp#<%=FP_FieldLink(fp_rs," ItemNumber" )%>" >


Delete it and try

--------------------------

**EDIT**

Hold on - which page is the above code from (the red code in your post)???

Best send me the file...



hhammash -> RE: Link to a specified spot in a page (9/4/2002 17:28:33)

Hi lydecker,

If I delete the line you mentioned, the hyperlink will go from the Page Number.

I made the zip folder, I will email it.

The main page which should have the link on PageNumber is the Results.asp I kept it for you without any modification so you can change it yourself. The hyperlink will post to 41.0.asp which has some item numbers, the link should take you to the row where item number is. Try click on the results page on Page number of item number D9002.

Thank you
Hisham



Lydecker -> RE: RE: Link to a specified spot in a page (9/4/2002 17:37:11)


quote:

ORIGINAL: Lydecker

Yea, I see where your coming from but alas, I dont think there is a way to run an ' auto find' on the table. But surely if you have that many records, it would be wiser to place the manual table in a DRW. This lets you do endless things with the results, and you could even ' auto bookmark' them.





Ah we have a slight misunderstanding! I thought you were going to place the results of page 41.0.asp in a DRW???

Are you reluctant to do this - if so why (if you don' t mind me asking)



hhammash -> RE: Link to a specified spot in a page (9/4/2002 17:45:34)

Hi Lydecker,

It is about Fixed assets, the previous finance officer, made it in tables using frontpage, it took him 3 month typing each table. When I came they asked this to be done (I mean from the DRW to go to the Item Number). The fixed assets is made of 210 pages, each page has around 120 item numbers (From Cars to keyboard).

The best way was to make it in a database, call the page in DRW, and then from the Results DRW when you click the hyperlink, it lists only the selected item (I know it is better).

Now at least I am taking them to the right page, then need only to just scroll.

I need a definite answer that " NO" it can be done, I can take only to the page. Otherwise, I will go to each item in the page and insert a bookmark for it. I tested 1 page, I inserted bookmarks, then used the " #" . It is going to the page and right to the ItemNumber.

I imagined that there is something link: When you click the hyperlink, it takes you to the requested page, then it triggers the Edit>Find command and looks for the itemnumber then stops there.

So, you think that it can be done as they like, except to either:
Convert the tables to Database
User the pages as DRWs.

Am I right here?

Thank you Lydecker,

P.S: Of course you may ask, I don' t mind you asking at all.
I can' t thank you enough.

Hisham






Lydecker -> RE: Link to a specified spot in a page (9/4/2002 17:59:52)

Okay - Question.

Each description refers to 1 item number correct??



Lydecker -> RE: Link to a specified spot in a page (9/4/2002 18:05:33)

2nd question:

you wouldent mind storing the item number and details of page 41.0.asp in the pages.mdb databse?

3rd question:

you would like ONLY the selected item to be listed.

4th question:

What country are you in? (just so I can get an Idea of time differences - i am in the UK [&:])



hhammash -> RE: Link to a specified spot in a page (9/4/2002 18:20:47)

Hi Lydecker,

Q1- Yes each row is for one record
Q2- Do you mean store the Item Number?
Q3- Yes
Q4- I am in UAE which is 4 hours ahead of UK (GMT+4)

Thanks
Hisham



Lydecker -> RE: Link to a specified spot in a page (9/4/2002 18:22:25)

yes store the item number



Lydecker -> RE: Link to a specified spot in a page (9/4/2002 18:33:35)

is that okay? [:j]



hhammash -> RE: Link to a specified spot in a page (9/4/2002 18:44:49)

Hi,

Only the item number? and connect it to the page or, you mean the whole info?





Lydecker -> RE: Link to a specified spot in a page (9/4/2002 18:45:49)

everything



hhammash -> RE: Link to a specified spot in a page (9/4/2002 18:49:23)

I think I will have to.




Question:
There is nothing to be done in VBscript and be placed on the top of each pages to search the contents of the page onLoad, and takes from the hyperlink the itemnumber and start searching, like find command.

If not, I will have to reeeeeeeeeeeeeeeeeeeeeeeeeetype the info [:D]
[:(] [:(]



Page: [1] 2   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.140625