Line 34: var latest = db.Query("SELECT TOP 15 Title, Date, Image, ImagePromo, Author FROM Other WHERE Category='2' AND Live ='Yes' ORDER BY Date Desc");
Line 35: var toparticle = db.QuerySingle("SELECT TOP 1 Title, Date, BannerImage, Score, Author, BannerSwitch FROM Other WHERE Category='2' AND BannerSwitch = 'y' ORDER BY Date DESC");
Line 36: var topauthor = db.QuerySingle("SELECT FirstName, LastName FROM UserProfile WHERE UserID =@0", toparticle.Author);
Line 37:
Line 38: }
|