This podcast http://live.cakephp.org/shows/view/4 has some info on
what you need to do for this. There's a method you have to implement
(sorry I didn't write it down).
On Dec 22, 11:26 am, George <geo...@hakumei.net> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
