Hyperlinks from Database Results

Graham · Dec 16, 2005

Stored in this field is a hyperlink for a jpg or gif but the link is to
another website, which is not my website. Here is an example;
http://www.mandmsports.com/bigpix/PS72.jpg
--
Many thanks

Graham

Stefan B Rusynko said:
And what is stored in the database field for: Small Image
- an image name or html tag w/ the image name?
And what are you trying to get to be displayed for that field on the page
--

_____________________________________________
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
_____________________________________________

| Kathleen,
|
| This is the field that I am having problems with, ie Small Image:
|
| <%=FP_FieldVal(fp_rs,"Small Image")%></td>
|
|
| --
| Many thanks
|
| Graham
|
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > Graham:
| > Could you send me a small extract of your database (10 records or so)? I
| > will try and figure this out for you.
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| > FrontPage Support: http://www.frontpagemvps.com/
| >
| >
| >
| >
| > | > > <html>
| > >
| > > <head>
| > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > > not
| > > Edit.
| > > FP_CharSet = "windows-1252"
| > > FP_CodePage = 1252 %>
| > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > > <title>Testing2.asp</title>
| > > </head>
| > >
| > > <body>
| > >
| > > <table width="100%" border="1">
| > > <thead>
| > > <tr>
| > > <th ALIGN="LEFT">ID</th>
| > > <th ALIGN="LEFT">Category</th>
| > > <th ALIGN="LEFT">Sub Category</th>
| > > <th ALIGN="LEFT">Make</th>
| > > <th ALIGN="LEFT">Make and brief description</th>
| > > <th ALIGN="LEFT">Description</th>
| > > <th ALIGN="LEFT">Price</th>
| > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > > <th ALIGN="LEFT">Small Image</th>
| > > <th ALIGN="LEFT">Medium Image</th>
| > > <th ALIGN="LEFT">DeepLink</th>
| > > </tr>
| > > </thead>
| > > <tbody>
| > > 
| > > <% if 0 then %>
| > > <SCRIPT Language="JavaScript">
| > > document.write("<div style='background: yellow; color: black;'>The
| > > Database
| > > Results component on this page is unable to display database content. The
| > > page must have a filename ending in '.asp', and the web must be hosted on
| > > a
| > > server that supports Active Server Pages.</div>");
| > > </SCRIPT>
| > > <% end if %>
| > > <%
| > > fp_sQry="SELECT * FROM Products"
| > > fp_sDefault=""
| > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > > returned.</td></tr>"
| > > fp_sDataConn="Sample"
| > > fp_iMaxRecords=25
| > > fp_iCommandType=1
| > > fp_iPageSize=5
| > > fp_fTableFormat=True
| > > fp_fMenuFormat=False
| > > fp_sMenuChoice="ID"
| > > fp_sMenuValue="ID"
| > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > > description=202&Description=202&Price=5&Savings (where
| > > applicable)=202&Small
| > > Image=203&Medium Image=203&DeepLink=203&"
| > > fp_iDisplayCols=11
| > > fp_fCustomQuery=False
| > > BOTID=0
| > > fp_iRegion=BOTID
| > > %>
| > > 
| > > <tr>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Sub
| > > Category")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Make and brief description")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Description")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Price")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Savings (where applicable)")%></td>
| > > <td>
| > > <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > > <td>
| > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></td>
| > > <td>
| > > <%="<a href="""
| > > &
| > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > > "</a>"%></td>
| > > </tr>
| > > 
| > > </tbody>
| > > </table>
| > >
| > > </body>
| > >
| > > </html>
| > > --
| > > Many thanks
| > >
| > > Graham
| > >
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> Can you paste the Code from your ASP page in a post?
| > >>
| > >> --
| > >> ==============================================
| > >> 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.
| > >> ==============================================
| > >>
| > >> | > >> > Thomas,
| > >> >
| > >> > Sorry for the time delays but I can only work on these when I get home
| > >> > from
| > >> > work.
| > >> > Firstly, can you explain what the recordset would be as I am trying to
| > >> > display everything from one table call Products.
| > >> >
| > >> > Also when you say display on page, are you saying that in design view,
| > >> > where
| > >> > I currently get <<medium_Image>> I should replace this with <img
| > >> > src="<%=recordset("Medium_Image")%>">

Stefan B Rusynko · Dec 16, 2005

Normally (properly done) that should yield just an image in the browser window when that link is clicked

But the server side scripting on that site renders a ASP page from M and M Sports instead of an image when I paste the URL in the
address bar
- if it is not your site they are probably (correctly) blocking image / bandwidth theft
- if it is your site fix the code there to allow the remote image link

Once you fix that major issue:

To display the image URL change
<%=FP_FieldVal(fp_rs,"Small Image")%>
to
<a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>

To display the image change
<%=FP_FieldVal(fp_rs,"Small Image")%>
to
<img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
--

_____________________________________________
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
_____________________________________________

|
| Stored in this field is a hyperlink for a jpg or gif but the link is to
| another website, which is not my website. Here is an example;
| http://www.mandmsports.com/bigpix/PS72.jpg
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > And what is stored in the database field for: Small Image
| > - an image name or html tag w/ the image name?
| > And what are you trying to get to be displayed for that field on the page
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > | Kathleen,
| > |
| > | This is the field that I am having problems with, ie Small Image:
| > |
| > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > |
| > |
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Graham:
| > | > Could you send me a small extract of your database (10 records or so)? I
| > | > will try and figure this out for you.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > > <html>
| > | > >
| > | > > <head>
| > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > > not
| > | > > Edit.
| > | > > FP_CharSet = "windows-1252"
| > | > > FP_CodePage = 1252 %>
| > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > > <title>Testing2.asp</title>
| > | > > </head>
| > | > >
| > | > > <body>
| > | > >
| > | > > <table width="100%" border="1">
| > | > > <thead>
| > | > > <tr>
| > | > > <th ALIGN="LEFT">ID</th>
| > | > > <th ALIGN="LEFT">Category</th>
| > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > > <th ALIGN="LEFT">Make</th>
| > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > > <th ALIGN="LEFT">Description</th>
| > | > > <th ALIGN="LEFT">Price</th>
| > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > > <th ALIGN="LEFT">Small Image</th>
| > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > > </tr>
| > | > > </thead>
| > | > > <tbody>
| > | > > 
| > | > > <% if 0 then %>
| > | > > <SCRIPT Language="JavaScript">
| > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > > Database
| > | > > Results component on this page is unable to display database content. The
| > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > > a
| > | > > server that supports Active Server Pages.</div>");
| > | > > </SCRIPT>
| > | > > <% end if %>
| > | > > <%
| > | > > fp_sQry="SELECT * FROM Products"
| > | > > fp_sDefault=""
| > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > > returned.</td></tr>"
| > | > > fp_sDataConn="Sample"
| > | > > fp_iMaxRecords=25
| > | > > fp_iCommandType=1
| > | > > fp_iPageSize=5
| > | > > fp_fTableFormat=True
| > | > > fp_fMenuFormat=False
| > | > > fp_sMenuChoice="ID"
| > | > > fp_sMenuValue="ID"
| > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > > description=202&Description=202&Price=5&Savings (where
| > | > > applicable)=202&Small
| > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > > fp_iDisplayCols=11
| > | > > fp_fCustomQuery=False
| > | > > BOTID=0
| > | > > fp_iRegion=BOTID
| > | > > %>
| > | > > 
| > | > > <tr>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > > Category")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Make and brief description")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Description")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Price")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Savings (where applicable)")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > > <td>
| > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></td>
| > | > > <td>
| > | > > <%="<a href="""
| > | > > &
| > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > > "</a>"%></td>
| > | > > </tr>
| > | > > 
| > | > > </tbody>
| > | > > </table>
| > | > >
| > | > > </body>
| > | > >
| > | > > </html>
| > | > > --
| > | > > Many thanks
| > | > >
| > | > > Graham
| > | > >
| > | > >
| > | > > "Thomas A. Rowe" wrote:
| > | > >
| > | > >> Can you paste the Code from your ASP page in a post?
| > | > >>
| > | > >> --
| > | > >> ==============================================
| > | > >> 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.
| > | > >> ==============================================
| > | > >>
| > | > >> | > | > >> > Thomas,
| > | > >> >
| > | > >> > Sorry for the time delays but I can only work on these when I get home
| > | > >> > from
| > | > >> > work.
| > | > >> > Firstly, can you explain what the recordset would be as I am trying to
| > | > >> > display everything from one table call Products.
| > | > >> >
| > | > >> > Also when you say display on page, are you saying that in design view,
| > | > >> > where
| > | > >> > I currently get <<medium_Image>> I should replace this with <img
| > | > >> > src="<%=recordset("Medium_Image")%>">

Graham · Dec 17, 2005

Stefan,

It worked. Many, many thanks to you Jim, Thomas & Kathleen. I have learnt a
lot doing this, sorry for be so slow on the uptake but I am just a beginner.
--
Many thanks

Graham

Stefan B Rusynko said:
Normally (properly done) that should yield just an image in the browser window when that link is clicked

But the server side scripting on that site renders a ASP page from M and M Sports instead of an image when I paste the URL in the
address bar
- if it is not your site they are probably (correctly) blocking image / bandwidth theft
- if it is your site fix the code there to allow the remote image link

Once you fix that major issue:

To display the image URL change
<%=FP_FieldVal(fp_rs,"Small Image")%>
to
<a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>

To display the image change
<%=FP_FieldVal(fp_rs,"Small Image")%>
to
<img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
--

_____________________________________________
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
_____________________________________________

|
| Stored in this field is a hyperlink for a jpg or gif but the link is to
| another website, which is not my website. Here is an example;
| http://www.mandmsports.com/bigpix/PS72.jpg
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > And what is stored in the database field for: Small Image
| > - an image name or html tag w/ the image name?
| > And what are you trying to get to be displayed for that field on the page
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > | Kathleen,
| > |
| > | This is the field that I am having problems with, ie Small Image:
| > |
| > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > |
| > |
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Graham:
| > | > Could you send me a small extract of your database (10 records or so)? I
| > | > will try and figure this out for you.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > > <html>
| > | > >
| > | > > <head>
| > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > > not
| > | > > Edit.
| > | > > FP_CharSet = "windows-1252"
| > | > > FP_CodePage = 1252 %>
| > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > > <title>Testing2.asp</title>
| > | > > </head>
| > | > >
| > | > > <body>
| > | > >
| > | > > <table width="100%" border="1">
| > | > > <thead>
| > | > > <tr>
| > | > > <th ALIGN="LEFT">ID</th>
| > | > > <th ALIGN="LEFT">Category</th>
| > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > > <th ALIGN="LEFT">Make</th>
| > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > > <th ALIGN="LEFT">Description</th>
| > | > > <th ALIGN="LEFT">Price</th>
| > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > > <th ALIGN="LEFT">Small Image</th>
| > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > > </tr>
| > | > > </thead>
| > | > > <tbody>
| > | > > 
| > | > > <% if 0 then %>
| > | > > <SCRIPT Language="JavaScript">
| > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > > Database
| > | > > Results component on this page is unable to display database content. The
| > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > > a
| > | > > server that supports Active Server Pages.</div>");
| > | > > </SCRIPT>
| > | > > <% end if %>
| > | > > <%
| > | > > fp_sQry="SELECT * FROM Products"
| > | > > fp_sDefault=""
| > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > > returned.</td></tr>"
| > | > > fp_sDataConn="Sample"
| > | > > fp_iMaxRecords=25
| > | > > fp_iCommandType=1
| > | > > fp_iPageSize=5
| > | > > fp_fTableFormat=True
| > | > > fp_fMenuFormat=False
| > | > > fp_sMenuChoice="ID"
| > | > > fp_sMenuValue="ID"
| > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > > description=202&Description=202&Price=5&Savings (where
| > | > > applicable)=202&Small
| > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > > fp_iDisplayCols=11
| > | > > fp_fCustomQuery=False
| > | > > BOTID=0
| > | > > fp_iRegion=BOTID
| > | > > %>
| > | > > 
| > | > > <tr>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > > Category")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Make and brief description")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Description")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Price")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Savings (where applicable)")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > > <td>
| > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></td>
| > | > > <td>
| > | > > <%="<a href="""
| > | > > &
| > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > > "</a>"%></td>
| > | > > </tr>
| > | > > 
| > | > > </tbody>

Graham · Dec 17, 2005

I have one last field to get working. I have inserted a 'More Info' image in
a field called Deeplink, which has the hyperlink for someone elses website in
it. I have had a go and this is the code that I have so far.

<a href="fpdb/fpnwind.mdb?DeepLink='<%=FP_FieldURL(fp_rs,"DeepLink")%>'">
<img border="0" src="images/MoreInfo.2.gif" width="98"
height="30"></a></td>

An example of one deeplink is:

http://www.dgm2.com/m/activitygifts...product_detail.asp?subsectionid=1&productid=6

When I publish and test it looks like it is going to work but then doesn't.

Appreciate all help so far.
--
Many thanks

Graham

Stefan B Rusynko said:
Normally (properly done) that should yield just an image in the browser window when that link is clicked

But the server side scripting on that site renders a ASP page from M and M Sports instead of an image when I paste the URL in the
address bar
- if it is not your site they are probably (correctly) blocking image / bandwidth theft
- if it is your site fix the code there to allow the remote image link

Once you fix that major issue:

To display the image URL change
<%=FP_FieldVal(fp_rs,"Small Image")%>
to
<a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>

To display the image change
<%=FP_FieldVal(fp_rs,"Small Image")%>
to
<img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
--

_____________________________________________
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
_____________________________________________

|
| Stored in this field is a hyperlink for a jpg or gif but the link is to
| another website, which is not my website. Here is an example;
| http://www.mandmsports.com/bigpix/PS72.jpg
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > And what is stored in the database field for: Small Image
| > - an image name or html tag w/ the image name?
| > And what are you trying to get to be displayed for that field on the page
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > | Kathleen,
| > |
| > | This is the field that I am having problems with, ie Small Image:
| > |
| > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > |
| > |
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Graham:
| > | > Could you send me a small extract of your database (10 records or so)? I
| > | > will try and figure this out for you.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > > <html>
| > | > >
| > | > > <head>
| > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > > not
| > | > > Edit.
| > | > > FP_CharSet = "windows-1252"
| > | > > FP_CodePage = 1252 %>
| > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > > <title>Testing2.asp</title>
| > | > > </head>
| > | > >
| > | > > <body>
| > | > >
| > | > > <table width="100%" border="1">
| > | > > <thead>
| > | > > <tr>
| > | > > <th ALIGN="LEFT">ID</th>
| > | > > <th ALIGN="LEFT">Category</th>
| > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > > <th ALIGN="LEFT">Make</th>
| > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > > <th ALIGN="LEFT">Description</th>
| > | > > <th ALIGN="LEFT">Price</th>
| > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > > <th ALIGN="LEFT">Small Image</th>
| > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > > </tr>
| > | > > </thead>
| > | > > <tbody>
| > | > > 
| > | > > <% if 0 then %>
| > | > > <SCRIPT Language="JavaScript">
| > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > > Database
| > | > > Results component on this page is unable to display database content. The
| > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > > a
| > | > > server that supports Active Server Pages.</div>");
| > | > > </SCRIPT>
| > | > > <% end if %>
| > | > > <%
| > | > > fp_sQry="SELECT * FROM Products"
| > | > > fp_sDefault=""
| > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > > returned.</td></tr>"
| > | > > fp_sDataConn="Sample"
| > | > > fp_iMaxRecords=25
| > | > > fp_iCommandType=1
| > | > > fp_iPageSize=5
| > | > > fp_fTableFormat=True
| > | > > fp_fMenuFormat=False
| > | > > fp_sMenuChoice="ID"
| > | > > fp_sMenuValue="ID"
| > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > > description=202&Description=202&Price=5&Savings (where
| > | > > applicable)=202&Small
| > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > > fp_iDisplayCols=11
| > | > > fp_fCustomQuery=False
| > | > > BOTID=0
| > | > > fp_iRegion=BOTID
| > | > > %>
| > | > > 
| > | > > <tr>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > > Category")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Make and brief description")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Description")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Price")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Savings (where applicable)")%></td>
| > | > > <td>
| > | > > <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > > <td>
| > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></td>
| > | > > <td>
| > | > > <%="<a href="""
| > | > > &
| > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > > "</a>"%></td>
| > | > > </tr>
| > | > > 
| > | > > </tbody>

Stefan B Rusynko · Dec 18, 2005

You can Not link to or open an Access DB file in the browser

Delete "fpdb/fpnwind.mdb?DeepLink=" from your link
The link to your DB is just the recordset
<a href="<%=FP_FieldURL(fp_rs,"DeepLink")%>">...
--

_____________________________________________
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
_____________________________________________

|I have one last field to get working. I have inserted a 'More Info' image in
| a field called Deeplink, which has the hyperlink for someone elses website in
| it. I have had a go and this is the code that I have so far.
|
| <a href="fpdb/fpnwind.mdb?DeepLink='<%=FP_FieldURL(fp_rs,"DeepLink")%>'">
| <img border="0" src="images/MoreInfo.2.gif" width="98"
| height="30"></a></td>
|
| An example of one deeplink is:
|
|
http://www.dgm2.com/m/activitygifts...product_detail.asp?subsectionid=1&productid=6
|
| When I publish and test it looks like it is going to work but then doesn't.
|
| Appreciate all help so far.
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > Normally (properly done) that should yield just an image in the browser window when that link is clicked
| >
| > But the server side scripting on that site renders a ASP page from M and M Sports instead of an image when I paste the URL in
the
| > address bar
| > - if it is not your site they are probably (correctly) blocking image / bandwidth theft
| > - if it is your site fix the code there to allow the remote image link
| >
| > Once you fix that major issue:
| >
| > To display the image URL change
| > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > to
| > <a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>
| >
| > To display the image change
| > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > to
| > <img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > |
| > | Stored in this field is a hyperlink for a jpg or gif but the link is to
| > | another website, which is not my website. Here is an example;
| > | http://www.mandmsports.com/bigpix/PS72.jpg
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > And what is stored in the database field for: Small Image
| > | > - an image name or html tag w/ the image name?
| > | > And what are you trying to get to be displayed for that field on the page
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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
| > | > _____________________________________________
| > | >
| > | >
| > | > | Kathleen,
| > | > |
| > | > | This is the field that I am having problems with, ie Small Image:
| > | > |
| > | > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > |
| > | > |
| > | > | --
| > | > | Many thanks
| > | > |
| > | > | Graham
| > | > |
| > | > |
| > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > | > |
| > | > | > Graham:
| > | > | > Could you send me a small extract of your database (10 records or so)? I
| > | > | > will try and figure this out for you.
| > | > | >
| > | > | > --
| > | > | >
| > | > | > ~ Kathleen Anderson
| > | > | > Microsoft MVP - FrontPage
| > | > | > Spider Web Woman Designs
| > | > | > web: http://www.spiderwebwoman.com/resources/
| > | > | > FrontPage Support: http://www.frontpagemvps.com/
| > | > | >
| > | > | >
| > | > | >
| > | > | >
| > | > | > | > | > | > > <html>
| > | > | > >
| > | > | > > <head>
| > | > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > | > > not
| > | > | > > Edit.
| > | > | > > FP_CharSet = "windows-1252"
| > | > | > > FP_CodePage = 1252 %>
| > | > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > | > > <title>Testing2.asp</title>
| > | > | > > </head>
| > | > | > >
| > | > | > > <body>
| > | > | > >
| > | > | > > <table width="100%" border="1">
| > | > | > > <thead>
| > | > | > > <tr>
| > | > | > > <th ALIGN="LEFT">ID</th>
| > | > | > > <th ALIGN="LEFT">Category</th>
| > | > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > | > > <th ALIGN="LEFT">Make</th>
| > | > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > | > > <th ALIGN="LEFT">Description</th>
| > | > | > > <th ALIGN="LEFT">Price</th>
| > | > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > | > > <th ALIGN="LEFT">Small Image</th>
| > | > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > | > > </tr>
| > | > | > > </thead>
| > | > | > > <tbody>
| > | > | > > 
| > | > | > > <% if 0 then %>
| > | > | > > <SCRIPT Language="JavaScript">
| > | > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > | > > Database
| > | > | > > Results component on this page is unable to display database content. The
| > | > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > | > > a
| > | > | > > server that supports Active Server Pages.</div>");
| > | > | > > </SCRIPT>
| > | > | > > <% end if %>
| > | > | > > <%
| > | > | > > fp_sQry="SELECT * FROM Products"
| > | > | > > fp_sDefault=""
| > | > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > | > > returned.</td></tr>"
| > | > | > > fp_sDataConn="Sample"
| > | > | > > fp_iMaxRecords=25
| > | > | > > fp_iCommandType=1
| > | > | > > fp_iPageSize=5
| > | > | > > fp_fTableFormat=True
| > | > | > > fp_fMenuFormat=False
| > | > | > > fp_sMenuChoice="ID"
| > | > | > > fp_sMenuValue="ID"
| > | > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > | > > description=202&Description=202&Price=5&Savings (where
| > | > | > > applicable)=202&Small
| > | > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > | > > fp_iDisplayCols=11
| > | > | > > fp_fCustomQuery=False
| > | > | > > BOTID=0
| > | > | > > fp_iRegion=BOTID
| > | > | > > %>
| > | > | > > 
| > | > | > > <tr>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > | > > Category")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Make and brief description")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Description")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Price")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Savings (where applicable)")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > | > > <td>
| > | > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></td>
| > | > | > > <td>
| > | > | > > <%="<a href="""
| > | > | > > &
| > | > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > | > > "</a>"%></td>
| > | > | > > </tr>
| > | > | > > 
| > | > | > > </tbody>

Graham · Dec 19, 2005

Stefan,

When I do this the images hyperlink is the URL for where the image is
stored. What I am trying to do is have the same image for all results but the
URLs would be different depending what was show in the Deeplink field within
the database.

Any more ideas please.
--
Many thanks

Graham

Stefan B Rusynko said:
You can Not link to or open an Access DB file in the browser

Delete "fpdb/fpnwind.mdb?DeepLink=" from your link
The link to your DB is just the recordset
<a href="<%=FP_FieldURL(fp_rs,"DeepLink")%>">...
--

_____________________________________________
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
_____________________________________________

|I have one last field to get working. I have inserted a 'More Info' image in
| a field called Deeplink, which has the hyperlink for someone elses website in
| it. I have had a go and this is the code that I have so far.
|
| <a href="fpdb/fpnwind.mdb?DeepLink='<%=FP_FieldURL(fp_rs,"DeepLink")%>'">
| <img border="0" src="images/MoreInfo.2.gif" width="98"
| height="30"></a></td>
|
| An example of one deeplink is:
|
|
http://www.dgm2.com/m/activitygifts...product_detail.asp?subsectionid=1&productid=6
|
| When I publish and test it looks like it is going to work but then doesn't.
|
| Appreciate all help so far.
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > Normally (properly done) that should yield just an image in the browser window when that link is clicked
| >
| > But the server side scripting on that site renders a ASP page from M and M Sports instead of an image when I paste the URL in
the
| > address bar
| > - if it is not your site they are probably (correctly) blocking image / bandwidth theft
| > - if it is your site fix the code there to allow the remote image link
| >
| > Once you fix that major issue:
| >
| > To display the image URL change
| > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > to
| > <a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>
| >
| > To display the image change
| > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > to
| > <img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > |
| > | Stored in this field is a hyperlink for a jpg or gif but the link is to
| > | another website, which is not my website. Here is an example;
| > | http://www.mandmsports.com/bigpix/PS72.jpg
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > And what is stored in the database field for: Small Image
| > | > - an image name or html tag w/ the image name?
| > | > And what are you trying to get to be displayed for that field on the page
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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
| > | > _____________________________________________
| > | >
| > | >
| > | > | Kathleen,
| > | > |
| > | > | This is the field that I am having problems with, ie Small Image:
| > | > |
| > | > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > |
| > | > |
| > | > | --
| > | > | Many thanks
| > | > |
| > | > | Graham
| > | > |
| > | > |
| > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > | > |
| > | > | > Graham:
| > | > | > Could you send me a small extract of your database (10 records or so)? I
| > | > | > will try and figure this out for you.
| > | > | >
| > | > | > --
| > | > | >
| > | > | > ~ Kathleen Anderson
| > | > | > Microsoft MVP - FrontPage
| > | > | > Spider Web Woman Designs
| > | > | > web: http://www.spiderwebwoman.com/resources/
| > | > | > FrontPage Support: http://www.frontpagemvps.com/
| > | > | >
| > | > | >
| > | > | >
| > | > | >
| > | > | > | > | > | > > <html>
| > | > | > >
| > | > | > > <head>
| > | > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > | > > not
| > | > | > > Edit.
| > | > | > > FP_CharSet = "windows-1252"
| > | > | > > FP_CodePage = 1252 %>
| > | > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > | > > <title>Testing2.asp</title>
| > | > | > > </head>
| > | > | > >
| > | > | > > <body>
| > | > | > >
| > | > | > > <table width="100%" border="1">
| > | > | > > <thead>
| > | > | > > <tr>
| > | > | > > <th ALIGN="LEFT">ID</th>
| > | > | > > <th ALIGN="LEFT">Category</th>
| > | > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > | > > <th ALIGN="LEFT">Make</th>
| > | > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > | > > <th ALIGN="LEFT">Description</th>
| > | > | > > <th ALIGN="LEFT">Price</th>
| > | > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > | > > <th ALIGN="LEFT">Small Image</th>
| > | > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > | > > </tr>
| > | > | > > </thead>
| > | > | > > <tbody>
| > | > | > > 
| > | > | > > <% if 0 then %>
| > | > | > > <SCRIPT Language="JavaScript">
| > | > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > | > > Database
| > | > | > > Results component on this page is unable to display database content. The
| > | > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > | > > a
| > | > | > > server that supports Active Server Pages.</div>");
| > | > | > > </SCRIPT>
| > | > | > > <% end if %>
| > | > | > > <%
| > | > | > > fp_sQry="SELECT * FROM Products"
| > | > | > > fp_sDefault=""
| > | > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > | > > returned.</td></tr>"
| > | > | > > fp_sDataConn="Sample"
| > | > | > > fp_iMaxRecords=25
| > | > | > > fp_iCommandType=1
| > | > | > > fp_iPageSize=5
| > | > | > > fp_fTableFormat=True
| > | > | > > fp_fMenuFormat=False
| > | > | > > fp_sMenuChoice="ID"
| > | > | > > fp_sMenuValue="ID"
| > | > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > | > > description=202&Description=202&Price=5&Savings (where
| > | > | > > applicable)=202&Small
| > | > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > | > > fp_iDisplayCols=11
| > | > | > > fp_fCustomQuery=False
| > | > | > > BOTID=0
| > | > | > > fp_iRegion=BOTID
| > | > | > > %>
| > | > | > > 
| > | > | > > <tr>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > | > > Category")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Make and brief description")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Description")%></td>
| > | > | > > <td>
| > | > | > > <%=FP_FieldVal(fp_rs,"Price")%></td>
| > | > | > > <td>
| > | > | > > <!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Category,Sub
| > | > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > | > > applicable),Small Image,Medium Image,DeepLink" s-column="Savings (where

Stefan B Rusynko · Dec 20, 2005

Then store your desired URLs in the Deeplink field

--

_____________________________________________
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,
|
| When I do this the images hyperlink is the URL for where the image is
| stored. What I am trying to do is have the same image for all results but the
| URLs would be different depending what was show in the Deeplink field within
| the database.
|
| Any more ideas please.
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > You can Not link to or open an Access DB file in the browser
| >
| > Delete "fpdb/fpnwind.mdb?DeepLink=" from your link
| > The link to your DB is just the recordset
| > <a href="<%=FP_FieldURL(fp_rs,"DeepLink")%>">...
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > |I have one last field to get working. I have inserted a 'More Info' image in
| > | a field called Deeplink, which has the hyperlink for someone elses website in
| > | it. I have had a go and this is the code that I have so far.
| > |
| > | <a href="fpdb/fpnwind.mdb?DeepLink='<%=FP_FieldURL(fp_rs,"DeepLink")%>'">
| > | <img border="0" src="images/MoreInfo.2.gif" width="98"
| > | height="30"></a></td>
| > |
| > | An example of one deeplink is:
| > |
| > |
| >
http://www.dgm2.com/m/activitygifts...product_detail.asp?subsectionid=1&productid=6
| > |
| > | When I publish and test it looks like it is going to work but then doesn't.
| > |
| > | Appreciate all help so far.
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Normally (properly done) that should yield just an image in the browser window when that link is clicked
| > | >
| > | > But the server side scripting on that site renders a ASP page from M and M Sports instead of an image when I paste the URL
in
| > the
| > | > address bar
| > | > - if it is not your site they are probably (correctly) blocking image / bandwidth theft
| > | > - if it is your site fix the code there to allow the remote image link
| > | >
| > | > Once you fix that major issue:
| > | >
| > | > To display the image URL change
| > | > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > | > to
| > | > <a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>
| > | >
| > | > To display the image change
| > | > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > | > to
| > | > <img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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
| > | > _____________________________________________
| > | >
| > | >
| > | > |
| > | > | Stored in this field is a hyperlink for a jpg or gif but the link is to
| > | > | another website, which is not my website. Here is an example;
| > | > | http://www.mandmsports.com/bigpix/PS72.jpg
| > | > | --
| > | > | Many thanks
| > | > |
| > | > | Graham
| > | > |
| > | > |
| > | > | "Stefan B Rusynko" wrote:
| > | > |
| > | > | > And what is stored in the database field for: Small Image
| > | > | > - an image name or html tag w/ the image name?
| > | > | > And what are you trying to get to be displayed for that field on the page
| > | > | > --
| > | > | >
| > | > | > _____________________________________________
| > | > | > 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
| > | > | > _____________________________________________
| > | > | >
| > | > | >
| > | > | > | Kathleen,
| > | > | > |
| > | > | > | This is the field that I am having problems with, ie Small Image:
| > | > | > |
| > | > | > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > | > |
| > | > | > |
| > | > | > | --
| > | > | > | Many thanks
| > | > | > |
| > | > | > | Graham
| > | > | > |
| > | > | > |
| > | > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > | > | > |
| > | > | > | > Graham:
| > | > | > | > Could you send me a small extract of your database (10 records or so)? I
| > | > | > | > will try and figure this out for you.
| > | > | > | >
| > | > | > | > --
| > | > | > | >
| > | > | > | > ~ Kathleen Anderson
| > | > | > | > Microsoft MVP - FrontPage
| > | > | > | > Spider Web Woman Designs
| > | > | > | > web: http://www.spiderwebwoman.com/resources/
| > | > | > | > FrontPage Support: http://www.frontpagemvps.com/
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | > | > | > | > | > > <html>
| > | > | > | > >
| > | > | > | > > <head>
| > | > | > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > | > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > | > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > | > | > > not
| > | > | > | > > Edit.
| > | > | > | > > FP_CharSet = "windows-1252"
| > | > | > | > > FP_CodePage = 1252 %>
| > | > | > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > | > | > > <title>Testing2.asp</title>
| > | > | > | > > </head>
| > | > | > | > >
| > | > | > | > > <body>
| > | > | > | > >
| > | > | > | > > <table width="100%" border="1">
| > | > | > | > > <thead>
| > | > | > | > > <tr>
| > | > | > | > > <th ALIGN="LEFT">ID</th>
| > | > | > | > > <th ALIGN="LEFT">Category</th>
| > | > | > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > | > | > > <th ALIGN="LEFT">Make</th>
| > | > | > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > | > | > > <th ALIGN="LEFT">Description</th>
| > | > | > | > > <th ALIGN="LEFT">Price</th>
| > | > | > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > | > | > > <th ALIGN="LEFT">Small Image</th>
| > | > | > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > | > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > | > | > > </tr>
| > | > | > | > > </thead>
| > | > | > | > > <tbody>
| > | > | > | > > 
| > | > | > | > > <% if 0 then %>
| > | > | > | > > <SCRIPT Language="JavaScript">
| > | > | > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > | > | > > Database
| > | > | > | > > Results component on this page is unable to display database content. The
| > | > | > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > | > | > > a
| > | > | > | > > server that supports Active Server Pages.</div>");
| > | > | > | > > </SCRIPT>
| > | > | > | > > <% end if %>
| > | > | > | > > <%
| > | > | > | > > fp_sQry="SELECT * FROM Products"
| > | > | > | > > fp_sDefault=""
| > | > | > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > | > | > > returned.</td></tr>"
| > | > | > | > > fp_sDataConn="Sample"
| > | > | > | > > fp_iMaxRecords=25
| > | > | > | > > fp_iCommandType=1
| > | > | > | > > fp_iPageSize=5
| > | > | > | > > fp_fTableFormat=True
| > | > | > | > > fp_fMenuFormat=False
| > | > | > | > > fp_sMenuChoice="ID"
| > | > | > | > > fp_sMenuValue="ID"
| > | > | > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > | > | > > description=202&Description=202&Price=5&Savings (where
| > | > | > | > > applicable)=202&Small
| > | > | > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > | > | > > fp_iDisplayCols=11
| > | > | > | > > fp_fCustomQuery=False
| > | > | > | > > BOTID=0
| > | > | > | > > fp_iRegion=BOTID
| > | > | > | > > %>
| > | > | > | > > 
| > | > | > | > > <tr>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > | > | > > Category")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Make and brief description")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Description")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Price")%></td>
| > | > | > | > > <td>
| > | > | > | > > <!--webbot bot="DatabaseResultColumn" s-columnnames="ID,Category,Sub
| > | > | > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > | > | > > applicable),Small Image,Medium Image,DeepLink" s-column="Savings (where

Graham · Dec 20, 2005

The desired URLs are already in the Deeplink field but they are all different
depending on which record is retrieved.

Here is an example:
http://www.dgm2.com/m/flowers2send/...m/DetailContent.asp?refcode=DGM&lProductID=83

I am trying to get a 'more info' gif to appear irrespective of the fields
URL and then when you click on the gif it takes you to the URL in that
records Deeplink field.
--
Many thanks

Graham

Stefan B Rusynko said:
Then store your desired URLs in the Deeplink field

--

_____________________________________________
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,
|
| When I do this the images hyperlink is the URL for where the image is
| stored. What I am trying to do is have the same image for all results but the
| URLs would be different depending what was show in the Deeplink field within
| the database.
|
| Any more ideas please.
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > You can Not link to or open an Access DB file in the browser
| >
| > Delete "fpdb/fpnwind.mdb?DeepLink=" from your link
| > The link to your DB is just the recordset
| > <a href="<%=FP_FieldURL(fp_rs,"DeepLink")%>">...
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > |I have one last field to get working. I have inserted a 'More Info' image in
| > | a field called Deeplink, which has the hyperlink for someone elses website in
| > | it. I have had a go and this is the code that I have so far.
| > |
| > | <a href="fpdb/fpnwind.mdb?DeepLink='<%=FP_FieldURL(fp_rs,"DeepLink")%>'">
| > | <img border="0" src="images/MoreInfo.2.gif" width="98"
| > | height="30"></a></td>
| > |
| > | An example of one deeplink is:
| > |
| > |
| >
http://www.dgm2.com/m/activitygifts...product_detail.asp?subsectionid=1&productid=6
| > |
| > | When I publish and test it looks like it is going to work but then doesn't.
| > |
| > | Appreciate all help so far.
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Normally (properly done) that should yield just an image in the browser window when that link is clicked
| > | >
| > | > But the server side scripting on that site renders a ASP page from M and M Sports instead of an image when I paste the URL
in
| > the
| > | > address bar
| > | > - if it is not your site they are probably (correctly) blocking image / bandwidth theft
| > | > - if it is your site fix the code there to allow the remote image link
| > | >
| > | > Once you fix that major issue:
| > | >
| > | > To display the image URL change
| > | > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > | > to
| > | > <a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>
| > | >
| > | > To display the image change
| > | > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > | > to
| > | > <img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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
| > | > _____________________________________________
| > | >
| > | >
| > | > |
| > | > | Stored in this field is a hyperlink for a jpg or gif but the link is to
| > | > | another website, which is not my website. Here is an example;
| > | > | http://www.mandmsports.com/bigpix/PS72.jpg
| > | > | --
| > | > | Many thanks
| > | > |
| > | > | Graham
| > | > |
| > | > |
| > | > | "Stefan B Rusynko" wrote:
| > | > |
| > | > | > And what is stored in the database field for: Small Image
| > | > | > - an image name or html tag w/ the image name?
| > | > | > And what are you trying to get to be displayed for that field on the page
| > | > | > --
| > | > | >
| > | > | > _____________________________________________
| > | > | > 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
| > | > | > _____________________________________________
| > | > | >
| > | > | >
| > | > | > | Kathleen,
| > | > | > |
| > | > | > | This is the field that I am having problems with, ie Small Image:
| > | > | > |
| > | > | > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > | > |
| > | > | > |
| > | > | > | --
| > | > | > | Many thanks
| > | > | > |
| > | > | > | Graham
| > | > | > |
| > | > | > |
| > | > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > | > | > |
| > | > | > | > Graham:
| > | > | > | > Could you send me a small extract of your database (10 records or so)? I
| > | > | > | > will try and figure this out for you.
| > | > | > | >
| > | > | > | > --
| > | > | > | >
| > | > | > | > ~ Kathleen Anderson
| > | > | > | > Microsoft MVP - FrontPage
| > | > | > | > Spider Web Woman Designs
| > | > | > | > web: http://www.spiderwebwoman.com/resources/
| > | > | > | > FrontPage Support: http://www.frontpagemvps.com/
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | > | > | > | > | > > <html>
| > | > | > | > >
| > | > | > | > > <head>
| > | > | > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > | > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > | > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > | > | > > not
| > | > | > | > > Edit.
| > | > | > | > > FP_CharSet = "windows-1252"
| > | > | > | > > FP_CodePage = 1252 %>
| > | > | > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > | > | > > <title>Testing2.asp</title>
| > | > | > | > > </head>
| > | > | > | > >
| > | > | > | > > <body>
| > | > | > | > >
| > | > | > | > > <table width="100%" border="1">
| > | > | > | > > <thead>
| > | > | > | > > <tr>
| > | > | > | > > <th ALIGN="LEFT">ID</th>
| > | > | > | > > <th ALIGN="LEFT">Category</th>
| > | > | > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > | > | > > <th ALIGN="LEFT">Make</th>
| > | > | > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > | > | > > <th ALIGN="LEFT">Description</th>
| > | > | > | > > <th ALIGN="LEFT">Price</th>
| > | > | > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > | > | > > <th ALIGN="LEFT">Small Image</th>
| > | > | > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > | > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > | > | > > </tr>
| > | > | > | > > </thead>
| > | > | > | > > <tbody>
| > | > | > | > > 
| > | > | > | > > <% if 0 then %>
| > | > | > | > > <SCRIPT Language="JavaScript">
| > | > | > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > | > | > > Database
| > | > | > | > > Results component on this page is unable to display database content. The
| > | > | > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > | > | > > a
| > | > | > | > > server that supports Active Server Pages.</div>");
| > | > | > | > > </SCRIPT>
| > | > | > | > > <% end if %>
| > | > | > | > > <%
| > | > | > | > > fp_sQry="SELECT * FROM Products"
| > | > | > | > > fp_sDefault=""
| > | > | > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > | > | > > returned.</td></tr>"
| > | > | > | > > fp_sDataConn="Sample"
| > | > | > | > > fp_iMaxRecords=25
| > | > | > | > > fp_iCommandType=1
| > | > | > | > > fp_iPageSize=5
| > | > | > | > > fp_fTableFormat=True
| > | > | > | > > fp_fMenuFormat=False
| > | > | > | > > fp_sMenuChoice="ID"
| > | > | > | > > fp_sMenuValue="ID"
| > | > | > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > | > | > > description=202&Description=202&Price=5&Savings (where
| > | > | > | > > applicable)=202&Small
| > | > | > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > | > | > > fp_iDisplayCols=11
| > | > | > | > > fp_fCustomQuery=False
| > | > | > | > > BOTID=0
| > | > | > | > > fp_iRegion=BOTID
| > | > | > | > > %>
| > | > | > | > > 
| > | > | > | > > <tr>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > | > | > > Category")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > | > | > > <td>

Thomas A. Rowe · Dec 20, 2005

Insert the image, then assign the hyperlink to it...

--
==============================================
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.
==============================================

Graham said:
The desired URLs are already in the Deeplink field but they are all different
depending on which record is retrieved.

Here is an example:
http://www.dgm2.com/m/flowers2send/...m/DetailContent.asp?refcode=DGM&lProductID=83

I am trying to get a 'more info' gif to appear irrespective of the fields
URL and then when you click on the gif it takes you to the URL in that
records Deeplink field.
--
Many thanks

Graham

Stefan B Rusynko said:

Then store your desired URLs in the Deeplink field

--

_____________________________________________
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,
|
| When I do this the images hyperlink is the URL for where the image is
| stored. What I am trying to do is have the same image for all results but the
| URLs would be different depending what was show in the Deeplink field within
| the database.
|
| Any more ideas please.
| --
| Many thanks
|
| Graham
|
|
| "Stefan B Rusynko" wrote:
|
| > You can Not link to or open an Access DB file in the browser
| >
| > Delete "fpdb/fpnwind.mdb?DeepLink=" from your link
| > The link to your DB is just the recordset
| > <a href="<%=FP_FieldURL(fp_rs,"DeepLink")%>">...
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > |I have one last field to get working. I have inserted a 'More Info' image in
| > | a field called Deeplink, which has the hyperlink for someone elses website in
| > | it. I have had a go and this is the code that I have so far.
| > |
| > | <a href="fpdb/fpnwind.mdb?DeepLink='<%=FP_FieldURL(fp_rs,"DeepLink")%>'">
| > | <img border="0" src="images/MoreInfo.2.gif" width="98"
| > | height="30"></a></td>
| > |
| > | An example of one deeplink is:
| > |
| > |
| >
http://www.dgm2.com/m/activitygifts...product_detail.asp?subsectionid=1&productid=6
| > |
| > | When I publish and test it looks like it is going to work but then doesn't.
| > |
| > | Appreciate all help so far.
| > | --
| > | Many thanks
| > |
| > | Graham
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Normally (properly done) that should yield just an image in the browser window when that
link is clicked
| > | >
| > | > But the server side scripting on that site renders a ASP page from M and M Sports instead
of an image when I paste the URL
in
| > the
| > | > address bar
| > | > - if it is not your site they are probably (correctly) blocking image / bandwidth theft
| > | > - if it is your site fix the code there to allow the remote image link
| > | >
| > | > Once you fix that major issue:
| > | >
| > | > To display the image URL change
| > | > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > | > to
| > | > <a href="<%=FP_FieldVal(fp_rs,"Small Image")%>">Small Image Site</a>
| > | >
| > | > To display the image change
| > | > <%=FP_FieldVal(fp_rs,"Small Image")%>
| > | > to
| > | > <img src="<%=FP_FieldVal(fp_rs,"Small Image")%>">
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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
| > | > _____________________________________________
| > | >
| > | >
| > | > |
| > | > | Stored in this field is a hyperlink for a jpg or gif but the link is to
| > | > | another website, which is not my website. Here is an example;
| > | > | http://www.mandmsports.com/bigpix/PS72.jpg
| > | > | --
| > | > | Many thanks
| > | > |
| > | > | Graham
| > | > |
| > | > |
| > | > | "Stefan B Rusynko" wrote:
| > | > |
| > | > | > And what is stored in the database field for: Small Image
| > | > | > - an image name or html tag w/ the image name?
| > | > | > And what are you trying to get to be displayed for that field on the page
| > | > | > --
| > | > | >
| > | > | > _____________________________________________
| > | > | > 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
| > | > | > _____________________________________________
| > | > | >
| > | > | >
| > | > | > | Kathleen,
| > | > | > |
| > | > | > | This is the field that I am having problems with, ie Small Image:
| > | > | > |
| > | > | > | <%=FP_FieldVal(fp_rs,"Small Image")%></td>
| > | > | > |
| > | > | > |
| > | > | > | --
| > | > | > | Many thanks
| > | > | > |
| > | > | > | Graham
| > | > | > |
| > | > | > |
| > | > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > | > | > |
| > | > | > | > Graham:
| > | > | > | > Could you send me a small extract of your database (10 records or so)? I
| > | > | > | > will try and figure this out for you.
| > | > | > | >
| > | > | > | > --
| > | > | > | >
| > | > | > | > ~ Kathleen Anderson
| > | > | > | > Microsoft MVP - FrontPage
| > | > | > | > Spider Web Woman Designs
| > | > | > | > web: http://www.spiderwebwoman.com/resources/
| > | > | > | > FrontPage Support: http://www.frontpagemvps.com/
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | >
| > | > | > | > | > | > | > | > > <html>
| > | > | > | > >
| > | > | > | > > <head>
| > | > | > | > > <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | > | > | > > <meta name="ProgId" content="FrontPage.Editor.Document">
| > | > | > | > > <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do
| > | > | > | > > not
| > | > | > | > > Edit.
| > | > | > | > > FP_CharSet = "windows-1252"
| > | > | > | > > FP_CodePage = 1252 %>
| > | > | > | > > <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | > | > | > > <title>Testing2.asp</title>
| > | > | > | > > </head>
| > | > | > | > >
| > | > | > | > > <body>
| > | > | > | > >
| > | > | > | > > <table width="100%" border="1">
| > | > | > | > > <thead>
| > | > | > | > > <tr>
| > | > | > | > > <th ALIGN="LEFT">ID</th>
| > | > | > | > > <th ALIGN="LEFT">Category</th>
| > | > | > | > > <th ALIGN="LEFT">Sub Category</th>
| > | > | > | > > <th ALIGN="LEFT">Make</th>
| > | > | > | > > <th ALIGN="LEFT">Make and brief description</th>
| > | > | > | > > <th ALIGN="LEFT">Description</th>
| > | > | > | > > <th ALIGN="LEFT">Price</th>
| > | > | > | > > <th ALIGN="LEFT">Savings (where applicable)</th>
| > | > | > | > > <th ALIGN="LEFT">Small Image</th>
| > | > | > | > > <th ALIGN="LEFT">Medium Image</th>
| > | > | > | > > <th ALIGN="LEFT">DeepLink</th>
| > | > | > | > > </tr>
| > | > | > | > > </thead>
| > | > | > | > > <tbody>
| > | > | > | > > 
| > | > | > | > > <% if 0 then %>
| > | > | > | > > <SCRIPT Language="JavaScript">
| > | > | > | > > document.write("<div style='background: yellow; color: black;'>The
| > | > | > | > > Database
| > | > | > | > > Results component on this page is unable to display database content. The
| > | > | > | > > page must have a filename ending in '.asp', and the web must be hosted on
| > | > | > | > > a
| > | > | > | > > server that supports Active Server Pages.</div>");
| > | > | > | > > </SCRIPT>
| > | > | > | > > <% end if %>
| > | > | > | > > <%
| > | > | > | > > fp_sQry="SELECT * FROM Products"
| > | > | > | > > fp_sDefault=""
| > | > | > | > > fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records
| > | > | > | > > returned.</td></tr>"
| > | > | > | > > fp_sDataConn="Sample"
| > | > | > | > > fp_iMaxRecords=25
| > | > | > | > > fp_iCommandType=1
| > | > | > | > > fp_iPageSize=5
| > | > | > | > > fp_fTableFormat=True
| > | > | > | > > fp_fMenuFormat=False
| > | > | > | > > fp_sMenuChoice="ID"
| > | > | > | > > fp_sMenuValue="ID"
| > | > | > | > > fp_sColTypes="&ID=3&Category=202&Sub Category=202&Make=202&Make and brief
| > | > | > | > > description=202&Description=202&Price=5&Savings (where
| > | > | > | > > applicable)=202&Small
| > | > | > | > > Image=203&Medium Image=203&DeepLink=203&"
| > | > | > | > > fp_iDisplayCols=11
| > | > | > | > > fp_fCustomQuery=False
| > | > | > | > > BOTID=0
| > | > | > | > > fp_iRegion=BOTID
| > | > | > | > > %>
| > | > | > | > > 
| > | > | > | > > <tr>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"ID")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Category")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Sub
| > | > | > | > > Category")%></td>
| > | > | > | > > <td>
| > | > | > | > > <%=FP_FieldVal(fp_rs,"Make")%></td>
| > | > | > | > > <td>

Click to expand...

Hyperlink fails to open on the first click	0	May 13, 2022
Show not working after slide with hyperlink. PPT2011 for Mac	0	Sep 16, 2017
Mass-remove hyperlinks from Publisher Document (VBA macro)	0	Dec 23, 2017
Copy hyperlinks	6	May 5, 2013
Trying to create a report that will list unmatched records by Ticket Primary Key	0	Mar 11, 2022
Hyperlink location	1	Sep 11, 2009
Access 2010 Disable Microsoft Access Security Notic	3	Aug 10, 2013
Hyperlinks to ASP Pages	5	May 10, 2009

Hyperlinks from Database Results

Graham

Stefan B Rusynko

Graham

Graham

Stefan B Rusynko

Graham

Stefan B Rusynko

Graham

Thomas A. Rowe

Ask a Question

Similar Threads