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