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.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
