Hyperlinks from Database Results

S

Stefan B Rusynko

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:
| > |
| > | <!--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="Small Image"
| > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > size="-1">>></font>" startspan
| > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > bot="DatabaseResultColumn"
| > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > > </tr>
| > | > > </thead>
| > | > > <tbody>
| > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > > b-tableexpand="TRUE"
| > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > > description,Description,Price,Savings (where applicable),Small
| > | > > Image,Medium
| > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > > a
| > | > > Database Results region. The page must be fetched from a web server with a
| > | > > web browser to display correctly; the current web is stored on your local
| > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > > CurrentExt
| > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > > sa-CritTypes
| > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > > <% 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
| > | > > %>
| > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > > <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="ID"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan
| > | > > i-checksum="62813" --></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="Category"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > > i-checksum="33919"
| > | > > --></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="Make"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="3834" --></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="Make and brief
| > | > > description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Make and
| > | > > brief description<font size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Make and brief description")%><!--webbot
| > | > > bot="DatabaseResultColumn" endspan i-checksum="10957" --></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="Description"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Description<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
| > | > > bot="DatabaseResultColumn"
| > | > > endspan i-checksum="30092" --></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="Price"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Price<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="9640" --></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
| > | > > applicable)" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Savings
| > | > > (where applicable)<font size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Savings (where applicable)")%><!--webbot
| > | > > bot="DatabaseResultColumn" endspan i-checksum="3257" --></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="Small Image"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > > size="-1">>></font>" startspan
| > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > > bot="DatabaseResultColumn"
| > | > > endspan i-checksum="29075" --></td>
| > | > > <td>
| > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></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="DeepLink"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="TRUE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font><a
| > | > > href=".">DeepLink</a><font size="-1">>></font>" startspan
| > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203" --><%="<a href="""
| > | > > &
| > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > > "</a>"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21915"
| > | > > --></td>
| > | > > </tr>
| > | > > <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| > | > > b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5"
| > | > > clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
| > | > > width="100%"><font color="#000000">This is the end of a Database Results
| > | > > region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
| > | > > TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
| > | > > TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
| > | > > [1/5]</NOBR><BR></td></tr>" startspan --><!--#include
| > | > > file="_fpclass/fpdbrgn2.inc"-->
| > | > > <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></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")%>">
 
G

Guest

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:
| > |
| > | <!--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="Small Image"
| > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > size="-1">>></font>" startspan
| > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > bot="DatabaseResultColumn"
| > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > > </tr>
| > | > > </thead>
| > | > > <tbody>
| > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > > b-tableexpand="TRUE"
| > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > > description,Description,Price,Savings (where applicable),Small
| > | > > Image,Medium
| > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > > a
| > | > > Database Results region. The page must be fetched from a web server with a
| > | > > web browser to display correctly; the current web is stored on your local
| > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > > CurrentExt
| > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > > sa-CritTypes
| > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > > <% 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
| > | > > %>
| > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > > <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="ID"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan
| > | > > i-checksum="62813" --></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="Category"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > > i-checksum="33919"
| > | > > --></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="Make"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="3834" --></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="Make and brief
| > | > > description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Make and
| > | > > brief description<font size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Make and brief description")%><!--webbot
| > | > > bot="DatabaseResultColumn" endspan i-checksum="10957" --></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="Description"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Description<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
| > | > > bot="DatabaseResultColumn"
| > | > > endspan i-checksum="30092" --></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="Price"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Price<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="9640" --></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
| > | > > applicable)" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Savings
| > | > > (where applicable)<font size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Savings (where applicable)")%><!--webbot
| > | > > bot="DatabaseResultColumn" endspan i-checksum="3257" --></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="Small Image"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > > size="-1">>></font>" startspan
| > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > > bot="DatabaseResultColumn"
| > | > > endspan i-checksum="29075" --></td>
| > | > > <td>
| > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></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="DeepLink"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="TRUE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font><a
| > | > > href=".">DeepLink</a><font size="-1">>></font>" startspan
| > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203" --><%="<a href="""
| > | > > &
| > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > > "</a>"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21915"
| > | > > --></td>
| > | > > </tr>
| > | > > <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| > | > > b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5"
| > | > > clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
| > | > > width="100%"><font color="#000000">This is the end of a Database Results
| > | > > region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
| > | > > TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
| > | > > TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
| > | > > [1/5]</NOBR><BR></td></tr>" startspan --><!--#include
| > | > > file="_fpclass/fpdbrgn2.inc"-->
| > | > > <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
Click to expand...
 
G

Guest

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:
| > |
| > | <!--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="Small Image"
| > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > size="-1">>></font>" startspan
| > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > bot="DatabaseResultColumn"
| > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > > </tr>
| > | > > </thead>
| > | > > <tbody>
| > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > > b-tableexpand="TRUE"
| > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > > description,Description,Price,Savings (where applicable),Small
| > | > > Image,Medium
| > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > > a
| > | > > Database Results region. The page must be fetched from a web server with a
| > | > > web browser to display correctly; the current web is stored on your local
| > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > > CurrentExt
| > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > > sa-CritTypes
| > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > > <% 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
| > | > > %>
| > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > > <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="ID"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan
| > | > > i-checksum="62813" --></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="Category"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > > i-checksum="33919"
| > | > > --></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="Make"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="3834" --></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="Make and brief
| > | > > description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Make and
| > | > > brief description<font size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Make and brief description")%><!--webbot
| > | > > bot="DatabaseResultColumn" endspan i-checksum="10957" --></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="Description"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Description<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
| > | > > bot="DatabaseResultColumn"
| > | > > endspan i-checksum="30092" --></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="Price"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Price<font
| > | > > size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
| > | > > endspan i-checksum="9640" --></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
| > | > > applicable)" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Savings
| > | > > (where applicable)<font size="-1">>></font>" startspan
| > | > > --><%=FP_FieldVal(fp_rs,"Savings (where applicable)")%><!--webbot
| > | > > bot="DatabaseResultColumn" endspan i-checksum="3257" --></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="Small Image"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > > size="-1">>></font>" startspan
| > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > > bot="DatabaseResultColumn"
| > | > > endspan i-checksum="29075" --></td>
| > | > > <td>
| > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></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="DeepLink"
| > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="TRUE" clientside
| > | > > b-MenuFormat preview="<font size="-1"><<</font><a
| > | > > href=".">DeepLink</a><font size="-1">>></font>" startspan
| > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203" --><%="<a href="""
| > | > > &
| > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > > "</a>"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21915"
| > | > > --></td>
| > | > > </tr>
| > | > > <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| > | > > b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5"
| > | > > clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
| > | > > width="100%"><font color="#000000">This is the end of a Database Results
| > | > > region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
| > | > > TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
| > | > > TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
| > | > > [1/5]</NOBR><BR></td></tr>" startspan --><!--#include
| > | > > file="_fpclass/fpdbrgn2.inc"-->
| > | > > <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
Click to expand...
 
S

Stefan B Rusynko

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:
| > | > |
| > | > | <!--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="Small Image"
| > | > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > | > size="-1">>></font>" startspan
| > | > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > | > bot="DatabaseResultColumn"
| > | > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > | > > </tr>
| > | > | > > </thead>
| > | > | > > <tbody>
| > | > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > | > > b-tableexpand="TRUE"
| > | > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > | > > description,Description,Price,Savings (where applicable),Small
| > | > | > > Image,Medium
| > | > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > | > > a
| > | > | > > Database Results region. The page must be fetched from a web server with a
| > | > | > > web browser to display correctly; the current web is stored on your local
| > | > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > | > > CurrentExt
| > | > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > | > > sa-CritTypes
| > | > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > | > > <% 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
| > | > | > > %>
| > | > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > | > > <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="ID"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan
| > | > | > > i-checksum="62813" --></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="Category"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > | > > i-checksum="33919"
| > | > | > > --></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="Make"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="3834" --></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="Make and brief
| > | > | > > description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Make and
| > | > | > > brief description<font size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Make and brief description")%><!--webbot
| > | > | > > bot="DatabaseResultColumn" endspan i-checksum="10957" --></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="Description"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Description<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
| > | > | > > bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="30092" --></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="Price"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Price<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="9640" --></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
| > | > | > > applicable)" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Savings
| > | > | > > (where applicable)<font size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Savings (where applicable)")%><!--webbot
| > | > | > > bot="DatabaseResultColumn" endspan i-checksum="3257" --></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="Small Image"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > | > > bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="29075" --></td>
| > | > | > > <td>
| > | > | > > <img border="0" img_src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></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="DeepLink"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="TRUE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font><a
| > | > | > > href=".">DeepLink</a><font size="-1">>></font>" startspan
| > | > | > > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203" --><%="<a href="""
| > | > | > > &
| > | > | > > FP_FieldLink(fp_rs,"DeepLink") & """>" & FP_FieldVal(fp_rs,"DeepLink") &
| > | > | > > "</a>"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21915"
| > | > | > > --></td>
| > | > | > > </tr>
| > | > | > > <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| > | > | > > b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5"
| > | > | > > clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
| > | > | > > width="100%"><font color="#000000">This is the end of a Database Results
| > | > | > > region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
| > | > | > > TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
| > | > | > > TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
| > | > | > > [1/5]</NOBR><BR></td></tr>" startspan --><!--#include
| > | > | > > file="_fpclass/fpdbrgn2.inc"-->
| > | > | > > <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
 
G

Guest

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:
| > | > |
| > | > | <!--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="Small Image"
| > | > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > | > size="-1">>></font>" startspan
| > | > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > | > bot="DatabaseResultColumn"
| > | > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > | > > </tr>
| > | > | > > </thead>
| > | > | > > <tbody>
| > | > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > | > > b-tableexpand="TRUE"
| > | > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > | > > description,Description,Price,Savings (where applicable),Small
| > | > | > > Image,Medium
| > | > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > | > > a
| > | > | > > Database Results region. The page must be fetched from a web server with a
| > | > | > > web browser to display correctly; the current web is stored on your local
| > | > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > | > > CurrentExt
| > | > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > | > > sa-CritTypes
| > | > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > | > > <% 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
| > | > | > > %>
| > | > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > | > > <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="ID"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan
| > | > | > > i-checksum="62813" --></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="Category"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > | > > i-checksum="33919"
| > | > | > > --></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="Make"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="3834" --></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="Make and brief
| > | > | > > description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Make and
| > | > | > > brief description<font size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Make and brief description")%><!--webbot
| > | > | > > bot="DatabaseResultColumn" endspan i-checksum="10957" --></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="Description"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Description<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
| > | > | > > bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="30092" --></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="Price"
| > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Price<font
| > | > | > > size="-1">>></font>" startspan
| > | > | > > --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
| > | > | > > endspan i-checksum="9640" --></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
Click to expand...
 
S

Stefan B Rusynko

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:
| > | > | > |
| > | > | > | <!--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="Small Image"
| > | > | > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > | > | > size="-1">>></font>" startspan
| > | > | > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > | > | > bot="DatabaseResultColumn"
| > | > | > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > | > | > > </tr>
| > | > | > | > > </thead>
| > | > | > | > > <tbody>
| > | > | > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > | > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > | > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > | > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > | > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > | > | > > b-tableexpand="TRUE"
| > | > | > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > | > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > | > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > | > | > > description,Description,Price,Savings (where applicable),Small
| > | > | > | > > Image,Medium
| > | > | > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > | > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > | > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > | > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > | > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > | > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > | > | > > a
| > | > | > | > > Database Results region. The page must be fetched from a web server with a
| > | > | > | > > web browser to display correctly; the current web is stored on your local
| > | > | > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > | > | > > CurrentExt
| > | > | > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > | > | > > sa-CritTypes
| > | > | > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > | > | > > <% 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
| > | > | > | > > %>
| > | > | > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > | > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > | > | > > <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="ID"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan
| > | > | > | > > i-checksum="62813" --></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="Category"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > | > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > | > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > | > | > > i-checksum="33919"
| > | > | > | > > --></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="Make"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="3834" --></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="Make and brief
| > | > | > | > > description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| > | > | > | > > clientside b-MenuFormat preview="<font size="-1"><<</font>Make and
| > | > | > | > > brief description<font size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Make and brief description")%><!--webbot
| > | > | > | > > bot="DatabaseResultColumn" endspan i-checksum="10957" --></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="Description"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Description<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
| > | > | > | > > bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="30092" --></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="Price"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Price<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="9640" --></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
 
G

Guest

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:
| > | > | > |
| > | > | > | <!--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="Small Image"
| > | > | > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > | > | > size="-1">>></font>" startspan
| > | > | > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > | > | > bot="DatabaseResultColumn"
| > | > | > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > | > | > > </tr>
| > | > | > | > > </thead>
| > | > | > | > > <tbody>
| > | > | > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > | > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > | > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > | > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > | > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > | > | > > b-tableexpand="TRUE"
| > | > | > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > | > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > | > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > | > | > > description,Description,Price,Savings (where applicable),Small
| > | > | > | > > Image,Medium
| > | > | > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > | > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > | > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > | > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > | > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > | > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > | > | > > a
| > | > | > | > > Database Results region. The page must be fetched from a web server with a
| > | > | > | > > web browser to display correctly; the current web is stored on your local
| > | > | > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > | > | > > CurrentExt
| > | > | > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > | > | > > sa-CritTypes
| > | > | > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > | > | > > <% 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
| > | > | > | > > %>
| > | > | > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > | > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > | > | > > <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="ID"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan
| > | > | > | > > i-checksum="62813" --></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="Category"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > | > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > | > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > | > | > > i-checksum="33919"
| > | > | > | > > --></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="Make"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="3834" --></td>
| > | > | > | > > <td>
Click to expand...
 
T

Thomas A. Rowe

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:
| > | > | > |
| > | > | > | <!--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="Small Image"
| > | > | > | > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > b-MenuFormat preview="<font size="-1"><<</font>Small Image<font
| > | > | > | > size="-1">>></font>" startspan
| > | > | > | > s-ColumnTypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > | > --><%=FP_FieldVal(fp_rs,"Small Image")%><!--webbot
| > | > | > | > bot="DatabaseResultColumn"
| > | > | > | > endspan i-checksum="29075" --></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"><b>ID</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Category</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Sub Category</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Make</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Make and brief description</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Description</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Price</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Savings (where applicable)</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Small Image</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>Medium Image</b></th>
| > | > | > | > > <th ALIGN="LEFT"><b>DeepLink</b></th>
| > | > | > | > > </tr>
| > | > | > | > > </thead>
| > | > | > | > > <tbody>
| > | > | > | > > <!--webbot bot="DatabaseRegionStart" s-columnnames="ID,Category,Sub
| > | > | > | > > Category,Make,Make and brief description,Description,Price,Savings (where
| > | > | > | > > applicable),Small Image,Medium Image,DeepLink"
| > | > | > | > > s-columntypes="3,202,202,202,202,202,5,202,203,203,203"
| > | > | > | > > s-dataconnection="Sample" b-tableformat="TRUE" b-menuformat="FALSE"
| > | > | > | > > s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE"
| > | > | > | > > b-tableexpand="TRUE"
| > | > | > | > > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | > | > | > > i-listformat="0" b-makeform="FALSE" s-recordsource="Products"
| > | > | > | > > s-displaycolumns="ID,Category,Sub Category,Make,Make and brief
| > | > | > | > > description,Description,Price,Savings (where applicable),Small
| > | > | > | > > Image,Medium
| > | > | > | > > Image,DeepLink" s-criteria s-order s-sql="SELECT * FROM Products"
| > | > | > | > > b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields
| > | > | > | > > s-norecordsfound="No records returned." i-maxrecords="25" i-groupsize="5"
| > | > | > | > > botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| > | > | > | > > u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64
| > | > | > | > > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of
| > | > | > | > > a
| > | > | > | > > Database Results region. The page must be fetched from a web server with a
| > | > | > | > > web browser to display correctly; the current web is stored on your local
| > | > | > | > > disk or network.</font></td></tr>" startspan b-UseDotNET="FALSE"
| > | > | > | > > CurrentExt
| > | > | > | > > sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE"
| > | > | > | > > sa-CritTypes
| > | > | > | > > b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
| > | > | > | > > <% 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
| > | > | > | > > %>
| > | > | > | > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
| > | > | > | > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="58666" --><tr>
| > | > | > | > > <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="ID"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>ID<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan
| > | > | > | > > i-checksum="62813" --></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="Category"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Category<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Category")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="14744" --></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="Sub Category"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Sub Category<font
| > | > | > | > > size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Sub
| > | > | > | > > Category")%><!--webbot bot="DatabaseResultColumn" endspan
| > | > | > | > > i-checksum="33919"
| > | > | > | > > --></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="Make"
| > | > | > | > > b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| > | > | > | > > b-MenuFormat preview="<font size="-1"><<</font>Make<font
| > | > | > | > > size="-1">>></font>" startspan
| > | > | > | > > --><%=FP_FieldVal(fp_rs,"Make")%><!--webbot bot="DatabaseResultColumn"
| > | > | > | > > endspan i-checksum="3834" --></td>
| > | > | > | > > <td>
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks to ASP Pages 5
Hyperlinks in Access Database Results Displayed in my *.asp webpag 1
Database + Hyperlinks 2
Database Results with hyperlink fields 2
Front Page and Database Results Regions 2
Will not auto open .jpg 1
Copy hyperlinks 6
Open specific hyperlink (accept) automatically in email with outlook 0

Top