%@LANGUAGE="VBSCRIPT"%>
<%
Dim MM_editAction
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
Dim MM_abortEdit
MM_abortEdit = false
%>
<%
' IIf implementation
Function MM_IIf(condition, ifTrue, ifFalse)
If condition = "" Then
MM_IIf = ifFalse
Else
MM_IIf = ifTrue
End If
End Function
%>
<%
If (CStr(Request("MM_insert")) = "form1") Then
If (Not MM_abortEdit) Then
' execute the insert
Dim MM_editCmd
Set MM_editCmd = Server.CreateObject ("ADODB.Command")
MM_editCmd.ActiveConnection = MM_conn1_STRING
MM_editCmd.CommandText = "INSERT INTO sunny66.wqc_membership (Firstname, Surname, OrgName, Address1, TownCity, Postcode, Tel, Fax, email, Website, contact, NoEmployees, org_description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 201, 1, 50, Request.Form("Firstname")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 201, 1, 50, Request.Form("Surname")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 201, 1, 100, Request.Form("OrgName")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 201, 1, 255, Request.Form("Address1")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 201, 1, 50, Request.Form("TownCity")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 201, 1, 20, Request.Form("Postcode")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 201, 1, 20, Request.Form("Tel")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 201, 1, 20, Request.Form("Fax")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 201, 1, 70, Request.Form("email")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 201, 1, 100, Request.Form("Website")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 201, 1, 100, Request.Form("contact")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 5, 1, -1, MM_IIF(Request.Form("NoEmployees"), Request.Form("NoEmployees"), null)) ' adDouble
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 201, 1, 200, Request.Form("org_description")) ' adLongVarChar
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
' append the query string to the redirect URL
Dim MM_editRedirectUrl
MM_editRedirectUrl = "wqc_membership_confirm.htm"
If (Request.QueryString <> "") Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If
Response.Redirect(MM_editRedirectUrl)
End If
End If
%>
Wales Quality Centre
 |
 |
|
 |
 |
  |
| MEMBERSHIP |
WALES QUALITY CENTRE MEMBERSHIP FORM
No. of Employees |
Rate |
VAT |
TOTAL |
1 - 25 |
£ 195 |
£ 34.13 |
£ 229.13 |
26 - 100 |
£ 395 |
£ 69.13 |
£ 464.13 |
101 - 300 |
£ 550 |
£ 96.25 |
£ 646.25 |
301 - 500 |
£ 755 |
£ 132.13 |
£ 887.13 |
More than 500 |
£ 1575 |
£ 275.63 |
£ 1850.63 |
Educational Establishments: Schools
FE and HE Colleges |
£ 295
£ 590 |
£ 46.38
£ 103.25 |
£ 311.38
£ 693.25 |
|
|
  |
|
 |
| |
 |
| |
Web 31