Hey Will, You may want to think about rearranging some of your schema: anytime you hit a situation where you wind up with column names like "prodMainImage1", "prodMainImage2", etc., you've found a place where you may want to examine what you're doing more closely.
Personally, I'd completely nix the "prodMainImage1", "prodMainImage2" approach in the tblproductimages table, and let one row in that table represent one image. Then, I'd add a prodImageID column to the tblAvailableColors table that indicated what images were pictures of a product in a given color. >From there, the queries to get all images for a product or get the appropriate images for a product in a given color become fairly simple and straightforward. -Joe -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189878 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
