sorry to bring this up but i'm having similar issues with the suggested fix:
Session.Delete(string.Format("from Tokens where UserId = {0}", userId));
same exception. any idea?
On Thu, Aug 6, 2009 at 6:17 AM, adressin <[email protected]> wrote:
>
> Duh... thanks for the extra eyes!
>
> -Aaron
>
> On Aug 5, 7:17 pm, Fabio Maulo <[email protected]> wrote:
> > I have done thisThe exception say " near line 1, column 7"
> > and I found
> > "SELECT from"
> > That is a clear wrong HQL since between "SELECT" and "from" you put what
> you
> > are selecting or you should start directly with "from".
> >
> > 2009/8/5 adressin <[email protected]>
> >
> >
> >
> >
> >
> > > Hello,
> >
> > > I just upgraded to NHibernate 2.1 and am now getting an error on a
> > > query that use to work. Any ideas? Thanks in advance.
> >
> > > -Aaron
> >
> > > NHibernate.Hql.Ast.ANTLR.QuerySyntaxException: Exception of type
> > > 'Antlr.Runtime.NoViableAltException' was thrown. near line 1, column 7
> > > [SELECT from Tradewinds.Samms.Core.Domain.TransactionHeader as tHeader
> > > where tHeader in ( SELECT DISTINCT tDetail.TransactionHeader from
> > > Tradewinds.Samms.Core.Domain.TransactionDetail as tDetail where
> > > tDetail in (select tap.TransactionDetailRecord from
> > > Tradewinds.Samms.Core.Domain.TransactionApprovalHistory as tap where
> > > tap.ApprovalStatus = :approvalStatus and tap.RouteEntry.User.UsrCode
> > > = :approver ) )]
> > > at NHibernate.Hql.Ast.ANTLR.ErrorCounter.ThrowQueryException()
> > > at NHibernate.Hql.Ast.ANTLR.HqlParseEngine.Parse()
> > > at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.Parse(Boolean
> > > isFilter)
> > > at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.DoCompile
> > > (IDictionary`2 replacements, Boolean shallow, String collectionRole)
> > > at NHibernate.Engine.Query.HQLQueryPlan..ctor(String hql, String
> > > collectionRole, Boolean shallow, IDictionary`2 enabledFilters,
> > > ISessionFactoryImplementor factory)
> > > at NHibernate.Engine.Query.HQLQueryPlan..ctor(String hql, Boolean
> > > shallow, IDictionary`2 enabledFilters, ISessionFactoryImplementor
> > > factory)
> > > at NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(String
> > > queryString, Boolean shallow, IDictionary`2 enabledFilters)
> > > at NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(String
> > > query, Boolean shallow)
> > > at NHibernate.Impl.AbstractSessionImpl.CreateQuery(String
> > > queryString)
> >
> > --
> > 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]<nhusers%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en
> -~----------~----~----~----~------~----~------~--~---
>
>
--
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.
