I need to show all blogs from category
for this purpose i'm trying to use Repeater with WHERE condition
`CategoryID IN (23)`
but this not work
PS.
Without where condition the repeater shows all blogs
You can use there K# expression
GlobalObjects.Users.Where("UserID="+ToInt( QueryString["UserId"], 0 )).GetValue("IsExpertIn")
Hello,
if you are using repeater you can use property Category name in properites of Repetear
In this field i can't use "sql" but i need it to receive category name
select IsExpertIn from CMS_User where UserID=ToInt( QueryString["UserId"], 0 )
this sql returns me category name
How can i use it in Category name field?
You can use a macro for the where statement for example:
DocumentID IN (SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID = '{%categoryid%}')
Please, sign in to be able to submit a new answer.