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