I'm currently in the midst of porting an existing site to CakePHP. The site's database has two tables, Members and Teams, and these are connected by a join table.
However this join table has a third column that stores the datetime that the link / join was made. I've setup the models to use return the associated data ordered by the datetime column but the tricky part is setting the datetime value on inserts - for this I will have to write some custom SQL calls. Now I know that join table shouldn't contain additional data, and I like the solution that Nate suggested of creating a third model: http://groups.google.com/group/cake-php/browse_thread/thread/bef70558f7854732 However if I create a third model can I use that to order the results? If not it seems I am better off creating the joins with custom SQL that sets the datetime value. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
