|
| |
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
 |
RE: Link to a specified spot in a page - 9/4/2002 18:54:21
Thank you for your time and help zac,
Good night.
cu
Hisham
|
|
|
|
Lydecker
Posts: 609
From: Oxshott, Surrey, England (UK)
Status: offline
|
RE: Link to a specified spot in a page - 9/4/2002 18:58:15
I am not aware of any javascript that does that, however it really would the DB upgrade.
Do you know how to do what you are trying to do (you can do it on one page) or do you want a guide??
I take it db will have columns:
PageNo, Description, ItemNumber, Quantity, Ex Date, Price
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: Link to a specified spot in a page - 9/4/2002 19:09:44
Hi,
Yes, I think DB will be better and will have one page instead of tens.
I should start clean. I don' t know what the previous employee had in mind to create statis pages with these info.
I will make it a database and use your previous method about DRW.
Thanks a lot
cu
Hisham
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: Link to a specified spot in a page - 9/5/2002 1:27:21
Thanks lydecker
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: Link to a specified spot in a page - 9/6/2002 14:00:25
Any other suggestions?
| |
|
|
|
no_mac_jack
Posts: 295
From: Washington state, USA
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/6/2002 21:30:39
Hisham~
I never heard back from you on what type of example you would like...
Are you just returning the single row or returning all of them and then highlighting the specific record? Do you want to color the row to hightlight, bold it, or what? Let me know and I can work up an example...
~no_mac_jack
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/7/2002 6:35:25
Hi,
Spooky: Thanks for your reply
I used the bookmarks properly yes. But what I meant is that: From the DRW link to a normal HTM and find the IDNumber, without inserting a bookmark on the destination page becasue I have thousands of items It will take a long time to insert bookmarks. What I wanted is something like. From DRW in the IDNumber field to make a hyperlink to the htm page, and when the htm page opens I want it to make a search like using " Find" command automatically, and that " Find" command takes the IDNumber fromt he hyperlink. In this way it will be like using Edit/Find when you are in a page. IS IT POSSIBLE or I am just dreaming.
no_mack_jack: Thanks for your support:
I am sorry I did not reply yet, the boss has not decided yet. Your idea of taking all those information into a database is the right choice which we are going to do. If it is possible, I would like the whole record to be highlighted in a different color, but keep the whole listing of the DRW, if it is not possible, It is OK to list the found record only, which is easy.
Sorry for the delay no_mac_jack. I was going to reply after the weekend.
Still the idea of searching a page is very nice. Suppose you are in a very big page, you want to find a word, you just select Edit/Find and time the word in a box. I am wondering if it can be done in VBScript. When you send a parameter in a hyperlink to a page, the page loads, takes that parameter conduct an Edit/Find command automatically and highlights the word. Some kind fo a macro
Regards and thank you all
Hisham
< Message edited by hhammash -- 9/6/2002 6:36:26 AM >
| |
|
|
|
no_mac_jack
Posts: 295
From: Washington state, USA
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/7/2002 19:52:36
Sorry, Hisham...I didn' t mean to rush you or anything. I was just confused because in your e-mail I got the impression that we would wait until the DB stuff was done, but then your forum posting looked like you wanted something now. Just a misunderstanding on my part.
Here' s an example of what I would do (this is in the drw area)...
<%
If (Request.Querystring(" ItemNo" ) = FP_FieldVal(fp_rs," ItemNo" )) then
strColor = " #FFFF00" ' this is the highlight color
Else
strColor = " #FFFFFF" ' this is the normal color
End If
%>
<tr>
<td bgcolor=" <%=strColor%>" ><a name=" <%=FP_FieldVal(fp_rs," ItemNo" )%>" ><%=FP_FieldVal(fp_rs," ItemNo" )%></a>
</td>
<td bgcolor=" <%=strColor%>" ><%=FP_FieldVal(fp_rs," Field1" )%>
</td>
<td bgcolor=" <%=strColor%>" ><%=FP_FieldVal(fp_rs," Field2" )%>
</td>
</tr>
Something as simple as that could do the trick. It creates a bookmark using the item number so that you don' t have to. It also makes the row a certain color depending on whether or not the record' s item number matches the one in the querystring.
Let me know if you have any questions. Again, I' m sorry for the confusion!
~no_mac_jack
< Message edited by no_mac_jack -- 9/7/2002 2:10:09 AM >
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/8/2002 0:27:49
Hi no_mack_jack,
On the contrary, you are not rushing me or anything, you are helping me with dedication and honesty, I appreciate it a lot. But all last Thursday until Friday evening our IT department disabled the email server (Outgoing messages) because they were upgrading it to iPlanet.
Besides, in my last posting as you have seen I submitted a new idea which I hope it works for other reasons not for the one you are talking about.
Back to our subject. Where shall I insert the code that you posted? After the first Include file, After the second ..etc.
Best regards
Hisham
| |
|
|
|
no_mac_jack
Posts: 295
From: Washington state, USA
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/8/2002 2:12:20
I updated my last post with color coding. The red stuff is what' s important. The rest of it is just my example code that shows you how you would apply it to your table structure (the bgcolor, for example). That chunk of code is taken directly from *between* the two fpdbrgn includes in my sample page.
Let me know if you have trouble configuring it....
~no_mac_jack
BTW- You might post your question about using the browser' s " Find" feature as a new thread in one of the other sections and see if you get anything.
< Message edited by no_mac_jack -- 9/7/2002 2:13:41 AM >
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/8/2002 2:31:32
Hi,
Thank you NMJ, I will try this code and put it in between the Include, and I will let you know  .
Thanks a lot for you continuous support NMJ.
Hi Spooky:
Why they are HTM? We had an old fashioned employee, who was working in finance. He entered the whole fixed asset list in Excel then saved them as HTM, and did not keep the excel sheet. When I was given the project they asked me if there is a way to do a searching on an HTM page.
Imagine, a building of 3 blocks, each block has 4 stories, the faculty has over a 1000 employess. All the furniture, computers ..etc was there.
Now as NMJ suggested before, I set up a team of (4) to re-input the data into a database and work on it.
Thank you for your support Spooky.
Thank you all
Hisham
< Message edited by hhammash -- 9/7/2002 2:32:37 AM >
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/8/2002 12:31:34
Hi Zac,
I know, but the matter turned into:
1- Believing in inputing the data into a database and a DRW
2- Wanting to have the find option for other reasons
Thanks
Hisham
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/10/2002 0:38:41
Hi NMJ,
It is working fine. See it at:
http://www.fmhs.uaeu.ac.ae/nml/NorthWind/CustomerList.asp
BUT: The result is coming in one line only. I thought the whole DRW would appear and the only wanted line will be highlighted only.
This code is nice
Thanks
Hisham
< Message edited by hhammash -- 9/9/2002 1:52:53 AM >
| |
|
|
|
no_mac_jack
Posts: 295
From: Washington state, USA
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/10/2002 18:47:22
Hmmm...not sure why it' s doing that. I just made a sample page with the same northwind data and it works fine. Here' s the main chunk of my code...
<!--#include file=" _fpclass/fpdbrgn1.inc" -->
<%
If (trim(Request.Querystring(" CustID" )) = FP_FieldVal(fp_rs," CustomerID" )) then
strColor = " #FFFF00" ' this is the highlight color
Else
strColor = " #FFFFFF" ' this is the normal color
End If
%>
<tr>
<td bgcolor=" <%=strColor%>" >
<a name=" <%=FP_FieldVal(fp_rs," CustomerID" )%>" ></a>
<a href=" CustomerSearchResults.asp?CustomerID=<%=FP_FieldVal(fp_rs," CustomerID" )%>" ><%=FP_FieldVal(fp_rs," CustomerID" )%></a>
</td>
<td bgcolor=" <%=strColor%>" ><%=FP_FieldVal(fp_rs," CompanyName" )%>
</td>
<td bgcolor=" <%=strColor%>" ><%=FP_FieldVal(fp_rs," ContactName" )%>
</td>
<td bgcolor=" <%=strColor%>" ><%=FP_FieldVal(fp_rs," ContactTitle" )%>
</td>
</tr>
<!--#include file=" _fpclass/fpdbrgn2.inc" -->
Does that look like what you had? I tested it to make sure that if no ID was passed in the querystring, it would not highlight anything. I also tested it with a ID and a bookmark like this...
mypage.asp?CustID=CONSH&#CONSH
That also worked. Maybe you can see a discrepancy in the code? Let me know...
~no_mac_jack
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/11/2002 0:16:31
Hi NMJ,
I have two pages. One which lists the Customers, the second is also a DRW which receives the parameters from the link in the first page.
The code that you sent is for the first page, right?
- Is it on the diet?
I tried it and am still getting one record in the second page. The question is, is it possible to have the whole Database Results listed all the time with the requested record highlighted?
Regards
Hisham
< Message edited by hhammash -- 9/10/2002 8:47:43 AM >
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/12/2002 0:42:10
Hi NMJ,
I changed the SQL and worked just perfectly.
Thanks a lot
Hisham
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: RE: Link to a specified spot in a page - 9/13/2002 16:54:58
Hi NMJ,
Thanks for your sincere help.
Hisham
| |
|
 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 
k¥ 
