Re: AR with Multiple DB´S

2008-12-09 Thread Gabriel Mancini de Campos
I know, but the original system (in asp 3) and i try to migration to .net with monorail, ar ... and this particular (and bizzar) behavor is a customer requires. :( so any idea? josh robb wrote: On Thu, Dec 4, 2008 at 6:06 AM, Gabriel Mancini de Campos [EMAIL PROTECTED] wrote: hi i have

Re: Layout hook

2008-12-09 Thread Jan Limpens
@Mike: yeah, exactly that I had in mind, actually one might wonder what purpose windsor integration for components serves if not for injecting services... Anyway, this could not be resolved with SubClassing, because this works on action- and not class level. @Ken: on the other hand, a i could

Re: Want to do a fancy sum in an active Record query

2008-12-09 Thread M Kenyon II
I would like to do this: select DATEPART(wk, trn.TransactionDate) AS Week, dtl.SectionID, dtl.CategoryID,

Re: Want to do a fancy sum in an active Record query

2008-12-09 Thread Markus Zywitza
If you use sum(max(0,dtl.Hours-40)) as Overtime you don't need a case-statement. -Markus 2008/12/9 M Kenyon II [EMAIL PROTECTED] I would like to do this: select DATEPART(wk, trn.TransactionDate) AS Week,