Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Anthony Candaele 1197 posts 2049 karma points
    Sep 16, 2012 @ 10:02
    Anthony Candaele
    0

    problem with where clause

    Hi,

    I'm using a Razor where statement to get a list of childnodes:

    subcategoryItems = @Model.AncestorOrSelf("SolutionArea").Children.Where("solutionSubcategories == \"" + subcategory + "\"");

    However, when I add a AND (&&) condition to the WHERE clause I get an error:

    subcategoryItems = @Model.AncestorOrSelf("SolutionArea").Children.Where("solutionCategory == \"" + category + "\"" && "solutionSubcategories == \"" + subcategory + "\"");

    Is there a syntax error in this statement??

    thanks for your help,

    Anthony

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Sep 16, 2012 @ 11:27
    Jan Skovgaard
    1

    Hi Anthony

    What does the error message say?

    /Jan

    Copy Link
  • Anthony Candaele 1197 posts 2049 karma points
    Sep 16, 2012 @ 13:30
    Anthony Candaele
    0

    Hi Jan,

    Can't say, the debugger won't step in the process. Maybe it's a syntax error.

    greetings,

    Anthony

    Copy Link
  • Anthony Candaele 1197 posts 2049 karma points
    Sep 16, 2012 @ 14:06
    Anthony Candaele
    1

    found the issue, this where clause works:

    subcategoryItems = Model.AncestorOrSelf("SolutionArea").Children

                            .Where("solutionSubcategories == \"" + subcategory + "\" && solutionCategory==\""+ category + "\""); 

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft