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