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:222972 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
