Hyperlinks to ASP Pages

[Bruce Dill]

OK, here is the senario:

I built a database using Access 2007 and saved it as a 2003 format. I
highlighted the text "All Current Cancer Members" right clicked and selected
"Hyperlink". I selected the desired page. I created an ASP page using DRW
with several fields including "ID" which in the database is an auto number
and index. In the DRW I chose to display the records using the "Last Name"
filed. The "Criteria" has one item. It is "Current Member Status" =
"Current". There are several records in the table which say "Current" I
published to the site to test the page.

Problem 1) No records displayed with the criteria set to Current. When I
take Current out so there is now no criteria at all then all records in the
table are displayed but not in Last Name order.

I also attempted to create a hyperlink to the ID field to another results
page where all fields from the table are shown. I right clicked on the ID
field and selected the ASP page to hyperlink to. I then clicked on the
Parameters button. The parameters Page came up with the page name in the
path field. The "Insert Field Value: was not highlighted. I deleted the
page name from the path field on the hyperlink Parameters screen and was then
able to insert the ID field. When I did so, the page was deleted from the
address field on the Insert Hyperlink screen and was replaced by
<%=FP_FieldLink(fp_rs,"ID")%>.

Problem 2) When I click on the hyperlink ID field which attaches to the
second ASP page with all the data it says "page Cannot be found 404".

you can see this at
http://www.firstchurchtulsacancersupport.org/currently battling cancer.asp.

So far I have

deleted the entire database and rebuilt it
Recalculated hyperlinks
created completely new pages to test.

I am at a loss. I have done this same thing many times on other websites.

Thanks,

Bruce Dill
bruce@ brucedill.com

 

[Stefan B Rusynko]

See response to your duplicate post in programming

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, here is the senario:
|
| I built a database using Access 2007 and saved it as a 2003 format. I
| highlighted the text "All Current Cancer Members" right clicked and selected
| "Hyperlink". I selected the desired page. I created an ASP page using DRW
| with several fields including "ID" which in the database is an auto number
| and index. In the DRW I chose to display the records using the "Last Name"
| filed. The "Criteria" has one item. It is "Current Member Status" =
| "Current". There are several records in the table which say "Current" I
| published to the site to test the page.
|
| Problem 1) No records displayed with the criteria set to Current. When I
| take Current out so there is now no criteria at all then all records in the
| table are displayed but not in Last Name order.
|
| I also attempted to create a hyperlink to the ID field to another results
| page where all fields from the table are shown. I right clicked on the ID
| field and selected the ASP page to hyperlink to. I then clicked on the
| Parameters button. The parameters Page came up with the page name in the
| path field. The "Insert Field Value: was not highlighted. I deleted the
| page name from the path field on the hyperlink Parameters screen and was then
| able to insert the ID field. When I did so, the page was deleted from the
| address field on the Insert Hyperlink screen and was replaced by
| <%=FP_FieldLink(fp_rs,"ID")%>.
|
| Problem 2) When I click on the hyperlink ID field which attaches to the
| second ASP page with all the data it says "page Cannot be found 404".
|
| you can see this at
| http://www.firstchurchtulsacancersupport.org/currently battling cancer.asp.
|
| So far I have
|
| deleted the entire database and rebuilt it
| Recalculated hyperlinks
| created completely new pages to test.
|
| I am at a loss. I have done this same thing many times on other websites.
|
| Thanks,
|
| Bruce Dill
| bruce@ brucedill.com
| --
| Bruce Dill

 

[Bruce Dill]

I changed all he page names and field names in the database and got rid of
all the spaces. This did get records to display in alpha order. Now the
problem is that the DRP is displaying all records in the file instead of just
the desired record.

Thanks you so much for your help.

 

[Kathleen Anderson]

Hi Bruce:
What did you change the "Current Member Status" field name to?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

I changed all he page names and field names in the database and got rid of
all the spaces. This did get records to display in alpha order. Now the
problem is that the DRP is displaying all records in the file instead of
just
the desired record.

Thanks you so much for your help.
--
Bruce Dill

See response to your duplicate post in programming

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, here is the senario:
|
| I built a database using Access 2007 and saved it as a 2003 format. I
| highlighted the text "All Current Cancer Members" right clicked and
selected
| "Hyperlink". I selected the desired page. I created an ASP page using
DRW
| with several fields including "ID" which in the database is an auto
number
| and index. In the DRW I chose to display the records using the "Last
Name"
| filed. The "Criteria" has one item. It is "Current Member Status" =
| "Current". There are several records in the table which say "Current"
I
| published to the site to test the page.
|
| Problem 1) No records displayed with the criteria set to Current.
When I
| take Current out so there is now no criteria at all then all records in
the
| table are displayed but not in Last Name order.
|
| I also attempted to create a hyperlink to the ID field to another
results
| page where all fields from the table are shown. I right clicked on the
ID
| field and selected the ASP page to hyperlink to. I then clicked on the
| Parameters button. The parameters Page came up with the page name in
the
| path field. The "Insert Field Value: was not highlighted. I deleted
the
| page name from the path field on the hyperlink Parameters screen and
was then
| able to insert the ID field. When I did so, the page was deleted from
the
| address field on the Insert Hyperlink screen and was replaced by
| <%=FP_FieldLink(fp_rs,"ID")%>.
|
| Problem 2) When I click on the hyperlink ID field which attaches to the
| second ASP page with all the data it says "page Cannot be found 404".
|
| you can see this at
|
http://www.firstchurchtulsacancersupport.org/currently battling cancer.asp.
|
| So far I have
|
| deleted the entire database and rebuilt it
| Recalculated hyperlinks
| created completely new pages to test.
|
| I am at a loss. I have done this same thing many times on other
websites.
|
| Thanks,
|
| Bruce Dill
| bruce@ brucedill.com
| --
| Bruce Dill

 

[Bruce Dill]

MemberCancerStatus

I would be glad to send you the pages and DB if you like.
--
Bruce Dill

Hi Bruce:
What did you change the "Current Member Status" field name to?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

I changed all he page names and field names in the database and got rid of
all the spaces. This did get records to display in alpha order. Now the
problem is that the DRP is displaying all records in the file instead of
just
the desired record.

Thanks you so much for your help.
--
Bruce Dill

See response to your duplicate post in programming

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, here is the senario:
|
| I built a database using Access 2007 and saved it as a 2003 format. I
| highlighted the text "All Current Cancer Members" right clicked and
selected
| "Hyperlink". I selected the desired page. I created an ASP page using
DRW
| with several fields including "ID" which in the database is an auto
number
| and index. In the DRW I chose to display the records using the "Last
Name"
| filed. The "Criteria" has one item. It is "Current Member Status" =
| "Current". There are several records in the table which say "Current"
I
| published to the site to test the page.
|
| Problem 1) No records displayed with the criteria set to Current.
When I
| take Current out so there is now no criteria at all then all records in
the
| table are displayed but not in Last Name order.
|
| I also attempted to create a hyperlink to the ID field to another
results
| page where all fields from the table are shown. I right clicked on the
ID
| field and selected the ASP page to hyperlink to. I then clicked on the
| Parameters button. The parameters Page came up with the page name in
the
| path field. The "Insert Field Value: was not highlighted. I deleted
the
| page name from the path field on the hyperlink Parameters screen and
was then
| able to insert the ID field. When I did so, the page was deleted from
the
| address field on the Insert Hyperlink screen and was replaced by
| <%=FP_FieldLink(fp_rs,"ID")%>.
|
| Problem 2) When I click on the hyperlink ID field which attaches to the
| second ASP page with all the data it says "page Cannot be found 404".
|
| you can see this at
|
http://www.firstchurchtulsacancersupport.org/currently battling cancer.asp.
|
| So far I have
|
| deleted the entire database and rebuilt it
| Recalculated hyperlinks
| created completely new pages to test.
|
| I am at a loss. I have done this same thing many times on other
websites.
|
| Thanks,
|
| Bruce Dill
| bruce@ brucedill.com
| --
| Bruce Dill

 

[Kathleen Anderson]

OK - zip them up and send them - you have my email address.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

MemberCancerStatus

I would be glad to send you the pages and DB if you like.
--
Bruce Dill

Hi Bruce:
What did you change the "Current Member Status" field name to?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

I changed all he page names and field names in the database and got rid
of
all the spaces. This did get records to display in alpha order. Now
the
problem is that the DRP is displaying all records in the file instead
of
just
the desired record.

Thanks you so much for your help.
--
Bruce Dill


:

See response to your duplicate post in programming

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| OK, here is the senario:
|
| I built a database using Access 2007 and saved it as a 2003 format.
I
| highlighted the text "All Current Cancer Members" right clicked and
selected
| "Hyperlink". I selected the desired page. I created an ASP page
using
DRW
| with several fields including "ID" which in the database is an auto
number
| and index. In the DRW I chose to display the records using the
"Last
Name"
| filed. The "Criteria" has one item. It is "Current Member Status"
=
| "Current". There are several records in the table which say
"Current"
I
| published to the site to test the page.
|
| Problem 1) No records displayed with the criteria set to Current.
When I
| take Current out so there is now no criteria at all then all records
in
the
| table are displayed but not in Last Name order.
|
| I also attempted to create a hyperlink to the ID field to another
results
| page where all fields from the table are shown. I right clicked on
the
ID
| field and selected the ASP page to hyperlink to. I then clicked on
the
| Parameters button. The parameters Page came up with the page name
in
the
| path field. The "Insert Field Value: was not highlighted. I
deleted
the
| page name from the path field on the hyperlink Parameters screen and
was then
| able to insert the ID field. When I did so, the page was deleted
from
the
| address field on the Insert Hyperlink screen and was replaced by
| <%=FP_FieldLink(fp_rs,"ID")%>.
|
| Problem 2) When I click on the hyperlink ID field which attaches to
the
| second ASP page with all the data it says "page Cannot be found
404".
|
| you can see this at
|
http://www.firstchurchtulsacancersupport.org/currently battling cancer.asp.
|
| So far I have
|
| deleted the entire database and rebuilt it
| Recalculated hyperlinks
| created completely new pages to test.
|
| I am at a loss. I have done this same thing many times on other
websites.
|
| Thanks,
|
| Bruce Dill
| bruce@ brucedill.com
| --
| Bruce Dill