G
Guest
Thanks Stefan,
I'll give it a go first thing tomorrow morning....it's nearly 11pm here in
Sydney; I'm exhausted and my eye sight's going all blurry!
--
Thank you for your assistance
I'll give it a go first thing tomorrow morning....it's nearly 11pm here in
Sydney; I'm exhausted and my eye sight's going all blurry!
--
Thank you for your assistance
Stefan B Rusynko said:Explain in detail
You don't embed anything in the DB or the resume page
You have a DB w/ a field named ViewResume
- what type of field is it in your Access DB
Normally it would be Just be a document name for each resume
- say: JohnWayneResume.doc
That document file (JohnWayneResume.doc) would have to exist in your FP web in some folder relative to your DBRW page
- say in a folder named "resumes" under the folder containing the DBRW page
You should probably also have a field named say ResumeName containing just the hyperlink description
- in you example just a text field containing "John Wayne's Resume"
So w/o the DBRW your link would be
<a href="resumes/JohnWayneResume.doc">John Wayne's Resume</a>
Your DBRW should be set to display both fields (ViewResume and ResumeName) from your DB
- it will put them in 2 table cells (because that is all it can do) in a table row between the 2 yellow DBRW container tags (plus a
table header row)
The 2 cells in code view will contain something like
<td><!--webot....><%=FP_FieldVal(fp_rs,"ViewResume")%><!--webot....></td>
<td><!--webot....><%=FP_FieldVal(fp_rs,"ResumeName")%><!--webot....></td>
So you need to merge the 2 table cells (as well as the 2 heading cells above them)
- and then edit the ASP code only (the part that is" <%= %>) to be
<td><!--webot....><a href="resumes/<%=FP_FieldVal(fp_rs,"ViewResume")%>"><%=FP_FieldVal(fp_rs,"ResumeName")%></a><!--webot....></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
_____________________________________________
| Now I don't know if I should be laughing or crying! Well in that case, please
| let me quickly explain my problem. I have created hyperlinks in my Access
| database (in the ViewResume field); so if you wanted to view John Wayne's
| resume, you would simply click on the "view resume hyperlink" in the column.
| The link would then take you to the word doc (John Wayne's Resume) which is
| embedded in the www.scmpersonnel.com.au/memberssite/resumes (subweb not
| accessible to public yet). All works well until I upload database to subweb
| and try to view it in explorer. I can create a hyperlink to John Wayne's
| resume, from DRW, and view it on the net, but if I wanted to view Bill
| Clinton's, or Bob Hope's resumes, I wanted be able to because the hyperlink
| is linked to John Wayne's resume. So, what should I do? Table is called
| Candidates and interface is called database5
| --
| Thank you for your assistance
|
|
| "Stefan B Rusynko" wrote:
|
| > Ask your IT "Expert" (-;
| > - his solution is fine if you know / understand ASP.net
| >
| > I could have just as easily told you to use classic ASP to do the same
| > (instead of using the DBRW)
| >
| > Use of ASP.net on your PC or your hosted server requires ASP.net to be installed on both and set w/ the correct permissions
| >
| > Your objective was to display a DBRW in a particular format
| > - not learn a new technology
| >
| > --
| >
| > _____________________________________________
| > 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 spoke with someone with an IT background today, about this database issue,
| > | he suggested I should simply load the database connecting to asp.net. I'm
| > | not sure if you should be laughing or crying; I installed a new interface
| > | database in asp.net only to find that I couldn't view the page in explorer
| > | due to this error message:
| > |
| > | Server Error in '/Members Site' Application.
| > | --------------------------------------------------------------------------------
| > |
| > | Runtime Error
| > | Description: An application error occurred on the server. The current custom
| > | error settings for this application prevent the details of the application
| > | error from being viewed remotely (for security reasons). It could, however,
| > | be viewed by browsers running on the local server machine.
| > |
| > | Details: To enable the details of this specific error message to be viewable
| > | on remote machines, please create a <customErrors> tag within a "web.config"
| > | configuration file located in the root directory of the current web
| > | application. This <customErrors> tag should then have its "mode" attribute
| > | set to "Off".
| > |
| > |
| > | <!-- Web.Config Configuration File -->
| > |
| > | <configuration>
| > | <system.web>
| > | <customErrors mode="Off"/>
| > | </system.web>
| > | </configuration>
| > |
| > |
| > | Notes: The current error page you are seeing can be replaced by a custom
| > | error page by modifying the "defaultRedirect" attribute of the application's
| > | <customErrors> configuration tag to point to a custom error page URL.
| > |
| > |
| > | <!-- Web.Config Configuration File -->
| > |
| > | <configuration>
| > | <system.web>
| > | <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
| > | </system.web>
| > | </configuration>
| > |
| > | However, when I installed the <customErrors mode="Off"/> into the web config
| > | page I still continued to get the same error. Apart from doing away with the
| > | database completely, any suggestions?
| > |
| > | Sorry to keep harassing you!
| > | --
| > | Thank you for your assistance
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Find that field in the table/row between the 2 yellow DBRW rows and it is editable in code view
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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
| > | > _____________________________________________
| > | >
| > | >
| > | > | Stefan,
| > | > |
| > | > | I've tried your thread, but the only thread that is identical to the one
| > | > | you've indicated is in purple and therefore, I can't amend it. What I'm
| > | > | trying to do is recreate what I can do in Access 2003 and that is click on
| > | > | the hyperlink in the ViewResume field to go directly to the word document,
| > | > | which is a resume specifically relating to that candidate. As I mentioned, it
| > | > | works in Access but not in Frontpage 2003, but I'm not sure why? Also, the
| > | > | Access hyperlink script appears in the ResumeView field in Frontpage, in
| > | > | internet explorer (and not in Access), but the hyperlink (in Frontpage) does
| > | > | not work. So, any suggestions on how I can make this work would be greatly
| > | > | appreciated.
| > | > |
| > | > | Thank you for your assistance
| > | > |
| > | > |
| > | > | "Stefan B Rusynko" wrote:
| > | > |
| > | > | > If the field ViewResume referred to in your code
| > | > | > <%=FP_FieldVal(fp_rs,"ViewResume")%>
| > | > | > has the resume file name and extension and your resumes folder is at the same level as the page w/ that code
| > | > | > Then in code view edit it to be
| > | > | > <a href="resumes/<%=FP_FieldVal(fp_rs,"ViewResume")%>" target="_blank">View Resume</a>
| > | > | >
| > | > | >
| > | > | > --
| > | > | >
| > | > | > _____________________________________________
| > | > | > 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,
| > | > | > |
| > | > | > | The code relating to the ViewResume field is as follows:
| > | > | > |
| > | > | > | <!--webbot bot="DatabaseResultColumn"
| > | > | > |
| > | > | >
| > | >
| >
s-columnnames="AutoNumber,PositionSought,Industry,FirstName,LastName,CurrentPosition,Address,Suburb,Phone,MobilePhone,Email,SubmitResume,ViewResume,Remuneration
| > | > | > | Expectations,UserName,Password,ConfirmPassword,TimeStamp"
| > | > | > | s-column="ViewResume" b-tableformat="TRUE" b-hashtml="FALSE"
| > | > | > | b-makelink="FALSE" clientside b-MenuFormat preview="<font
| > | > | > | size="-1"><<</font>ViewResume<font size="-1">>></font>" startspan
| > | > | > | --><%=FP_FieldVal(fp_rs,"ViewResume")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | endspan i-checksum="29808" -->
| > | > | > | --
| > | > | > | Thank you for your assistance
| > | > | > |
| > | > | > |
| > | > | > | "Thomas A. Rowe" wrote:
| > | > | > |
| > | > | > | > You have to show me your actual code...
| > | > | > | >
| > | > | > | > --
| > | > | > | > ==============================================
| > | > | > | > 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.
| > | > | > | > ==============================================
| > | > | > | >
| > | > | > | > | > | > | > | > > Sorry Thomas,
| > | > | > | > >
| > | > | > | > > But I'm still having difficulties. I pasted that string at the end of the
| > | > | > | > > line (ViewResume) on the HTML code on the database, but it's still not
| > | > | > | > > working. What am I doing wrong?
| > | > | > | > > --
| > | > | > | > > Thank you for your assistance
| > | > | > | > >
| > | > | > | > >
| > | > | > | > > "Thomas A. Rowe" wrote:
| > | > | > | > >
| > | > | > | > >> 1. Your page must have .asp extension.
| > | > | > | > >>
| > | > | > | > >> 2. You would paste the following where you want to have the link (HTML/Code View):
| > | > | > | > >>
| > | > | > | > >> <a href="../resumes/<%=RecordSetName("ViewResume")%>.doc" target="_blank">View Resume</a>
| > | > | > | > >>
| > | > | > | > >> ViewResume = the name of the document without the file extension and no path info.
| > | > | > | > >> ==============================================
| > | > | > | > >> 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.
| > | > | > | > >> ==============================================
| > | > | > | > >>
| > | > | > | > >> | > | > | > | > >> > Hi Thomas,
| > | > | > | > >> >
| > | > | > | > >> > I've already created a hyperlink text field called ViewResume; but where in
| > | > | > | > >> > the HMTL page do I paste that script? By the way, my folder is called resumes
| > | > | > | > >> > --
| > | > | > | > >> > Thank you for your assistance
| > | > | > | > >> >
| > | > | > | > >> >
| > | > | > | > >> > "Thomas A. Rowe" wrote:
| > | > | > | > >> >
| > | > | > | > >> >> All document are stored in the Resume folder within your website, correct?
| > | > | > | > >> >>
| > | > | > | > >> >> Then in your database create a text field, called DocumentName, then in your ASP page do the
| > | > | > | > >> >> following:
| > | > | > | > >> >>
| > | > | > | > >> >> <a href="../Resume/<%=RecordSetName("DocumentName")%>.doc" target="_blank">Click to View
| > | > | > | > >> >> Resume</a>
| > | > | > | > >> >>
| > | > | > | > >> >> --
| > | > | > | > >> >> ==============================================
| > | > | > | > >> >> 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.
| > | > | > | > >> >> ==============================================
| > | > | > | > >> >>
| > | > | > | > >> >> | > | > | > | > >> >> > Hi Thomas,
| > | > | > | > >> >> >
| > | > | > | > >> >> > Thanks for your email, but I'm still a little bit confused. What do you
| > | > | > | > >> >> > mean, sorry, I don't really know very much about databases.
| > | > | > | > >> >> > --
| > | > | > | > >> >> > Thank you for your assistance
| > | > | > | > >> >> >
| > | > | > | > >> >> >
| > | > | > | > >> >> > "Thomas A. Rowe" wrote:
| > | > | > | > >> >> >
| > | > | > | > >> >> >> You need to place the filename of the document in a text field within your database. The
| > | > | > | > >> >> >> path
| > | > | > | > >> >> >> can
| > | > | > | > >> >> >> then be hardcoded in the page to the folder.