Did the test case attachment come through alright? Anyone know if this
is actually a bug or a misinterpretation of how to use MultiQuery with
Named Queries?
On Thu, Sep 25, 2008 at 2:01 PM, Jamie Fraser <[EMAIL PROTECTED]> wrote:
> Damn, not having much luck.. Castle bug yesterday and this today!
>
> Test case attached - just remember and point it to any local DB via
> hibernate.cfg.xml (the named queries are very simple, they don't
> actually hit any tables so it won't matter which DB NH points to).
>
> -Jamie
>
> On Thu, Sep 25, 2008 at 1:32 PM, Ayende Rahien <[EMAIL PROTECTED]> wrote:
>> This looks like a bug, please create a stand alone test case for this.
>>
>> On Thu, Sep 25, 2008 at 3:30 PM, Jamie Fraser <[EMAIL PROTECTED]>
>> wrote:
>>>
>>> Okay, when I have 2 named queries (declared like:
>>>
>>> var fullTextSearchQuery = session.GetNamedQuery("FullTextSearch")
>>>
>>> .SetResultTransformer(Transformers.AliasToBean(typeof(SearchResultItem)))
>>> .SetString("SearchString", searchString)
>>> .SetInt32("PageSize", searchParams.NumberResults)
>>> .SetInt32("PageNumber", searchParams.PageNumber);
>>>
>>> var fullTextCountQuery = session.GetNamedQuery("FullTextCount")
>>> .SetString("SearchString", searchString)
>>> .SetInt32("PageSize", searchParams.NumberResults)
>>> .SetInt32("PageNumber", searchParams.PageNumber);
>>>
>>> They both work fine.
>>>
>>> However if I do
>>>
>>> var results = session.CreateMultiQuery()
>>> .AddNamedQuery("FullTextSearch")
>>> .AddNamedQuery("FullTextCount")
>>> .SetString("SearchString", searchString)
>>> .SetInt32("PageSize", searchParams.NumberResults)
>>> .SetInt32("PageNumber", searchParams.PageNumber)
>>> .List();
>>>
>>> I get an error saying "query must begin with SELECT or FROM"
>>>
>>> What am I doing wrong?
>>>
>>> On Thu, Sep 25, 2008 at 9:05 AM, Ayende Rahien <[EMAIL PROTECTED]> wrote:
>>> > NHibernate will not understand 2 results sets. You will have to deal
>>> > with
>>> > that manually.
>>> > You can turn that into two different queries and call them using multi
>>> > query, however.
>>> >
>>> > On Thu, Sep 25, 2008 at 11:04 AM, Jamie Fraser <[EMAIL PROTECTED]>
>>> > wrote:
>>> >>
>>> >> I'm trying to execute a stored procedure (I've also tried modifying
>>> >> this into a SQL statement and called it via a named query) which
>>> >> returns 2 result sets.
>>> >>
>>> >> First result set is the data (search results, essentially).
>>> >> Second result set is the count of results.
>>> >>
>>> >> I'm not sure if a Multiquery is the right thing to use - from what I
>>> >> understand a MQ will allow me to execute N queries in a batch and
>>> >> present single results for each one, whereas I want to execute a
>>> >> single query and get 2 results from it.
>>> >>
>>> >> Can anyone advise what to do?
>>> >>
>>> >>
>>> >
>>> >
>>> > >
>>> >
>>>
>>>
>>
>>
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
