Well...
I've just find out what the error was...
In my model, i had
var $actAs = array('Tree');
instead of
var $actsAs = array('Tree');
D'oh!
Regards,
Luiz Poleto
On Oct 22, 1:42 pm, Luiz Poleto <[EMAIL PROTECTED]> wrote:
> I have the same issue:
>
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'generatetreelist' at line 1
>
> I changed the table to be compliant with the instructions in the
> cookbook, and i'm getting this error now.
> Any ideas?
>
> Regards,
> Luiz Poleto
>
> On Oct 22, 7:09 am, "David C. Zentgraf" <[EMAIL PROTECTED]> wrote:
>
> > Is your table set up correctly (includes parent_id, lft, rght)?
> > Post the error you're getting here, stabbing in the dark doesn't work
> > too well. ;o)
>
> > Chrs,
> > Dav
>
> > On 22 Oct 2008, at 14:16, mirfan wrote:
>
> > > Hello david,
> > > The link you provide me nearly solved my problem thanks, but there is
> > > a problem when i was trying it in a separate project it works as i
> > > need but when i integrate it in my project it gives me an sql error i
> > > don't know why is that problem coming please help me
>
> > > On Oct 20, 7:31 am, "David C. Zentgraf" <[EMAIL PROTECTED]> wrote:
> > >>http://book.cakephp.org/view/91/Tree
>
> > >> On 19 Oct 2008, at 20:10,mirfanwrote:
>
> > >>> Hi,
> > >>> I have a problem with recursion. I have a table for keeping the
> > >>> account information of all members in which each member has a parent
> > >>> now i have to find out all of the members in the downline of a
> > >>> specific one look at the following example.
> > >>> Member1
> > >>> |
> > >>> --------------------------------
> > >>> | |
> > >>> Member2 Member3
> > >>> | |
> > >>> Member4 -------------------------------
> > >>> | |
> > >>> Member5 Member6
> > >>> from member2 to member6 all are the downline of Member1 and member5
> > >>> and 6 are downline of member3
> > >>> please give a solution for this i am really tired and boared.
> > >>> Regards,
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
