User-generated id column

Hello,

I am converting an existing db to a web-based app. For most of the
tables I have created a standard auto-incrementing integer id column.
However, two of them have a pre-existing id column in the form 'AA-
DDDDDDD', where A is alpha, D is numeric and the hyphen is embedded.

I am looking for a way to allow these self-generated id values to be
entered by the respective 'add' and 'edit' actions which normally hide
the 'id' column.

I suspect this may be nigh on impossible and I should rename the
existing id column to something else (i.e. num), insert a normal auto-
incrementing integer id column and re-bake the affected tables. Is
this my only, perhaps my only _sane_, option?

Thanx, McS.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---