Which is the return alias ?The SQL is not enough, why you don't send the whole <sql-query> node ?
2009/2/24 antoschka <[email protected]> > > Yes I know this chapter quite well but the IN-construction is not > touched there. > > I tried it alread like that: > <![CDATA[ > SELECT > {type.*} > FROM Type type > WHERE > type.Id IN :myTypeList > ]]> > > query.SetParameterList("myTypeList ", new ArrayList(){ "employee", > "assistant" }); > IList returnList = query.List(); > > but it always complains about the syntax of myTypeList. > > The signature of SetParameterList asks for ICollection, so I don't see > any reason why arraylist shoul not work > > Any idea? > > antoschka > > On 24 Feb., 17:59, Fabio Maulo <[email protected]> wrote: > > http://nhforge.org/doc/nh/en/index.html#querysql-namedqueries > > > > 2009/2/24 antoschka <[email protected]> > > > > > > > > > > > > > Hi, > > > > > I was wondering if it is possible to create a named query like this: > > > <![CDATA[ > > > SELECT > > > {type.*} > > > FROM Type type > > > WHERE > > > type.Id IN :myTypeList > > > ]]> > > > > > If this is Possible how do I need to set the myTypeList parameter. > > > > > I tried some but it always complains about the syntax. > > > > > Any idea how to approach that > > > > > Thanks for your help > > > > > antoschka > > > > -- > > Fabio Maulo > > > -- 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 -~----------~----~----~----~------~----~------~--~---
