Yes, although I needed to make some modifications to SqlString, so that
might be an issue
2008/10/17 [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>
> Interesting idea ... you suggesting just copy the class to a new
> project?
>
> On Oct 17, 3:06 pm, "Ayende Rahien" <[EMAIL PROTECTED]> wrote:
> > Take the current MsSQL 2005 dialect, compile that as a separate assembly,
> > and use.
> > It should fix the issue, and has no deps on anything else.
> >
> > 2008/10/17 [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> >
> >
> >
> >
> >
> > > OK - nope that alternative is bunkum and doesnt work ... any other
> > > ideas anyone?
> >
> > > On Oct 17, 11:28 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> > > wrote:
> > > > Oh crud .... typical!!!!!!
> >
> > > > Nope we can't test ... cos we are having to use an old build of NH,
> > > > because we are using an old build of NH Search, cos we are using
> > > > Lucene (all of which is in itself a nightmare!!!!) (anyone got any
> > > > idea when NH Search/Lucene/NH will be in synch again?)
> >
> > > > I was just playing around and came up with this alternative ... any
> > > > ideas if it is better/worse/indifferent? Seems to work ok (from
> quick
> > > > test) ....
> >
> > > > var newsGroupTitles = new[] { "Steel News" };
> > > > var tagTitles = new[] { "Asia" };
> >
> > > > var tags = DetachedCriteria.For<Tag>()
> > > > .Add(Property.ForName("Title").In(tagTitles))
> > > > .SetProjection(Projections.Id());
> >
> > > > var ngs = DetachedCriteria.For<NewsGroup>()
> > > > .Add(Property.ForName("Title").In(newsGroupTitles))
> > > > .SetProjection(Projections.Id());
> >
> > > > var criteria = DetachedCriteria.For(typeof(Article), "article")
> > > > .Add(Subqueries.Exists(tags))
> > > > .Add(Subqueries.Exists(ngs));
> > > > criteria.SetMaxResults(15);
> >
> > > > var articles = ActiveRecordMediator<Article>.FindAll(criteria);
> > > > Console.WriteLine(articles.Length);
> >
> > > > On Oct 17, 11:09 am, "Tuna Toksöz" <[EMAIL PROTECTED]> wrote:
> >
> > > > > ı 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!- Hide quoted text
> -
> >
> > > > > - Show quoted text -- Hide quoted text -
> >
> > > > - Show quoted text -- Hide quoted text -
> >
> > - Show quoted text -
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
