I saw you got "something" working
- but your links on the last page are still incorrect (even though you are getting something for results)
The last link is passing say
http://www.scmpersonnel.com.au/cand...p+Account+Manager#http://An+exp+Account+Manag'
Becaase you have not set the link (in the results page) correctly
The code it is generating is invalid w/ 2 links
<td width="12%">
<a href="results.asp?ViewEvaluations='An+exp+Account+Manager%23http%3A%2F%2FAn+exp+Account+Manag'"></a>
<a
href="result.asp?FirstName='John'&LastName='Holmes'&ViewEvaluations='An+exp+Account+Manager%23http%3A%2F%2FAn+exp+Account+Manag'">
<font color="#0000CC">
John Holmes</font></a></td>
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| Hi Stefan,
|
| I've resolved the issue. The problem was that I didn't click the search box
| in the last last stage of the DRW builder. So Once again, thank you so much
| for all your assistance.
| --
| Thank you for your assistance
|
|
| "Stefan B Rusynko" wrote:
|
| > Both Thomas and I have been telling you how to do it
| > - But you are using the DBRW which is not totally customizable
| > The method for adding parameters to a DBRW field is at
| >
http://support.microsoft.com/default.aspx?scid=kb;EN-US;237805\
| >
| > w/o seeing a code snippet of what you have done in the DBRW cell to create the link in results.asp (after reviewing above) we
can't
| > help
| > - and obviously your sql string in the display.asp is not correct because it is refusing to show result even w/ correct
parameters
| >
| > After your have reviewed above link and corrected the link in results
| > Make a copy of your display.asp and results.asp (plus your drop1.asp & drop2.asp)
| > - and then rename the copies to be .txt (instead of .asp) so we can see your code
| > Provide a link to all 4 .txt files
| >
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Hi Stefan,
| > |
| > | Crickey, don't you ever go to bed? What are you, a vampire?!
| > |
| > | Seriously though, in my results_page.asp, what I'm trying to do is create a
| > | hyperlink to display.asp so when clients click on evaluations field (in
| > | results_page.asp), the hyperlink will take those clients to the display.asp
| > | page so they can view my interview evaluation in the viewevaluations field in
| > | display.asp. So, how do you suggest I express that query?
| > | --
| > | Thank you for your assistance
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Your problem is you are not building a valid query string w/ John as a parameter
| > | > In
| > | >
http://www.scmpersonnel.com.au/candidates/database2_interface/candidates/results_page.asp
| > | > You don't have
| > | > <a href="display.asp?FirstName=John">John</a>
| > | >
| > | > You have
| > | > <a href="display.asp?ViewEvaluations=An+exp+Account+Manager">John</a>
| > | >
| > | > Which of course give you no results at
| > | >
http://www.scmpersonnel.com.au/cand...ay.asp?ViewEvaluations=An+exp+Account+Manager
| > | >
| > | > But so does an address bar link of just
| > | >
http://www.scmpersonnel.com.au/candidates/database2_interface/candidates/display.asp?FirstName=John
| > | >
| > | > So you have 2 problems
| > | > - 1 in building the results.asp table and the other in your SQL string on display.asp
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > | Hi Thomas,
| > | > |
| > | > | I've made those alterations, but I'm still getting the same error:
| > | > |
| > | > | "Server error there is no page with URL display.asp in this web".
| > | > |
| > | > | Fondly enough, when I click on
| > | > |
http://www.scmpersonnel.com.au/candidates/database2_interface/candidates/drop1.asp
| > | > | and follow the links all the way it actually takes me to the display.asp page
| > | > | but it doesn't reveal any results. I've typed evaluations for each of the
| > | > | candidates in the display.asp page but they don't appear for some reason?
| > | > | Anymore suggestions would be greatly appreciated.
| > | > |
| > | > | --
| > | > | Thank you for your assistance
| > | > |
| > | > |
| > | > | "Thomas A. Rowe" wrote:
| > | > |
| > | > | > Try changing this
| > | > | >
| > | > | > <a href="display.asp?FirstName='<%=FP_FieldURL(fp_rs,"FirstName")%>'">
| > | > | >
| > | > | > to this
| > | > | >
| > | > | > <a href="display.asp?FirstName=<%=FP_FieldURL(fp_rs,"FirstName")%>">
| > | > | >
| > | > | > Make sure display.asp is in the same location as the page linking to it, do not link across
| > | > | > subwebs/subsites.
| > | > | >
| > | > | > --
| > | > | > ==============================================
| > | > | > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > | > ==============================================
| > | > | > If you feel your current issue is a results of installing
| > | > | > a Service Pack or security update, please contact
| > | > | > Microsoft Product Support Services:
| > | > | >
http://support.microsoft.com
| > | > | > If the problem can be shown to have been caused by a
| > | > | > security update, then there is usually no charge for the call.
| > | > | > ==============================================
| > | > | >
| > | > | > | > | > | > > Stefan,
| > | > | > >
| > | > | > > I've looked at my query string in results_page.asp in the evaluations field,
| > | > | > > which I'm trying to send data to the display.asp page and the query is as
| > | > | > > follows:
| > | > | > >
| > | > | > > <a href="display.asp?FirstName='<%=FP_FieldURL(fp_rs,"FirstName")%>'">
| > | > | > >
| > | > | > > But again, when I click on the hyperlink, the message never changes: "Server
| > | > | > > error there is no page with URL display.asp in this web".
| > | > | > >
| > | > | > > While in the display.asp page under criteria I have added FirstName.
| > | > | > > Therefore what am I doing wrong?
| > | > | > >
| > | > | > >
| > | > | > > --
| > | > | > > Thank you for your assistance
| > | > | > >
| > | > | > >
| > | > | > > "Stefan B Rusynko" wrote:
| > | > | > >
| > | > | > >>
| > | > | > >> In the results at
| > | > | > >>
http://www.scmpersonnel.com.au/candidates/database2_interface/candidates/results_page.asp
| > | > | > >> You have illegally nested 2 hyperlinks as
| > | > | > >> <a href="display.asp?FirstName='John'">
| > | > | > >> <a href="John">John</a></a></td>
| > | > | > >> Which only should be
| > | > | > >> <a href="display.asp?FirstName='John'"></a>
| > | > | > >>
| > | > | > >> And as Thomas pointed out, it should be w/o quotes as
| > | > | > >> <a href="display.asp?FirstName=John"></a>
| > | > | > >>
| > | > | > >> But the link entered in yet browser as
| > | > | > >>
http://www.scmpersonnel.com.au/candidates/database2_interface/candidates/display.asp?FirstName=John
| > | > | > >> results in no records returned
| > | > | > >> - so you either don't have a John in your DB
| > | > | > >> - or your query string is wrong
| > | > | > >> (you are not passing the correct field info)
| > | > | > >>
| > | > | > >> For passing a URL query string you should look at
| > | > | > >>
http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Link
| > | > | > >>
| > | > | > >> --
| > | > | > >>
| > | > | > >> _____________________________________________
| > | > | > >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > | > >> "Warning - Using the F1 Key will not break anything!" (-;
| > | > | > >> To find the best Newsgroup for FrontPage support see:
| > | > | > >>
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > | > >> _____________________________________________
| > | > | > >>
| > | > | > >>
| > | > | > >> | > | > | > >> | Thomas,
| > | > | > >> |
| > | > | > >> | What do you mean the database name doesn't belong as part of the hyperlink?
| > | > | > >> |
| > | > | > >> | If you follow the below link you will hopefully see that what I'm trying to
| > | > | > >> | do is allow my clients to click on the hyperlink in results_page.asp that
| > | > | > >> | will take them to my interview evaluations displayed in display.asp:
| > | > | > >> |
| > | > | > >> |
http://www.scmpersonnel.com.au/candidates/database2_interface/candidates/drop1.asp.
| > | > | > >> | --
| > | > | > >> | Thank you for your assistance
| > | > | > >> |
| > | > | > >> |
| > | > | > >> | "Thomas A. Rowe" wrote:
| > | > | > >> |
| > | > | > >> | > The database name doesn't belong as part of the hyperlink.
| > | > | > >> | >
| > | > | > >> | > --
| > | > | > >> | > ==============================================
| > | > | > >> | > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > | > >> | > ==============================================
| > | > | > >> | > If you feel your current issue is a results of installing
| > | > | > >> | > a Service Pack or security update, please contact
| > | > | > >> | > Microsoft Product Support Services:
| > | > | > >> | >
http://support.microsoft.com
| > | > | > >> | > If the problem can be shown to have been caused by a
| > | > | > >> | > security update, then there is usually no charge for the call.
| > | > | > >> | > ==============================================
| > | > | > >> | >
| > | > | > >> | > | > | > | > >> | > > Stefan,
| > | > | > >> | > >
| > | > | > >> | > > I have done tests and the data doesn't appear when I click on the hyperlink
| > | > | > >> | > > from results.asp to display.asp. In regard to the subweb, I currently have
| > | > | > >> | > > subweb permissions set to the same as parent page. Candidates are listed
| > | > | > >> | > > twice because the subweb is called Candidates and so too is the database.
| > | > | > >> | > >
| > | > | > >> | > > The hyperlink from results_page.asp to display.asp is fine, it's only when I
| > | > | > >> | > > create a query string "ViewEvaluations" from "Evaluations" field, in
| > | > | > >> | > > results_page.asp display.asp that I have the problem. So it must be the
| > | > | > >> | > > coding, wouldn't you agree?
| > | > | > >> | > > --
| > | > | > >> | > > Thank you for your assistance
| > | > | > >> | > >
| > | > | > >> | > >
| > | > | > >> | > > "Stefan B Rusynko" wrote:
| > | > | > >> | > >
| > | > | > >> | > >> Look at that path
| > | > | > >> | > >> - you repeat candidates
| > | > | > >> | > >>
| > | > | > >> | > >> Post the URL to the form sending the results to display.asp
| > | > | > >> | > >> (w/ some valid test data that will yield a good result)
| > | > | > >> | > >> And a code snippet from display.asp for the actual DBR table row containing your link
| > | > | > >> | > >>
| > | > | > >> | > >> As for your local host problem make the correct subweb in FP in your root web using Tools
| > | > | > >> Server
| > | > | > >> | > >> Admin
| > | > | > >> | > >> --
| > | > | > >> | > >>
| > | > | > >> | > >> _____________________________________________
| > | > | > >> | > >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > | > >> | > >> "Warning - Using the F1 Key will not break anything!" (-;
| > | > | > >> | > >> To find the best Newsgroup for FrontPage support see:
| > | > | > >> | > >>
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > | > >> | > >> _____________________________________________
| > | > | > >> | > >>
| > | > | > >> | > >>
| > | > | > >> | > >> | > | > | > >> | > >> | Hi Andrew,
| > | > | > >> | > >> |
| > | > | > >> | > >> | Yes, I did publish the page called display.asp. A sample link is
| > | > | > >> | > >> |
http://www.scmpersonnel.com.au/candidates/database2_interface/candidates/display.asp.
| > | > | > >> | > >> | But because candidates is a subweb, it's not opening up in my localhost;
| > | > | > >> | > >> | claiming I don't have authority?
| > | > | > >> | > >> | --
| > | > | > >> | > >> | Thank you for your assistance
| > | > | > >> | > >> |
| > | > | > >> | > >> |
| > | > | > >> | > >> | "Andrew Murray" wrote:
| > | > | > >> | > >> |
| > | > | > >> | > >> | > Did you publish the file called "display.asp" ?
| > | > | > >> | > >> | >
| > | > | > >> | > >> | > Can you show us a sample link to the problem page?
| > | > | > >> | > >> | >
| > | > | > >> | > >> | > | > | > | > >> | > >> | > > Hello I'm wondering if someone could please assist me with a database
| > | > | > >> | > >> | > > hyperlink. I'm using FP2003 and Access2003; I've created a hyperlink from
| > | > | > >> | > >> | > > a
| > | > | > >> | > >> | > > results_page.asp to a display.asp page. However, what I've discovered is
| > | > | > >> | > >> | > > when I create a hyperlink to the display.asp page, everything is fine.
| > | > | > >> | > >> | > > But
| > | > | > >> | > >> | > > when I attempt to pass a query string to display.asp page, from
| > | > | > >> | > >> | > > results_page.asp, I keep getting the same message:
| > | > | > >> | > >> | > >
| > | > | > >> | > >> | > > server error - there is no file with URL display.asp page in this web.
| > | > | > >> | > >> | > > Any
| > | > | > >> | > >> | > > assistance would be greatly appreciated.
| > | > | > >> | > >> | > > --
| > | > | > >> | > >> | > > Thank you for your assistance
| > | > | > >> | > >> | >
| > | > | > >> | > >> | >
| > | > | > >> | > >> | >
| > | > | > >> | > >>
| > | > | > >> | > >>
| > | > | > >> | > >>
| > | > | > >> | >
| > | > | > >> | >
| > | > | > >> | >
| > | > | > >>
| > | > | > >>
| > | > | > >>
| > | > | >
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
| >
