Hyperlinks from Database Results

G

Graham

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?
 
K

Kathleen Anderson [MVP - FrontPage]

I think you need to go into code view and remove the http:// from the
DatabaseColumnResults webbot.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


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
 
G

Graham

I have looked but the instructions for getting the image there said to delete
the DatabaseColumnResults webbot, so there is no http:// showing.

All I see for this cell is
<img border="0" src="'<%=FP_FieldLink(fp_rs,"Medium Image")%>'"></a></td>

Can you please assist.
--
Many thanks

Graham
 
J

Jim Buyens

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
 
G

Graham

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 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?
 
S

Stefan B Rusynko

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
 
G

Graham

Stefan,

Sorry, I have fallen at the first hurdle. Point one refers to 'In Microsoft
SQL server' where do I find this?
--
Many thanks

Graham


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
 
J

Jim Buyens

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


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?
 
G

Graham

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


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?
 
T

Thomas A. Rowe

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



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?
 
G

Graham

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


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?
 
T

Thomas A. Rowe

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

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?
 
G

Graham

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


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?
 
T

Thomas A. Rowe

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

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?
 
G

Graham

<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">&lt;&lt;</font>ID<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Category<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Sub Category<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Make<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Make and
brief description<font size="-1">&gt;&gt;</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">&lt;&lt;</font>Description<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Price<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Savings
(where applicable)<font size="-1">&gt;&gt;</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">&lt;&lt;</font>Small Image<font
size="-1">&gt;&gt;</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">&lt;&lt;</font><a
href=".">DeepLink</a><font size="-1">&gt;&gt;</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


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?
 
K

Kathleen Anderson [MVP - FrontPage]

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">&lt;&lt;</font>ID<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Category<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Sub Category<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Make<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Make and
brief description<font size="-1">&gt;&gt;</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">&lt;&lt;</font>Description<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Price<font
size="-1">&gt;&gt;</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">&lt;&lt;</font>Savings
(where applicable)<font size="-1">&gt;&gt;</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">&lt;&lt;</font>Small Image<font
size="-1">&gt;&gt;</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">&lt;&lt;</font><a
href=".">DeepLink</a><font size="-1">&gt;&gt;</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?
 
G

Graham

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 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:
 
S

Stefan B Rusynko

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")%>">
| > >> >
| > >> > This is a bit of a steep learning curve, thanks for your patience.
| > >> > --
| > >> > Many thanks
| > >> >
| > >> > Graham
| > >> >
| > >> >
| > >> > "Thomas A. Rowe" wrote:
| > >> >
| > >> >> 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:
| > >> >> >
 

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

Top