<%@LANGUAGE="JAVASCRIPT"%> <% // *** Edit Operations: declare variables // set the form action variable var MM_editAction = Request.ServerVariables("SCRIPT_NAME"); if (Request.QueryString) { MM_editAction += "?" + Server.HTMLEncode(Request.QueryString); } // boolean to abort record edit var MM_abortEdit = false; %> <% if (String(Request("MM_insert")) == "frmDetails") { if (!MM_abortEdit) { // execute the insert var MM_editCmd = Server.CreateObject ("ADODB.Command"); MM_editCmd.ActiveConnection = MM_connOCA_STRING; MM_editCmd.CommandText = "INSERT INTO Info (Firstname, Surname, Affiliation, Addr1, Addr2, City, St, Zip, Phone, Ext, Email, [Year], Status, Type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; MM_editCmd.Prepared = true; MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("firstname"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param2", 202, 1, 20, Request.Form("surname"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("affiliation"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("addr1"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param5", 202, 1, 50, Request.Form("addr2"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param6", 202, 1, 30, Request.Form("city"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param7", 202, 1, 2, Request.Form("state"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param8", 202, 1, 10, Request.Form("zipcode"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param9", 202, 1, 12, Request.Form("phone"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param10", 202, 1, 5, Request.Form("ext"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param11", 202, 1, 50, Request.Form("email"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param12", 202, 1, 4, Request.Form("confyear"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param13", 202, 1, 10, Request.Form("mbrshipstatus"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param14", 202, 1, 25, Request.Form("mbrlevels"))); // adVarWChar MM_editCmd.Execute(); MM_editCmd.ActiveConnection.Close(); // append the query string to the redirect URL var MM_editRedirectUrl = "registerPP.html"; if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) { MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1) ? "?" : "&") + Request.QueryString; } Response.Redirect(MM_editRedirectUrl) } } %> <% var rsRegister_cmd = Server.CreateObject ("ADODB.Command"); rsRegister_cmd.ActiveConnection = MM_connOCA_STRING; rsRegister_cmd.CommandText = "SELECT * FROM Info"; rsRegister_cmd.Prepared = true; var rsRegister = rsRegister_cmd.Execute(); var rsRegister_numRows = 0; %> Ohio Communication Association

ONLINE CONFERENCE & MEMBERSHIP REGISTRATION

> Registration
OCA Journal
Position announcements

About You:
 
First name:*
Last name: *

Affiliation:*
Address (line 1):*
Address (line 2):
City:*
State:*
Zip code :*
Phone:
Extension:
Email:
* required field  

Membership Status:
 





Now indicate your choice of Membership & Conference Fees:
Membership + Conference
  $80
  $50
  $20
  $100
Membership Only
  $45
  $35
Conference - must be current OCA member
  Regular $35
  Student $15
Life Membership
  $1000
  $250

Copyright © 2004- 09, OCA
9/21/11
<% rsRegister.Close(); %>