Member Verification

Registration Verification

<% lastname = trim(Request.form("LName")) verify = trim(request("verify")) cmnt = "" if verify = "yes" then if lastname = "" and firstname = "" then cmnt = "Please specify at least the first or last name of the person you wish to verify." ' got to give as at least some of it else 'set default query string sql = "Select * from RegTbl where left(Name,"&len(lastname)&") = '" & lastname & "' order by name asc" ' search on names dbopen() set rscheck = my_conn.Execute(sql) if rscheck.eof then cmnt = "

The name you submitted cannot be found in the PAAB Register.
This may be because the name has been entered differently to the way it is entered in the Register, please try a variation" cmnt = cmnt & "
Search using only the first 4 or 5 characters of the last name / surname

" cmnt = cmnt & "

If registration is still not verified, contact the Registration Secretary " cmnt = cmnt & "timothym@icaz.org.zw

" else ' we found the member, show the info %> <% do while not rscheck.eof 'display all the matching entries %> <% rscheck.movenext loop %>

<%=rscheck("Name")%>		Registration Number: Constituent Body: Category:	<%=rscheck("RegNo")%> <%=rscheck("ConBody")%> <%=rscheck("Category")%>

<% ' session("firstname") = rscheck("FirstName") cmnt = "

Perform another search?" 'invite again end if ' end of displaying the stuff we found dbclose() end if ' end of test for searching with only one name end if ' end of wanting to verify (verify = 'yes') if verify = "" or cmnt <> "" then 'not verifying because they still need to enter some details %>

<% if cmnt > "" then %>
<%=cmnt%>
<% end if %>

Invalid professional certificates are increasingly common.
Certificates as such are not a proof of membership of or registration with a professional body.
If in doubt ask for confirmation of the entry in the register.

To verify an individuals registration with the Public Accountants and Auditors Board of Zimbabwe please enter their last name below and click the "Verify" button.

Individuals Last Name:
(at least the first 4 letters of the surname are required)

<% end if ' end of wanting to enter some details (verify = '' or cmnt>0) %>

Individuals Last Name: (at least the first 4 letters of the surname are required)