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