<%@LANGUAGE="VBSCRIPT"%> <% ' *** 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 & "?" & 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")) = "form2") Then MM_editConnection = MM_ncs_STRING MM_editTable = "catalyst_subscribers" MM_editRedirectUrl = "catalyst_current.asp" MM_fieldsStr = "sub_1|value|sub_2|value|sub_3|value|sub_4|value|sub_5|value" MM_columnsStr = "sub_surname|',none,''|sub_name|',none,''|sub_company|',none,''|sub_email|',none,''|sub_tel|',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 %> NCS Resins
 

 


Data Privacy Policy
NCS Resins (Pty) Ltd does not collect personally identifiable information about individuals except when such individuals specifically provide such information on a voluntary basis, such as by completing an application form.

Personally identifiable information on individual users will not be sold or otherwise transferred to third parties without the prior consent of the user at the time of collection.

NCS Resins (Pty) Ltd reserves the right to perform statistical analyses of user behavior and characteristics in order to measure interest in and use of this website. E.g. our log program will collect data regarding type of web browsers used, country of origin and server platforms used. Only aggregated data from these analyses is used - no personal data is collected or transferred to third parties.


NCS Resins Website Content
NCS Resins (Pty) Ltd offers this website as a company information portal to customers, suppliers, distributors and those interested in the composites industry. NCS Resins (Pty) Ltd cannot guarentee that all information relating to products, services, legal acts and legislation are always accurate. NCS Resins (Pty) Ltd makes no warranty on the information and opinions appearing thereon or any of the products or services described thereon.

We offer documents to download from our server. Although we are confident that our documents are virus free, and all files are scrutinised by our server providers firewall, all downloads are at your own risk.

Links to Third Party Sites
As a convenience to customers and to the industry, NCS Resins (Pty) Ltd may provide hypertext links to web sites operated by third parties, either suppliers or industry news portals.

Although we endevour to only link to, or refer to, ethical, reliable websites, NCS Resins (Pty) Ltd makes no warranty nor endorses any linked web sites or the information and opinions appearing thereon or any of the products or services described thereon.

Use of such sites shall be at your own risk and it is your responsibility to take all protective measures to guard against viruses or other destructive agents that may be encountered there.

Intellectual Property
All content, graphics and pictures on this site are copyright of NCS Resins (Pty) Ltd except where specifically indicated otherwise.

No content, graphic or picture may be copied, stored or published by any means whatsoever without prior written approval of NCS Resins (Pty) Ltd o runless specifically stated on the website.

 

 


 



 

Disclaimer    | Sitemap    |  Home Page