ı think this was fixewd 2 days ago. can you verify?
On 10/17/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> We have a small problem with what seemed to be an easy enough
> query ...
>
> var newsGroupTitles = new[] { "CRU Steel News" };
> var tagTitles = new[] { "Steel sheet" };
> var criteria = DetachedCriteria.For(typeof(Article),
> "article")
> .CreateCriteria("article.NewsGroupList", "newsGroups")
> .Add(Property.ForName("newsGroups.Title").In(newsGroupTitles))
> .CreateCriteria("article.TagList", "tags")
> .Add(Property.ForName("tags.Title").In(tagTitles))
> .AddOrder(new Order("article.Date", true));
>
> Which returns back a list of articles that are in one of the newgroups
> and one of the tags specified.
>
> We only wanted the first 15 of these, so added a SetMaxResults to
> this, but at this point NHiberante falls over.
>
> //criteria.SetMaxResults(15); // This line causes the
> query to break :-(
>
> This causes:
> System.Data.SqlClient.SqlException : The column 'articleid' was
> specified multiple times for 'query'.
> The column 'articleid' was specified multiple times for 'page'.
>
>
>
> Any ideas how to fix this?
> >
>
--
Tuna Toksöz
Typos included to enhance the readers attention!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
