> numbers once they get freed up? Therefore instead of assigning someone
> with the next auto-number they would get the lowest freed up number in
> the database. This question is just out of curiosity but I won't start
> doing it yet (no ones in the database yet!).
I'd definitely recommend *against* recycling a userID. You will potentially
be creating serious problems for user on down the road as people start
taking over old account numbers from another user.
This is especially true if you are going to be giving this key to users and
they know what it is. If you are using this to identify an account or user,
you might want to choose something really unique to that user like a
username or email address. Another drawback to giving autoincremented ID's
info to users is that any user could easily guess another user's account
number.
-Cameron
-----------------
Cameron Childress
Sumo Consulting Inc
---
land: 858.509.3098
cell: 678.637.5072
aim: cameroncf
email: [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
