7 : SELECT id, path, DealerNo, ShowGallery, Title, PhotoOrder, LEFT(id, 11) AS SortName, SUBSTRING(id, 11, LEN(id)) AS SortNameLast
8 : FROM gallery_Photos_Dealer
9 : WHERE (ShowGallery = 1) AND (DealerNo = '#Trim(session.lindal.dealerDealerNo)#')
10 : ORDER BY PhotoOrder, SortName DESC, SortNameLast
11 : </CFQUERY>
|