I need an engine that will randomly produce up to 10 alphanumeric characters later to be stored in a table of my SQL2000 db. Here's a run down on how I plan to use it:
I have a SQL2000 database web site that will have the ability to use CDONTS to send email. Within this email that gets sent will be 3 session variables and one URL. The url will return the person who gets the email to a 'hidden' record within the database that points to some information about the email sender. I paln on appending values to the url to make it complete.
So in the email you'd see:
is something I have in the message body of the email with the value abcdef1234 added to it.
When you click on it, your taken to web page abcdef1234.asp and you can see the data stored on that page.
This value (abcdef1234) should first get set in the table when a user creates an account for the first time. So for example:
Username, password, first name, and a hidden account code of abcdef1234 was generated when the person click the submit button...
The user doesn't see the hidden number, but is a session value, that I carry when the user logs in, and later clicks to apply on line.
I need this info to be unique, and random. If its not random, then any user could enter abcdef1235 and find the next users info.
Maybe someone could point me to a site that has something or if this is simple (and I?m making it too hard) to do in ASP, please let me know. Examples are certainly welcome. J
I?m opening this question at 125 points and depending how hard it becomes, I?ll adjust the points as we go.