from User u where u.Username = :username and :roleName in elements(u.Roles) SetMaxResult(1).UniqueResult<User>() != null
2009/10/8 Andy Kernahan <[email protected]> > > Hi there, > > I am trying create a query using HQL which checks to see if a user has > been assigned a certain role. I thought I would be able us: > > select exists(from User u where u.Username = :username and :roleName > in elements(u.Roles)) > > and then call UniqueResult<bool>() on the query object, except > ISession.CreateQuery throws a QuerySyntaxException with the following > message: > > Exception of type 'Antlr.Runtime.MismatchedTreeNodeException' was > thrown. near line 1, column 7 [select exists(from > Tss.PIBench.Model.User u where u.Username = :username and :roleName in > elements(u.Roles))] > > I have removed the select exists from the statement and queried it to > ensure that it is correct. > > Can I not use select exists this way? I would prefer not to have to > select count(*) ... > 0. > > The user class is as follows: > > class User { > ISet<string> Roles ... > string Username ... > ... > } > > Any help would be most appreciated. > > Andy. > > > > > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
