[User] <= that is a MsSQL column name with HQL you have to use properties names
On Tue, Oct 5, 2010 at 1:31 PM, bdaniel7 <[email protected]> wrote: > Hello, > > I'm trying to perform an update using HQL: > > string query = @"insert into UserAudit (Page, [User]) select :page, > u.Id from User u where u.Id = :userId"; > > sqlQuery = session.CreateQuery( query ) > .SetParameter( "page", requestedPage ) > .SetParameter( "userId", UserId ); > sqlQuery.ExecuteUpdate(); > > and I get this exception: > > NHibernate.Hql.Ast.ANTLR.QuerySyntaxException: Exception of type > 'Antlr.Runtime.NoViableAltException' was thrown. near line 1, column > 29 [insert into UserAudit (Page, [User]) select :page, u.Id from User > u where u.Id = :userId] > > column 29 would be at i from insert. > > The same query > "insert into UserAudit (Page, [User]) select 'boo', u.Id from Users u > where u.Id = 1" > works when executed in SQL Mgmt Studio. > > I tested with a string instead of param :page, but I get the same > exception. > > I'm running Antlr 3.1.0 and NH 2.1.2 > > What it's wrong with it? > > Thanks, > Daniel > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
