2 : SELECT Photos_Images.Filename, Photos_Images.Photoby, Photos_Images.ImageDescription, Photos_Images.ImageTitle, Photos_Galleries.GalleryName, Photos_Category.Category, Photos_Galleries.GalleryID
3 : FROM (Photos_Images INNER JOIN Photos_Galleries ON Photos_Images.GalleryID = Photos_Galleries.GalleryID) INNER JOIN Photos_Category ON Photos_Galleries.CategoryID = Photos_Category.CategoryID
4 : WHERE (((Photos_Images.ImageID)=#url.imageID#));
5 : </cfquery>
6 : <cfmodule template="modules/skin.cfm" rootpath="" pagetitle="#A.galleryname# #a.imagetitle#">
|