ColdFusion UUID and MS SQL Server UUID

     I was trying to manage data in a table that contains UUID as primary key. While inserting data from CF, I am checking whether the <cfargument type="UUID" ... . This showed datatype error and a bit googling told me that the representation of UUID in CF and MS SQL server are different, so we need to insert/remove one (- 'hyphen') from the UUID before using it in SQL/CF.

   I created a conversion function and is working fine.

     Is this a good method? I needed a uniqueID as primary key (No. the int will not do as I need to pass the ID through URL). What should we do in this situation? Can any other data type be used ?

- Prasanth