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 -~----------~----~----~----~------~----~------~--~---
