I have a database organized to do automatic versioning of entries. My table looks like this:
`id` int(10) unsigned NOT NULL auto_increment, `itemid` varchar(5) NOT NULL, `revision` int(10) unsigned NOT NULL, ... That being said, `id` is not used for anything in the application itself, but only for Database tasks. The `itemid` field is the field I wish to use for selecting the item, with the understanding that I select the entry with the most recent revision. I have no issues writing the SQL for this, but where I get lost is how I would set up CakePHP to retrieve this. For example, if I have an entry `id` = 5, `itemid` = "AAAAA", `revision` = 2, ... I want the URL to look like this: http://example.com/items/view/AAAAA and not http://example.com/items/view/5. Is this at all possible? The Database is from a legacy application from which we are migrating, which precludes me modifying its structure (at first, anyway.) Any help here is greatly appreciated. ./sparroah --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
