mukesh.laxkar-octalsoftware
-
3/13/2012 1:39:26 AM
Show Blog Post with Blog & Category Name.
Hi, I was create a page to show blog post according to category && i used repeater & passed following query in where condition to filter data of selected category
({%categoryid|(toint)%} = 0) OR (DocumentID IN (SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID = {%categoryid|(toint)%})) OR (DocumentID IN (SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID IN (SELECT CategoryID FROM CMS_Category WHERE CategoryID = {%categoryid|(toint)%})))
all was going perfect.
but now i want to show blog name and category name with blog post relevant that blog post.
how can it possible?????
thanks
|