PC Review


Reply
Thread Tools Rate Thread

DB Image Queries

 
 
=?Utf-8?B?TkV2YW5zODk5Mw==?=
Guest
Posts: n/a
 
      8th Jun 2005
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) =:ev_Code:: (hard coded parameter set in
the original thumbnail hyperlink). Unfortunately this is not working.

Could i possibly request some urgent guidance.

Many thanks


 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      8th Jun 2005
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)
http://www.ycoln-resources.com
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.
==============================================

"NEvans8993" <(E-Mail Removed)> wrote in message
news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
>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) =:ev_Code:: (hard coded parameter set in
> the original thumbnail hyperlink). Unfortunately this is not working.
>
> Could i possibly request some urgent guidance.
>
> Many thanks
>
>



 
Reply With Quote
 
=?Utf-8?B?TkV2YW5zODk5Mw==?=
Guest
Posts: n/a
 
      8th Jun 2005
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)
> http://www.ycoln-resources.com
> 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.
> ==============================================
>
> "NEvans8993" <(E-Mail Removed)> wrote in message
> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
> >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) =:ev_Code:: (hard coded parameter set in
> > the original thumbnail hyperlink). Unfortunately this is not working.
> >
> > Could i possibly request some urgent guidance.
> >
> > Many thanks
> >
> >

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      8th Jun 2005
<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)
http://www.ycoln-resources.com
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.
==============================================

"NEvans8993" <(E-Mail Removed)> wrote in message
news:1EFAE708-500E-4D83-B375-(E-Mail Removed)...
> 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)
>> http://www.ycoln-resources.com
>> 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.
>> ==============================================
>>
>> "NEvans8993" <(E-Mail Removed)> wrote in message
>> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
>> >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) =:ev_Code:: (hard coded parameter set in
>> > the original thumbnail hyperlink). Unfortunately this is not working.
>> >
>> > Could i possibly request some urgent guidance.
>> >
>> > Many thanks
>> >
>> >

>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?TkV2YW5zODk5Mw==?=
Guest
Posts: n/a
 
      8th Jun 2005
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)
> http://www.ycoln-resources.com
> 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.
> ==============================================
>
> "NEvans8993" <(E-Mail Removed)> wrote in message
> news:1EFAE708-500E-4D83-B375-(E-Mail Removed)...
> > 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)
> >> http://www.ycoln-resources.com
> >> 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.
> >> ==============================================
> >>
> >> "NEvans8993" <(E-Mail Removed)> wrote in message
> >> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
> >> >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) =:ev_Code:: (hard coded parameter set in
> >> > the original thumbnail hyperlink). Unfortunately this is not working.
> >> >
> >> > Could i possibly request some urgent guidance.
> >> >
> >> > Many thanks
> >> >
> >> >
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      8th Jun 2005
Yes, that should work.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
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.
==============================================

"NEvans8993" <(E-Mail Removed)> wrote in message
news:3BC4D36F-882F-4B6C-9A8E-(E-Mail Removed)...
> 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)
>> http://www.ycoln-resources.com
>> 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.
>> ==============================================
>>
>> "NEvans8993" <(E-Mail Removed)> wrote in message
>> news:1EFAE708-500E-4D83-B375-(E-Mail Removed)...
>> > 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)
>> >> http://www.ycoln-resources.com
>> >> 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.
>> >> ==============================================
>> >>
>> >> "NEvans8993" <(E-Mail Removed)> wrote in message
>> >> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
>> >> >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) =:ev_Code:: (hard coded parameter set in
>> >> > the original thumbnail hyperlink). Unfortunately this is not working.
>> >> >
>> >> > Could i possibly request some urgent guidance.
>> >> >
>> >> > Many thanks
>> >> >
>> >> >
>> >>
>> >>
>> >>

>>
>>
>>



 
Reply With Quote
 
Ronx
Guest
Posts: n/a
 
      9th Jun 2005
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.

"NEvans8993" <(E-Mail Removed)> wrote in message
news:3BC4D36F-882F-4B6C-9A8E-(E-Mail Removed)...
> 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)
>> http://www.ycoln-resources.com
>> 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.
>> ==============================================
>>
>> "NEvans8993" <(E-Mail Removed)> wrote in
>> message
>> news:1EFAE708-500E-4D83-B375-(E-Mail Removed)...
>> > 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)
>> >> http://www.ycoln-resources.com
>> >> 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.
>> >> ==============================================
>> >>
>> >> "NEvans8993" <(E-Mail Removed)> wrote in
>> >> message
>> >> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
>> >> >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) =:ev_Code:: (hard coded
>> >> > parameter set in
>> >> > the original thumbnail hyperlink). Unfortunately this is not
>> >> > working.
>> >> >
>> >> > Could i possibly request some urgent guidance.
>> >> >
>> >> > Many thanks
>> >> >
>> >> >
>> >>
>> >>
>> >>

>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?TkV2YW5zODk5Mw==?=
Guest
Posts: n/a
 
      9th Jun 2005
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.
>
> "NEvans8993" <(E-Mail Removed)> wrote in message
> news:3BC4D36F-882F-4B6C-9A8E-(E-Mail Removed)...
> > 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)
> >> http://www.ycoln-resources.com
> >> 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.
> >> ==============================================
> >>
> >> "NEvans8993" <(E-Mail Removed)> wrote in
> >> message
> >> news:1EFAE708-500E-4D83-B375-(E-Mail Removed)...
> >> > 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)
> >> >> http://www.ycoln-resources.com
> >> >> 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.
> >> >> ==============================================
> >> >>
> >> >> "NEvans8993" <(E-Mail Removed)> wrote in
> >> >> message
> >> >> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
> >> >> >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) =:ev_Code:: (hard coded
> >> >> > parameter set in
> >> >> > the original thumbnail hyperlink). Unfortunately this is not
> >> >> > working.
> >> >> >
> >> >> > Could i possibly request some urgent guidance.
> >> >> >
> >> >> > Many thanks
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      9th Jun 2005
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
_____________________________________________


"NEvans8993" <(E-Mail Removed)> wrote in message news:21AB8716-03EC-4360-A98D-(E-Mail Removed)...
| 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.
| >
| > "NEvans8993" <(E-Mail Removed)> wrote in message
| > news:3BC4D36F-882F-4B6C-9A8E-(E-Mail Removed)...
| > > 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)
| > >> http://www.ycoln-resources.com
| > >> 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.
| > >> ==============================================
| > >>
| > >> "NEvans8993" <(E-Mail Removed)> wrote in
| > >> message
| > >> news:1EFAE708-500E-4D83-B375-(E-Mail Removed)...
| > >> > 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)
| > >> >> http://www.ycoln-resources.com
| > >> >> 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.
| > >> >> ==============================================
| > >> >>
| > >> >> "NEvans8993" <(E-Mail Removed)> wrote in
| > >> >> message
| > >> >> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
| > >> >> >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) =:ev_Code:: (hard coded
| > >> >> > parameter set in
| > >> >> > the original thumbnail hyperlink). Unfortunately this is not
| > >> >> > working.
| > >> >> >
| > >> >> > Could i possibly request some urgent guidance.
| > >> >> >
| > >> >> > Many thanks
| > >> >> >
| > >> >> >
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >


 
Reply With Quote
 
=?Utf-8?B?TkV2YW5zODk5Mw==?=
Guest
Posts: n/a
 
      9th Jun 2005
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
> _____________________________________________
>
>
> "NEvans8993" <(E-Mail Removed)> wrote in message news:21AB8716-03EC-4360-A98D-(E-Mail Removed)...
> | 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.
> | >
> | > "NEvans8993" <(E-Mail Removed)> wrote in message
> | > news:3BC4D36F-882F-4B6C-9A8E-(E-Mail Removed)...
> | > > 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)
> | > >> http://www.ycoln-resources.com
> | > >> 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.
> | > >> ==============================================
> | > >>
> | > >> "NEvans8993" <(E-Mail Removed)> wrote in
> | > >> message
> | > >> news:1EFAE708-500E-4D83-B375-(E-Mail Removed)...
> | > >> > 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)
> | > >> >> http://www.ycoln-resources.com
> | > >> >> 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.
> | > >> >> ==============================================
> | > >> >>
> | > >> >> "NEvans8993" <(E-Mail Removed)> wrote in
> | > >> >> message
> | > >> >> news:C7F017DC-A405-44AD-B2E8-(E-Mail Removed)...
> | > >> >> >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) =:ev_Code:: (hard coded
> | > >> >> > parameter set in
> | > >> >> > the original thumbnail hyperlink). Unfortunately this is not
> | > >> >> > working.
> | > >> >> >
> | > >> >> > Could i possibly request some urgent guidance.
> | > >> >> >
> | > >> >> > Many thanks
> | > >> >> >
> | > >> >> >
> | > >> >>
> | > >> >>
> | > >> >>
> | > >>
> | > >>
> | > >>
> | >
> | >
> | >
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any way to search image of my local drive with Image name or Image Title, Description infiraghu@gmail.com Microsoft Excel Programming 3 3rd Aug 2007 01:44 PM
Control image property locking image file even after image cleared steve Microsoft VB .NET 4 6th Jul 2006 02:57 AM
Queries using parameter queries, assigning values to for params in called query, is it possible? =?Utf-8?B?RnJhbmsgTS4=?= Microsoft Access Queries 1 13th Mar 2004 07:06 AM
Acronis True Image 7.0: Image verify, and bootable DVD image write? Matt Windows XP General 14 16th Jan 2004 03:08 AM
Acronis True Image 7.0: Image verify, and bootable DVD image write? Matt Storage Devices 12 16th Jan 2004 12:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:59 AM.