You cannot.
On Fri, Sep 12, 2008 at 12:21 AM, Jan Limpens <[EMAIL PROTECTED]> wrote:
>
> how can I query a sp via multiquery?
>
> On Thu, Sep 11, 2008 at 6:10 PM, Ayende Rahien <[EMAIL PROTECTED]> wrote:
> > You can't.
> > You can reproduce this using a multi query
> >
> > On Fri, Sep 12, 2008 at 12:02 AM, Jan Limpens <[EMAIL PROTECTED]>
> wrote:
> >>
> >> Hello,
> >>
> >> I am asking a stored procedure for paginated results and for the
> >> obvious GUI reasons, I also need the number o total results found. My
> >> sp provides these resultsets. But how can I consummate them? I am
> >> aware of MultiQuery capabilities in that area, but is there a way I
> >> can do this with native sql? Or can I tell hql/criteria to somehow
> >> call a sp?
> >>
> >> var list = session.CreateSQLQuery("exec
> >> [FullTextSearch]
> >> :SearchString, :PageSize, :PageNumber")
> >>
> >>
> .SetResultTransformer(Transformers.AliasToBean(typeof(SearchResultItem)))
> >> .SetString("SearchString", searchString)
> >> .SetInt32("PageSize",
> >> searchParams.NumberResults)
> >> .SetInt32("PageNumber",
> >> searchParams.PageNumber)
> >> .List<SearchResultItem>();
> >>
> >> that's what it is looking like right now...
> >>
> >> help?
> >>
> >> --
> >> Jan
> >> ___________________
> >> [EMAIL PROTECTED]
> >> www.limpens.com
> >> +55 (11) 3082-1087
> >> +55 (11) 3097-8339
> >>
> >>
> >
> >
> > >
> >
>
>
>
> --
> Jan
> ___________________
> [EMAIL PROTECTED]
> www.limpens.com
> +55 (11) 3082-1087
> +55 (11) 3097-8339
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
