Kathleen Anderson said:
Graham said:Kathleen,
Thankyou for the help. Almost there but instead of the image, I get a
brken
image. Please see http://www.hobbies4you.co.uk/Testing2.asp
The small images field has the same type of links as the medium image
field.
Can you suggest what I need to change.
--
Many thanks
Graham
Jim Buyens said:Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
Graham said:My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Stefan B Rusynko said:See http://support.microsoft.com/default.aspx?scid=kb;en-us;299320
--
_____________________________________________
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 tried to add the field,as fllows
|
| SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
|
| but could not progress as the wizard said there was a connection schema
| problem.
|
| Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
|
| how do include this in the DRW results?
| --
| Many thanks
|
| Graham
|
|
| "Jim Buyens" wrote:
|
| > Somehow, you're ending up with image locations such as
| > http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
| > won't work.
| >
| > Generally, the best way to get the Database Results Wizard display images is
| > by using a custom query at page 2 of the wizard. Add a field such as the
| > following:
| >
| > SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
| >
| > where picfile is the name of the field that contains the picture file name.
| > Then, be sure to include the computed imgtag field in the DRW results.
| >
| > When the wizard finishes, right-click the <<imgtag>> field in Design view,
| > choose Database Column Value Properties, and select Column Value Contains
| > HTML. Then, Click OK, save the page, and test it.
| >
| > If you still get "missing picture" icons instead of pictures, right-click
| > one of the "missing picture" icons, choose Properties, and see what kind of
| > URL you're generating. Once you have that info, the correction is usually
| > fairly clear.
| >
| > Jim Buyens
| > Microsoft MVP
| > http://www.interlacken.com
| > Author of:
| > o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
| > Now!
| > o--> Microsoft Office FrontPage 2003 Inside Out
| > o--> Microsoft Windows SharePoint Services Inside Out
| > o--> Faster Smarter Beginning Programming
| >
| >
| > "Graham" wrote:
| >
| > > My database results page is bringing up a field which has a hyperlink in it.
| > > Rather than showing the hyperlink, I want it to show the jpeg at the
| > > destination of the link.
| > >
| > > Any ideas?
| > > --
| > > Many thanks
| > >
| > > Graham
Graham said:I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
Jim Buyens said:Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
Graham said:My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Jim Buyens said:No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database query to have
a computed field named imgtag, and for that tag to containg strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields box.
Alternatively, you can pursue one of the approaches others have suggested
for tricking FrontPage Design view into producing the same output. To me,
writing SQL code that assembles HTML strings is simpler, but this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
Graham said:I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
Jim Buyens said:Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Graham said:Still no joy. You asked if the picture files have names like whatever.jpg,
they do but they include the affiliate website address that holds the image
as well, such as
http://www.firebox.com/pic/p54h.gif
does this make a difference?
--
Many thanks
Graham
Jim Buyens said:No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database query to have
a computed field named imgtag, and for that tag to containg strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields box.
Alternatively, you can pursue one of the approaches others have suggested
for tricking FrontPage Design view into producing the same output. To me,
writing SQL code that assembles HTML strings is simpler, but this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
Graham said:I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
:
Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Thomas A. Rowe said:Then you need to store the full URL in the database for all images and then display the field
(image) on the page like so:
SELECT ImageField From tablename
Then:
<img src="<%=recordset("ImageField")%>">
==============================================
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:Still no joy. You asked if the picture files have names like whatever.jpg,
they do but they include the affiliate website address that holds the image
as well, such as
http://www.firebox.com/pic/p54h.gif
does this make a difference?
--
Many thanks
Graham
Jim Buyens said:No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database query to have
a computed field named imgtag, and for that tag to containg strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields box.
Alternatively, you can pursue one of the approaches others have suggested
for tricking FrontPage Design view into producing the same output. To me,
writing SQL code that assembles HTML strings is simpler, but this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
:
Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Graham said:Thomas,
The databases have the full URL. This is what I input in the code:
SELECT Medium_Image FROM Products '<img src="<%=recordset("Medium_Image")%>">'
I had to add the ' before img src and at the end, the query would not verify
otherwise, but I get the following error.
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Testing3.asp, line 29
fp_sQry="SELECT Medium_Image FROM Products '<img
src=""<%=recordset(""Medium_Image"")
Appreciate your/anyones help.
--
Many thanks
Graham
Thomas A. Rowe said:Then you need to store the full URL in the database for all images and then display the field
(image) on the page like so:
SELECT ImageField From tablename
Then:
<img src="<%=recordset("ImageField")%>">
==============================================
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:Still no joy. You asked if the picture files have names like whatever.jpg,
they do but they include the affiliate website address that holds the image
as well, such as
http://www.firebox.com/pic/p54h.gif
does this make a difference?
--
Many thanks
Graham
:
No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database query to have
a computed field named imgtag, and for that tag to containg strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields box.
Alternatively, you can pursue one of the approaches others have suggested
for tricking FrontPage Design view into producing the same output. To me,
writing SQL code that assembles HTML strings is simpler, but this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
:
Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Thomas A. Rowe said:I would never place it in the actual SQL query, so try my example:
SELECT Medium_Image From Products Where Product ID = '" & Request.Form("ProductID") & "' "
Then display on page like so
<img src="<%=recordset("Medium_Image")%>">
Replace the word recordset with the name of your actual recordset.
==============================================
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:Thomas,
The databases have the full URL. This is what I input in the code:
SELECT Medium_Image FROM Products '<img src="<%=recordset("Medium_Image")%>">'
I had to add the ' before img src and at the end, the query would not verify
otherwise, but I get the following error.
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Testing3.asp, line 29
fp_sQry="SELECT Medium_Image FROM Products '<img
src=""<%=recordset(""Medium_Image"")
Appreciate your/anyones help.
--
Many thanks
Graham
Thomas A. Rowe said:Then you need to store the full URL in the database for all images and then display the field
(image) on the page like so:
SELECT ImageField From tablename
Then:
<img src="<%=recordset("ImageField")%>">
==============================================
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.
==============================================
Still no joy. You asked if the picture files have names like whatever.jpg,
they do but they include the affiliate website address that holds the image
as well, such as
http://www.firebox.com/pic/p54h.gif
does this make a difference?
--
Many thanks
Graham
:
No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database query to have
a computed field named imgtag, and for that tag to containg strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields box.
Alternatively, you can pursue one of the approaches others have suggested
for tricking FrontPage Design view into producing the same output. To me,
writing SQL code that assembles HTML strings is simpler, but this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
:
Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Graham said: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")%>">
This is a bit of a steep learning curve, thanks for your patience.
--
Many thanks
Graham
Thomas A. Rowe said:I would never place it in the actual SQL query, so try my example:
SELECT Medium_Image From Products Where Product ID = '" & Request.Form("ProductID") & "' "
Then display on page like so
<img src="<%=recordset("Medium_Image")%>">
Replace the word recordset with the name of your actual recordset.
==============================================
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:Thomas,
The databases have the full URL. This is what I input in the code:
SELECT Medium_Image FROM Products '<img src="<%=recordset("Medium_Image")%>">'
I had to add the ' before img src and at the end, the query would not verify
otherwise, but I get the following error.
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Testing3.asp, line 29
fp_sQry="SELECT Medium_Image FROM Products '<img
src=""<%=recordset(""Medium_Image"")
Appreciate your/anyones help.
--
Many thanks
Graham
:
Then you need to store the full URL in the database for all images and then display the field
(image) on the page like so:
SELECT ImageField From tablename
Then:
<img src="<%=recordset("ImageField")%>">
==============================================
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.
==============================================
Still no joy. You asked if the picture files have names like whatever.jpg,
they do but they include the affiliate website address that holds the image
as well, such as
http://www.firebox.com/pic/p54h.gif
does this make a difference?
--
Many thanks
Graham
:
No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database query to have
a computed field named imgtag, and for that tag to containg strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields box.
Alternatively, you can pursue one of the approaches others have suggested
for tricking FrontPage Design view into producing the same output. To me,
writing SQL code that assembles HTML strings is simpler, but this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
:
Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Thomas A. Rowe said: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.
==============================================
Graham said: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")%>">
This is a bit of a steep learning curve, thanks for your patience.
--
Many thanks
Graham
Thomas A. Rowe said:I would never place it in the actual SQL query, so try my example:
SELECT Medium_Image From Products Where Product ID = '" & Request.Form("ProductID") & "' "
Then display on page like so
<img src="<%=recordset("Medium_Image")%>">
Replace the word recordset with the name of your actual recordset.
==============================================
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,
The databases have the full URL. This is what I input in the code:
SELECT Medium_Image FROM Products '<img src="<%=recordset("Medium_Image")%>">'
I had to add the ' before img src and at the end, the query would not verify
otherwise, but I get the following error.
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Testing3.asp, line 29
fp_sQry="SELECT Medium_Image FROM Products '<img
src=""<%=recordset(""Medium_Image"")
Appreciate your/anyones help.
--
Many thanks
Graham
:
Then you need to store the full URL in the database for all images and then display the field
(image) on the page like so:
SELECT ImageField From tablename
Then:
<img src="<%=recordset("ImageField")%>">
==============================================
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.
==============================================
Still no joy. You asked if the picture files have names like whatever.jpg,
they do but they include the affiliate website address that holds the image
as well, such as
http://www.firebox.com/pic/p54h.gif
does this make a difference?
--
Many thanks
Graham
:
No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database query to have
a computed field named imgtag, and for that tag to containg strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields box.
Alternatively, you can pursue one of the approaches others have suggested
for tricking FrontPage Design view into producing the same output. To me,
writing SQL code that assembles HTML strings is simpler, but this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
I tried to add the field,as fllows
but could not progress as the wizard said there was a connection schema
problem.
Also, the computed imgtag is '<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
:
Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg' and those
won't work.
Generally, the best way to get the Database Results Wizard display images is
by using a custom query at page 2 of the wizard. Add a field such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the picture file name.
Then, be sure to include the computed imgtag field in the DRW results.
When the wizard finishes, right-click the <<imgtag>> field in Design view,
choose Database Column Value Properties, and select Column Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of pictures, right-click
one of the "missing picture" icons, choose Properties, and see what kind of
URL you're generating. Once you have that info, the correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has a hyperlink in it.
Rather than showing the hyperlink, I want it to show the jpeg at the
destination of the link.
Any ideas?
Graham said:<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 said: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.
==============================================
Graham said: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")%>">
This is a bit of a steep learning curve, thanks for your patience.
--
Many thanks
Graham
:
I would never place it in the actual SQL query, so try my example:
SELECT Medium_Image From Products Where Product ID = '" &
Request.Form("ProductID") & "' "
Then display on page like so
<img src="<%=recordset("Medium_Image")%>">
Replace the word recordset with the name of your actual recordset.
==============================================
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,
The databases have the full URL. This is what I input in the code:
SELECT Medium_Image FROM Products '<img
src="<%=recordset("Medium_Image")%>">'
I had to add the ' before img src and at the end, the query would
not verify
otherwise, but I get the following error.
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Testing3.asp, line 29
fp_sQry="SELECT Medium_Image FROM Products '<img
src=""<%=recordset(""Medium_Image"")
Appreciate your/anyones help.
--
Many thanks
Graham
:
Then you need to store the full URL in the database for all images
and then display the field
(image) on the page like so:
SELECT ImageField From tablename
Then:
<img src="<%=recordset("ImageField")%>">
==============================================
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.
==============================================
Still no joy. You asked if the picture files have names like
whatever.jpg,
they do but they include the affiliate website address that holds
the image
as well, such as
http://www.firebox.com/pic/p54h.gif
does this make a difference?
--
Many thanks
Graham
:
No, not
SELECT'<img_src="/pic/'_&_[small_image]'">'as_imgtag
but
SELECT '<img src="/pic/' & [small_image] & '">' as imgtag
The objective is for each record coming back from the database
query to have
a computed field named imgtag, and for that tag to containg
strings like:
<img src="/pic/whatever.jpg">
Presumably, your small_image field contains picture file names
like
whatever.jpg.
If these are thumbnails, BTW, you probably want HTML like:
<a href="/pic/whatever_lg.pjg" target="blank"><img border=0
src="/pic/whatever.jpg"></a>
to display the full-sized pictures. If so, the computed field
would be:
'<a href="/pic/' & [large_image] & '" target="blank"><img
border=0
src="/pic/' & [small_image] & '"></a>' as imgtag
To get the computed imgtag field into your results, advance to
page 3 of the
wizard and make sure that imgtag appears in the Displayed Fields
box.
Alternatively, you can pursue one of the approaches others have
suggested
for tricking FrontPage Design view into producing the same
output. To me,
writing SQL code that assembles HTML strings is simpler, but
this is strictly
a matter of preference.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition: Build
a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
I tried to add the field,as fllows
but could not progress as the wizard said there was a
connection schema
problem.
Also, the computed imgtag is
'<%=FP_Fieldlink(FP_RS,"small_Image")%>'
how do include this in the DRW results?
--
Many thanks
Graham
:
Somehow, you're ending up with image locations such as
http://www.hobbies4you.co.uk/'http://www.firebox.com/pic/p6h.jpg'
and those
won't work.
Generally, the best way to get the Database Results Wizard
display images is
by using a custom query at page 2 of the wizard. Add a field
such as the
following:
SELECT '<img src="/pic/' & [picfile] & '">' as imgtag, ...
where picfile is the name of the field that contains the
picture file name.
Then, be sure to include the computed imgtag field in the
DRW results.
When the wizard finishes, right-click the <<imgtag>> field
in Design view,
choose Database Column Value Properties, and select Column
Value Contains
HTML. Then, Click OK, save the page, and test it.
If you still get "missing picture" icons instead of
pictures, right-click
one of the "missing picture" icons, choose Properties, and
see what kind of
URL you're generating. Once you have that info, the
correction is usually
fairly clear.
Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
o--> Microsoft Visual Web Developer 2005 Express Edition:
Build a Web Site
Now!
o--> Microsoft Office FrontPage 2003 Inside Out
o--> Microsoft Windows SharePoint Services Inside Out
o--> Faster Smarter Beginning Programming
:
My database results page is bringing up a field which has
a hyperlink in it.
Rather than showing the hyperlink, I want it to show the
jpeg at the
destination of the link.
Any ideas?
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>
Kathleen Anderson said: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/
Graham said:<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 said: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")%>">
This is a bit of a steep learning curve, thanks for your patience.
--
Many thanks
Graham
:
I would never place it in the actual SQL query, so try my example:
SELECT Medium_Image From Products Where Product ID = '" &
Request.Form("ProductID") & "' "
Then display on page like so
<img src="<%=recordset("Medium_Image")%>">
Replace the word recordset with the name of your actual recordset.
==============================================
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,
The databases have the full URL. This is what I input in the code:
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.