Line 7:
Line 8: var news = db.QuerySingle("SELECT * FROM News WHERE title like '%'+@0+'%'", newsitem);
Line 9: var author = db.QuerySingle("SELECT FirstName, LastName, UserID, Image, ShortProfile, Profile FROM UserProfile WHERE UserID =@0", news.Author);
Line 10: var newslist = db.Query("SELECT TOP 8 ID, Title, Image, Date, Author FROM News WHERE ID <> @0 AND Live = 'Yes' ORDER BY Date Desc", news.ID);
Line 11:
|