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 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 have a tblImageTypes that looks like this > > > > ImageTypeID (PK) ImageTypeName > > 1 Thumbnail > > 2 Large > > > > I have a many/linking tblimages_rel that looks like this > > > > ImageID (PK) ImageTypeID (FK) prodID (FK) filename > > 1 1 25 shirtsmall.jpg > > 2 2 25 shirtlarge.jpg > > > > On my detail page I'd like to show the small image and link it to the > > larger image but I'm having trouble on how to run my query. > > > > <cfquery blah blah> > > SELECT imageID, prodID, imagetypeID, prodimagefilename > > FROM tblimages_rel > > WHERE prodID = #URL.prodID# > > ??????? > > > > Thanks, > > Will > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
