Linksys validating identity problem Random chat male female
The following links are available: According to the provisions of the Identification Amendment Act, 2000 (Act No.28 of 2000, which was promulgated on 13 October 2000) all forms of identity documents other than the green bar-coded identity document are invalid.He passed away last week - I attended his funeral this morning.A great mathematical mind an Business man will sorely be missed. I assume that if there are SA citizens with an ID from the year 1900, that this would use the same year number: '00'. However, I am not sure if you can distinguish a '1900' ID from a '2000' ID etc.
-- If the answer differs, the ID number is invalid.
I do not know what the 'A' digit represents - for the old blue book id numbers, this digit is often other values (specially '0').
For the new id's, this is almost always '8' or '9'.
Regards, Willem Hi Guys, I tried to find a SQL Implementation of this function but Google failed me but I still know one exists. Let me know what you think:-- =============================================-- Author: Craig Peacock-- Create date: 08/10/2007-- Description: This will validate a SA ID Number-- =============================================ALTER PROCEDURE [dbo].[VAL_S01_Validate SAIDNumber] @IDNumber VARCHAR (13)ASBEGIN /* This function was created from the function posted at: DECLARE @A INT -- ~Holds Negative Index numbers DECLARE @B INT -- ~Holds Positive Index numbers DECLARE @C INT DECLARE @D INT -- ~The check digit DECLARE @I INT -- ~Counter Variable SET @D = -1 SET @A = 0 SET @B = 0 BEGIN TRY PRINT 'Getting Negative Numbers____________________' SET @I = 0 WHILE (@I 0) BEGIN SET @C = @C @B % 10 SET @B = @B / 10 END --WHILE SET @C = @C @A SET @D = 10 - (@C % 10) IF (@D = 10) SET @D = 0 IF (CAST(SUBSTRING(@IDNumber, 13, 1) AS INT) = @D) RETURN 1 ELSE RETURN 0 END TRY BEGIN CATCH RETURN 0 END CATCH RETURN 0END Willem and Craig, I tried the SQL previously on the blog and it worked (old and new numbers).
Craig's one doesn't seem to work though (unless it is a SQL version problem). It would appear that the tried and trusted rules don't work for ID numbers of people born after 1/1/2000.
lv_C := lv_C lv_A; lv_D := 10 - (lv_C mod 10); IF (lv_D = 10) THEN lv_D := 0; END IF;-- compare value in lv_D with lv_last_number lv_last_number := CAST(SUBSTR(p_id_number, 13, 1) AS NUMBER); IF (lv_last_number = lv_D) THEN lv_is_valid := 1; lv_rply := TRUE; END IF; RETURN lv_rply; -- ************************************ -- ** Handle an unexpected exception ** -- ************************************ EXCEPTION WHEN lv_length_err THEN lv_rply := FALSE; return lv_rply; WHEN no_data_found THEN lv_rply := FALSE; return lv_rply; --custom exception (place your own methods here) --WHEN OTHERS THEN -- raise_exception(SQLCODE, SQLERRM, 'FN_VALID_SA_ID_NUMBER'); END; Hi there I am a technical consultant and would like to know what the SSS as well as the A (8 & 9 in the id) and the z stands for.