Hi people,
I'm trying to solve this problem of generating a random password can anyone
asisst?
It goes like this...
a user enters a unique Login ID which is checked against a Dbase.
(select loginID, id2,index
>From table 1
Where loginID = form.loginID
Next,
If loginID doesn't exist;
Then carry out instructions to generate new Id2 = / composed of:
random 3 characters = the digits 001 at the end.
Insert this new Id2 along with the form.LoginID into the table to create new
record.
ELSE if LoginID exists: (or a number of reocords exists which belong to user
with form.loginid:
use the value of the last Id2 inserted in the table or the record with an
Id2 value with the highest digit value i.e. if 2 records were inserted into
the table xxx001, and xxx002, the latter id2 value of xxx002 will be used to
generate the new Id2 value:
so that it should be an increment of 1 or new Id2 value = xxx003 .
Hence the new reocord will have the field values of:
LoginID = Form.loginid,
id2 = xxx003
Any suggestion.
I'll post any which I can come up with also.
Thanks.
M.
-----------------------------------------------
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
