Database Results

[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]

One problem I see is you appear to have named your DB fields with spaces in the names as in
"Current Member Status" and "Last Name"
- rename all DB fields to remove any spaces or punctuation
"CurrentMemberStatus" and "LastName"
And redo your DBR

Your link need to be done in code view as
<a href="UpdatesMemberData.asp?ID=<%=FP_FieldLink(fp_rs,"ID")%>">See Details</a>

To see how to pass parameters to pages see
http://www.spiderwebwoman.com/thingumajig/tweaks.htm#passing

PS

Also remove all spaces from all file/folder names in your site


--

_____________________________________________
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