Thanks for the suggestion, but unfortunately it didn't seem to do
anything, and I still am getting a complaint that the reports table
for the Report model was not found. Here is the exact code in the
model:
<?php
class Report extends AppModel {
var $useTable = false;
public function getYearlySalesStats($year) {
return $this->query("EXECUTE report_SalesStats $year, NULL");
}
}
?>
Annoying. The manual seems to say pretty cut and dry that by setting
the $useTable member equal to false, cake will ignore the table
requirement.
For more info, I'm running cake on fedora/apache, and using MSSQL
Server as my database.
On Dec 19, 12:59 am, Kappa <andrea.cappalu...@gmail.com> wrote:
> Have you tried to reset the cache? Sometimes i have the same
> problem, and i solve it deleting the cache in /app/tmp/cache
>
> bye,
> Andrea
>
> On Dec 18, 6:55 pm,George<geo...@hakumei.net> wrote:
>
> > Hello.
>
> > I'm pretty new to cake and am working on creating a reporting intranet
> > application. Basically I aggregate a bunch of data through views and
> > stored procedures on the database, and would like to build a "Report"
> > model that will just have a bunch of custom functions to run the
> > various stored procedures. As the functions would be returning
> > datasets in different forms (based on the various reports), I wouldn't
> > want this to actually be associated with any one table (the data is
> > aggregated from many tables).
>
> > I've read here that you can set the $useTable attribute in a model to
> > false and then cake won't try to locate the model in the database.
> > After setting $useTable to both false and null, I still have cake
> > complaining that it can't find the table reports in the database when
> > I call any action on the ReportsController.
>
> > Is there something else I need to set/do? Or should I not be even
> > using a model at all in this case, and query directly from the
> > controller? To me, it seemed like encapsulating all database calls in
> > models would be the best solution, but does anyone else with more cake
> > experience have an opinion?
>
> > Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
