Here's my final solution for the query - a self-join.
SELECT TBIG.prodimagefilename AS FullSizeImageFilename,
TLITTLE.prodimagefilename AS
ThumbnailImageFilename
FROM tblimages_rel TBIG, tblimages_rel TLITTLE
WHERE TBIG.prodID = #URL.prodID#
AND TBIG.prodID = TLITTLE.prodID
AND TBIG.ImageType
I just needed help making my query work. Matthieu is helping me with a self
join.
Thanks,
Will
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.c
The way I do it on a couple of sites is to store large images in one folder
and thumbs in another. I store one file name in the db table and just use:
#application.photos#\#table.jpeg_name#
or
#application.photos_thumb#\#table.jpeg_name#
Jenny
yeah I agree with Charlie.. just add an extra column called
"thumbnail" with the image name.
On 11/2/05, Charlie Griefer <[EMAIL PROTECTED]> wrote:
> why not just name the images something like "img_large.jpg" and
> "img_thumb.jpg"
>
> this way you can just store "img" in the database (in one rec
why not just name the images something like "img_large.jpg" and "img_thumb.jpg"
this way you can just store "img" in the database (in one record), and
output #img#_large.jpg or #img#_thumb.jpg depending on which you need?
On 11/2/05, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> For my products, I
For my products, I have a tblImageTypes that looks like this
ImageTypeID (PK) ImageTypeName
1Thumbnail
2Large
I have a many/linking tblimages_rel that looks like this
ImageID (PK) ImageTypeID (FK) prodID (FK) filename
11
6 matches
Mail list logo
