Kentico 7 Web part repeater SQL problem

How is the query string value passed to your repeater? Id on't see any macro within your web part configuration.

Im just recently on this project and as I know its passed by clicking on the author name, the rest is in the transformation <a href="?author=<%# Eval("BlogPostAuthor") %>"><%# BlogFunctions.GetAuthorName(Eval("BlogPostAuthor")) %>

http://prntscr.com/jz0tap

I understand the part how those links are generated, but somewhere (I would expect the Where condition property) the query string parameter should be processed by the repeater to know what author to render.

The where condition in the web part configuration is empty as you can see on the print scrn so its really confusing to know where does it filter the blogs by author

http://prntscr.com/jyzm7g

Isn't there any other repeater on that page? Finding the spot that it filters the author is crucial to find the root of your error.

Found it. There was a repeater hidden at the bottom called "Posts from single author". This is the where condition in the repeater configuration:

BlogPostAuthor LIKE {% QueryString.GetValue("author") |(identity)GlobalAdministrator%}

Is it possible to insert some macro which tests if QueryString.GetValue("author") is a number, if not just to return to homepage ? Because there are two more repeaters for year and month...

http://prntscr.com/jz30sl

It should be enough to set the visibility of that web part based on a number in that query string, so please click that small black arrow next to the Visible property and put following macro in there:

{% Convert.ToInt(QueryString.GetValue("author"), 0) > 0 |(identity)GlobalAdministrator%}

I've put the macro in the visibility, still have the same problem if i put directly in the url ?author=3jfhfhf or if i put author=334343 it returns the second error Incorrect syntax near ')'

http://prntscr.com/jz3xbz

And also get another error when there is no querystring

http://prntscr.com/jz3xv4

Yes, that seems to have done the job. Thank you.