first, is there any info about HQL in the NHibernate's Docs? I couldn't find it, am I looking in he wrong place? this is the site I'm cheking for help:
http://wiki.nhibernate.org/display/NH/Documentation
Now, for the question: I'm trying to use HQL for the first time. It seems pretty simple, but I tried this:
"FROM Users AS u WHERE u.email = :email and u.id != :id"
and it threw this Exception
"unexpected token: as [FROM Usuarios AS u WHERE u.email = :email and u.id != :id]"
so I removed the "AS", although Hibernate's Doc says it's optional. I tried it again, and the new exception says
"in expected: u [FROM Usuarios u WHERE u.email = :email and u.id != :id]"
So where's the error??