Wouldn't that only return one row though? I need to return all the unique item names, along with the highest ID for each. I'm trying to find the most recently created ID for each name in the table.
On Mar 2, 3:31 pm, Stu <[email protected]> wrote: > I'm not to familiar with MS SQL but you might want to consider using > find('first') instead of find('all') as it always returns the first > and only result. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
