Hmmm... That sounds better :) The project number makes since.
Thanks Rick -----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:12 AM To: CF-Talk Subject: Re: Account Number Creation Well, certainly if you're only taking part of a GUID/UUID, it's not going to be guaranteed unique. Depending on how the GUID is being generated, it might not even be likely to be unique. To keep client IDs short, we auto-increment a field. To identify separate projects, we increment the project based on the client ID. So, the third project for the 794th client would be 794-3 HTH. --BenD cfhelp wrote: > I am thinking about taking the first part of a GUID and using it as the > Clients Account Number for when they make payments. > > > > #ListGetAt(ClientGUID,'1','-')# > > > > Do you think it's a good idea? Will the first part be a unique? > > > > > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138440 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
