DB Image Queries

N

NEvans8993

I currently have a Product Info page in ASP, usign DRW to display info when a
specific thumbnail is clicked upon in another page.

I also would like to be able to display the full size picture in the DRW
Page, information of which is stored in the 'Full_Image' column of my Access
DB, e.g. of a value = 'images/Moorcroft/MC0001.jpg'.

I need to be able to pull in the image based upon an existing parameter
within my web site (currently used to query the db to display the text as
mentioned in 1st sentence). I need something like below:

Select Full_Image from Moorcroft
where Dev_Code (Access DB field) =::Dev_Code:: (hard coded parameter set in
the original thumbnail hyperlink). Unfortunately this is not working.

Could i possibly request some urgent guidance.

Many thanks
 
T

Thomas A. Rowe

Just add a field to your database with the name of the image file, then on your page you create a
link to the image field and code it to insert the image file name from the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
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.
==============================================
 
N

NEvans8993

Thanks for this. As shown in my 1st posting, i already have the image field
set up in the access db, so firstly how would you go about setting up the
link to the field in the DB ,and secondly i would need it to be pulled when
another db field is equal to the value that was originally supplied to obtain
a specific DRW record set.

Hope this makes sense!
 
T

Thomas A. Rowe

<img src="imagefolder/<%=fp_rs("imagefieldname")%>"

Another option is to make sure all images are named using the product ID

Then you would:

<img src="imagefolder/<%=fp_rs("productID")%>"
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
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.
==============================================
 
N

NEvans8993

Luckily my images are already named the same as the Dev_Code (primary key) in
my DB. So do i simply create a new layer and then go into the code and place
the following:

<img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>"

???

Then hopefully whenever i link the hyperlink to go to this page with the
Dev_Code parameter set within it, it should display each individual picture
for that Dev_Code????
 
T

Thomas A. Rowe

Yes, that should work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
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.
==============================================
 
R

Ronx

You will need to change that slightly to:
<img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg"
and add height, width, and alt attributes to suit.
(assumes image is a .jpg)
 
N

NEvans8993

Hi there,

Thanks for this. When i place the below code within my 'layer2' <div> </div>
tags it makes the rest of the coding below this area turn red. Am i missing
some relevant markers/tags? Please see code below:

<div style="position: absolute; width: 556px; height: 538px; z-index: 1;
left: -600px; top: 1px; border-style: double; border-width: 3px;
padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px"
id="layer2">

<img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg"
</div>
 
S

Stefan B Rusynko

You will always get a red x in design view for image source using a DB link
- preview in browser

PS
In your DIV tag your left: -600px; may cause you problems since it is off the screen
- unless that div is in another absolute div at least 600 px from left of page




| Hi there,
|
| Thanks for this. When i place the below code within my 'layer2' <div> </div>
| tags it makes the rest of the coding below this area turn red. Am i missing
| some relevant markers/tags? Please see code below:
|
| <div style="position: absolute; width: 556px; height: 538px; z-index: 1;
| left: -600px; top: 1px; border-style: double; border-width: 3px;
| padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px"
| id="layer2">
|
| <img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg"
| </div>
|
| "Ronx" wrote:
|
| > You will need to change that slightly to:
| > <img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg"
| > and add height, width, and alt attributes to suit.
| > (assumes image is a .jpg)
| > --
| > Ron Symonds
| > Microsoft MVP (FrontPage)
| > Reply only to group - emails will be deleted unread.
| >
| > | > > Luckily my images are already named the same as the Dev_Code
| > > (primary key) in
| > > my DB. So do i simply create a new layer and then go into the code
| > > and place
| > > the following:
| > >
| > > <img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>"
| > >
| > > ???
| > >
| > > Then hopefully whenever i link the hyperlink to go to this page with
| > > the
| > > Dev_Code parameter set within it, it should display each individual
| > > picture
| > > for that Dev_Code????
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> <img src="imagefolder/<%=fp_rs("imagefieldname")%>"
| > >>
| > >> Another option is to make sure all images are named using the
| > >> product ID
| > >>
| > >> Then you would:
| > >>
| > >> <img src="imagefolder/<%=fp_rs("productID")%>"
| > >> --
| > >> ==============================================
| > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> WebMaster Resources(tm)
| > >>
| > >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > >> ==============================================
| > >> 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.
| > >> ==============================================
| > >>
| > >> message
| > >> | > >> > Thanks for this. As shown in my 1st posting, i already have the
| > >> > image field
| > >> > set up in the access db, so firstly how would you go about
| > >> > setting up the
| > >> > link to the field in the DB ,and secondly i would need it to be
| > >> > pulled when
| > >> > another db field is equal to the value that was originally
| > >> > supplied to obtain
| > >> > a specific DRW record set.
| > >> >
| > >> > Hope this makes sense!
| > >> >
| > >> > "Thomas A. Rowe" wrote:
| > >> >
| > >> >> Just add a field to your database with the name of the image
| > >> >> file, then on your page you create a
| > >> >> link to the image field and code it to insert the image file
| > >> >> name from the database.
| > >> >>
| > >> >> --
| > >> >> ==============================================
| > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> WebMaster Resources(tm)
| > >> >>
| > >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > >> >> ==============================================
| > >> >> 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.
| > >> >> ==============================================
| > >> >>
| > >> >> message
| > >> >> | > >> >> >I currently have a Product Info page in ASP, usign DRW to
| > >> >> >display info when a
| > >> >> > specific thumbnail is clicked upon in another page.
| > >> >> >
| > >> >> > I also would like to be able to display the full size picture
| > >> >> > in the DRW
| > >> >> > Page, information of which is stored in the 'Full_Image'
| > >> >> > column of my Access
| > >> >> > DB, e.g. of a value = 'images/Moorcroft/MC0001.jpg'.
| > >> >> >
| > >> >> > I need to be able to pull in the image based upon an existing
| > >> >> > parameter
| > >> >> > within my web site (currently used to query the db to display
| > >> >> > the text as
| > >> >> > mentioned in 1st sentence). I need something like below:
| > >> >> >
| > >> >> > Select Full_Image from Moorcroft
| > >> >> > where Dev_Code (Access DB field) =::Dev_Code:: (hard coded
| > >> >> > parameter set in
| > >> >> > the original thumbnail hyperlink). Unfortunately this is not
| > >> >> > working.
| > >> >> >
| > >> >> > Could i possibly request some urgent guidance.
| > >> >> >
| > >> >> > Many thanks
| > >> >> >
| > >> >> >
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >
 
N

NEvans8993

Hi there,

Sorry i don;t think i wrote my prob clearly. Its not that i am getting a red
x in design but that when i put that line of code in, every other bit of code
below that line turns red, probably becuase i am missing some vital markers
or tags.

Advise would be much appreciated.

Cheers
 
S

Stefan B Rusynko

You have a missing > at the end of your image tag
<img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg"
and it should be
<img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg">





| Hi there,
|
| Sorry i don;t think i wrote my prob clearly. Its not that i am getting a red
| x in design but that when i put that line of code in, every other bit of code
| below that line turns red, probably becuase i am missing some vital markers
| or tags.
|
| Advise would be much appreciated.
|
| Cheers
|
| "Stefan B Rusynko" wrote:
|
| > You will always get a red x in design view for image source using a DB link
| > - preview in browser
| >
| > PS
| > In your DIV tag your left: -600px; may cause you problems since it is off the screen
| > - unless that div is in another absolute div at least 600 px from left of 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.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | Hi there,
| > |
| > | Thanks for this. When i place the below code within my 'layer2' <div> </div>
| > | tags it makes the rest of the coding below this area turn red. Am i missing
| > | some relevant markers/tags? Please see code below:
| > |
| > | <div style="position: absolute; width: 556px; height: 538px; z-index: 1;
| > | left: -600px; top: 1px; border-style: double; border-width: 3px;
| > | padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px"
| > | id="layer2">
| > |
| > | <img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg"
| > | </div>
| > |
| > | "Ronx" wrote:
| > |
| > | > You will need to change that slightly to:
| > | > <img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>.jpg"
| > | > and add height, width, and alt attributes to suit.
| > | > (assumes image is a .jpg)
| > | > --
| > | > Ron Symonds
| > | > Microsoft MVP (FrontPage)
| > | > Reply only to group - emails will be deleted unread.
| > | >
| > | > | > | > > Luckily my images are already named the same as the Dev_Code
| > | > > (primary key) in
| > | > > my DB. So do i simply create a new layer and then go into the code
| > | > > and place
| > | > > the following:
| > | > >
| > | > > <img src="images/Moorcroft/<%=fp_rs("Dev_Code")%>"
| > | > >
| > | > > ???
| > | > >
| > | > > Then hopefully whenever i link the hyperlink to go to this page with
| > | > > the
| > | > > Dev_Code parameter set within it, it should display each individual
| > | > > picture
| > | > > for that Dev_Code????
| > | > >
| > | > > "Thomas A. Rowe" wrote:
| > | > >
| > | > >> <img src="imagefolder/<%=fp_rs("imagefieldname")%>"
| > | > >>
| > | > >> Another option is to make sure all images are named using the
| > | > >> product ID
| > | > >>
| > | > >> Then you would:
| > | > >>
| > | > >> <img src="imagefolder/<%=fp_rs("productID")%>"
| > | > >> --
| > | > >> ==============================================
| > | > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> WebMaster Resources(tm)
| > | > >>
| > | > >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> ==============================================
| > | > >> 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.
| > | > >> ==============================================
| > | > >>
| > | > >> message
| > | > >> | > | > >> > Thanks for this. As shown in my 1st posting, i already have the
| > | > >> > image field
| > | > >> > set up in the access db, so firstly how would you go about
| > | > >> > setting up the
| > | > >> > link to the field in the DB ,and secondly i would need it to be
| > | > >> > pulled when
| > | > >> > another db field is equal to the value that was originally
| > | > >> > supplied to obtain
| > | > >> > a specific DRW record set.
| > | > >> >
| > | > >> > Hope this makes sense!
| > | > >> >
| > | > >> > "Thomas A. Rowe" wrote:
| > | > >> >
| > | > >> >> Just add a field to your database with the name of the image
| > | > >> >> file, then on your page you create a
| > | > >> >> link to the image field and code it to insert the image file
| > | > >> >> name from the database.
| > | > >> >>
| > | > >> >> --
| > | > >> >> ==============================================
| > | > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> >> WebMaster Resources(tm)
| > | > >> >>
| > | > >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> >> ==============================================
| > | > >> >> 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.
| > | > >> >> ==============================================
| > | > >> >>
| > | > >> >> message
| > | > >> >> | > | > >> >> >I currently have a Product Info page in ASP, usign DRW to
| > | > >> >> >display info when a
| > | > >> >> > specific thumbnail is clicked upon in another page.
| > | > >> >> >
| > | > >> >> > I also would like to be able to display the full size picture
| > | > >> >> > in the DRW
| > | > >> >> > Page, information of which is stored in the 'Full_Image'
| > | > >> >> > column of my Access
| > | > >> >> > DB, e.g. of a value = 'images/Moorcroft/MC0001.jpg'.
| > | > >> >> >
| > | > >> >> > I need to be able to pull in the image based upon an existing
| > | > >> >> > parameter
| > | > >> >> > within my web site (currently used to query the db to display
| > | > >> >> > the text as
| > | > >> >> > mentioned in 1st sentence). I need something like below:
| > | > >> >> >
| > | > >> >> > Select Full_Image from Moorcroft
| > | > >> >> > where Dev_Code (Access DB field) =::Dev_Code:: (hard coded
| > | > >> >> > parameter set in
| > | > >> >> > the original thumbnail hyperlink). Unfortunately this is not
| > | > >> >> > working.
| > | > >> >> >
| > | > >> >> > Could i possibly request some urgent guidance.
| > | > >> >> >
| > | > >> >> > Many thanks
| > | > >> >> >
| > | > >> >> >
| > | > >> >>
| > | > >> >>
| > | > >> >>
| > | > >>
| > | > >>
| > | > >>
| > | >
| > | >
| > | >
| >
| >
| >
 

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