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