np..will do -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 11:36 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Random Password - SQL
I know, I saw that one :O) This was something that I did in a hurry. You could try and add an exclusion param so you can stop I,1,l,0,O,o being generated, a client of ours asked for something like this. Users were getting confused with certain letters/numbers. If you do add anything to it, post it back and give us a look. Ade -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 11:27 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Random Password - SQL Cheers Adrian I will give it a whirl...I just cross posted to another list...sorry guys, I gave up on a reply ;-) -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 11:33 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Random Password - SQL I don't know if it works on SS7, I can't see any code that would suggest it would fail, see what you think. Ade CREATE PROCEDURE randomPassword @passwordLength INT, @password VARCHAR(50) OUTPUT AS BEGIN DECLARE @errorCode INT, @counter INT, @charGroup INT -- Variable to determine which group of characters to get a random value from SET @password = '' SET @counter = 0 WHILE @counter < @passwordLength BEGIN SET @charGroup = CAST( RAND() * 3 AS INT ) -- returns 0, 1 or 2 IF @charGroup = 0 BEGIN -- This will create a random number between 48 and 57 inclusive and hence a character between 0 and 9 SET @password = @password + CHAR( CAST( (58 - 48) * RAND() AS INT ) + 48 ) END ELSE IF @charGroup = 1 BEGIN -- This will create a random number between 65 and 90 inclusive and hence a character between A and Z SET @password = @password + CHAR( CAST( (91 - 65) * RAND() AS INT ) + 65 ) END ELSE IF @charGroup = 2 BEGIN -- This will create a random number between 97 and 122 inclusive and hence a character between a and z SET @password = @password + CHAR( CAST( (123 - 97) * RAND() AS INT ) + 97 ) END -- Increment WHILE loop counter SET @counter = @counter + 1 END SELECT @errorCode = @@ERROR IF @errorCode <> 0 BEGIN GOTO ERROR_EXIT END GOTO PROCEDURE_EXIT ERROR_EXIT: RETURN @errorCode PROCEDURE_EXIT: RETURN @errorCode END -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 10:32 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Random Password - SQL Anyone got a random password generator for SQL so I can use it within an SP? Cant seem to find one anywhere -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
