You can generate a random number with the Randomize function, although I
don't know if you can limit it to three numbers.
Jeff Epstein
Web Producer
-----Original Message-----
From: morris johnston [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 11:45 AM
To: [EMAIL PROTECTED]
Subject: Tricky Password Question!
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/[email protected]/
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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
