Hi there
I have a table that currently has the key field as being Field Name Type Null Default ID Int(11) No auto_increment I would like to change the field to have it with a unique id that is created using the following code: <!--- Create a new Unique ID ---> <cfset IDstring = CreateUUID()> <cfset ThisMemberID = Left(IDstring,9)&LSDateFormat(Now(),'DD-MM-YY')> So the table would look something like this Field Name Type Null Default ID Char(25) No What is the best way to do this as the table already exists. Thanks in advance. Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
