<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "mailinglistform") Then MM_editConnection = MM_DBSSQL_STRING MM_editTable = "dbo.tbl_EmailAddresses" MM_editRedirectUrl = "mailconfirmation.htm" MM_fieldsStr = "emailaddress|value|hiddenField|value" MM_columnsStr = "nvar_EmailAddress|',none,''|nvar_Status|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> :: dynamic business solutions ::
     
 
 
Contracts - The Cornerstone of your employee/ employer relationship

This The Employee Contract is the most important part of the relationship between the employer and employee, and forms the basis for the terms that employee is being employed by. The Important thing is to look at the Basic Conditions of Employment Act to see the important points that need to be added in writing for the employee to be More...

 
Join our Mailing List
Enter your e-mail address below:
 
 
A Pan-African view of Service

We hold the view that we are a South African company and our services should reflect the cultural and ethnic diversity of Africa.

Our team consists of members from South Africa, Nigeria and Swaziland.

With our integrated approach to service provision, we can provide you with solutions that have a unique African style and manner, integrated with the best qualities of European business philosophy like efficiency and prompt service.

The cultural diversity within our team allows us to provide you with an insightful approach to managing and leading your people and managing your enterprise.




The traditional European model of business has come under intense scrutiny internationally and has proven inadequate in an African scenario. Newer models for business like those used in the Far East are quickly overtaking the European and American style of business because of their adaptation to the needs of the people who operate within those unique business environs. Our products allow you to integrate the best that the Far East has to offer (hard work and dedication), combined with Europe's focus on good management and leadership, coupled with an acknowledgement that African businesses should recognize their singular position within an African context (consultation and loyalty to good leadership).

Our Pan-African approach allows us to offer your enterprise the best services from all over Africa and allows you valuable insight into doing business in Africa.