I changed my controller from this:
 DaysRequest.Append(@"
   select
       month(trn.Date),
       sum(trn.FishDays),
       sum(trn.BoatDays),
       year(trn.Date)
   from TransactionDetail dtl
       inner join dtl.Transaction trn
       inner join trn.Badge bdg
       inner join bdg.District dst
   where
       bdg.Classification.ID = :ID");

To this:
 DaysRequest.Append(@"
   select
       month(trn.Date),
       sum(trn.FishDays),
       sum(trn.BoatDays),
       year(trn.Date)
   from Transaction trn
       inner join trn.Badge bdg
       inner join bdg.District dst
   where
       bdg.Classification.ID = :ID");


The controller is declared like this:
        [Layout("excel"), ProgramFilter("LAW"),
ControllerDetails("report",Area="law/timereporting")]
        public class LawTimeReportingReportController : PFBCController
        {

The model objects are declared like this:
        [ActiveRecord("law_tr_Transaction", Lazy = true)]
        public class Transaction : ValidationModel<Transaction>
        {
....
        }

        [ActiveRecord("law_tr_TransactionDetail", Lazy = true)]
        public class TransactionDetail : ValidationModel<TransactionDetail>
        {
....
        }


I'm getting this message:
Controller not found. Area: 'Law/TimeReporting' Controller Name:
'Report'
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details:
Castle.MonoRail.Framework.ControllerNotFoundException: Controller not
found. Area: 'Law/TimeReporting' Controller Name: 'Report'

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace
below.

Stack Trace:


[ControllerNotFoundException: Controller not found. Area: 'Law/
TimeReporting' Controller Name: 'Report']
 
Castle.MonoRail.Framework.Services.AbstractControllerFactory.CreateControllerInstance(String
area, String name) +356
 
Castle.MonoRail.Framework.Services.AbstractControllerFactory.CreateController(UrlInfo
urlInfo) +109
 
Castle.MonoRail.Framework.EngineContextModule.CreateController(IRailsEngineContext
context) +410
 
Castle.MonoRail.Framework.EngineContextModule.CreateControllerAndRunStartRequestFilters(Object
sender, EventArgs e) +492
 
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+68
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
Boolean& completedSynchronously) +75








-- 
You received this message because you are subscribed to the Google Groups 
"Castle Project Development List" 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/castle-project-devel?hl=en.

Reply via email to