Thanks, it did! :-)
On 7 Mar, 07:38, Tuna Toksoz <[email protected]> wrote:
> This should help
>
> http://nhforge.org/blogs/nhibernate/archive/2008/09/06/prepare-your-s...
>
> Tuna
> Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp://twitter.com/tehlike
>
> Typos included to enhance the readers attention!
>
>
>
> On Sat, Mar 7, 2009 at 1:46 AM, robcar <[email protected]> wrote:
>
> > It seems that this is a confirmed bug
> >http://jira.nhibernate.org/browse/NH-1617
>
> > And it seems it is fixed in the trunk version.
>
> > To show myself as the complete newbie I am. How do I go about
> > downloading the this version and compiling it?
>
> > /Robin
>
> > On 6 Mar, 11:55, robcar <[email protected]> wrote:
> > > Is there anyway to hook into the executing of the SQL so that I can
> > > alter the SQL before it is executed?
>
> > > Or anyway to stop NHibernate from being "smart".
>
> > > The SQL NHibernate tries to execute as a result of the configuration
> > > (with the formula) is this:
> > > SELECT this_.PriceId as PriceId0_0_,
> > > this_.Multiplier as Multiplier0_0_,
> > > this_.EffectiveDate as Effectiv3_0_0_,
> > > (ROW_NUMBER() this_.OVER (this_.PARTITION BY this_.AgreementId
> > ORDER
> > > BY this_.EffectiveDate DESC)) as formula0_0_
> > > FROM Price this_
>
> > > I just need to change this to:
>
> > > SELECT this_.PriceId as PriceId0_0_,
> > > this_.Multiplier as Multiplier0_0_,
> > > this_.EffectiveDate as Effectiv3_0_0_,
> > > (ROW_NUMBER() OVER (PARTITION BY this_.AgreementId ORDER BY
> > > this_.EffectiveDate DESC)) as formula0_0_
> > > FROM Price this_
>
> > > Please anyone?
>
> > > On 5 Mar, 19:36, robcar <[email protected]> wrote:
>
> > > > Thanks guys, my bad!
>
> > > > I did some testing enclosing it in parenthesis and messed up when
> > > > posting.
> > > > Unfortunately this isn't the problem. NHibernate still doesn't
> > > > recognize OVER and PARTITION as reserved words.
>
> > > > I also think I messed up with adding a column alias, so the "correct"
> > > > formula (that stil causes an exception) is:
> > > > ROW_NUMBER() OVER (PARTITION BY AgreementId ORDER BY EffectiveDate
> > > > DESC)- Dölj citerad text -
>
> > > - Visa citerad text -- Dölj citerad text -
>
> - Visa citerad 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
-~----------~----~----~----~------~----~------~--~---
