%'Include Data Connection%> <%'Include ADO constants include file for VBScript%> <% 'open data connection Call OpenConn() %> <%'Include Utility Scripts%> <% 'dim strMode - The strMode variable is defined in the header_inc.asp file. Dim intDynamicFormId 'form variables Dim strName_en Dim strName_fr Dim strSubmitButtonCaption_en Dim strSubmitButtonCaption_fr Dim strFeedback_en Dim strFeedback_fr Dim strAlreadyFilledOutFeedback_en Dim strAlreadyFilledOutFeedback_fr Dim bolSubmitsToExternalURL Dim strExternalURL Dim strExternalURL_fr Dim bolEmailForm Dim strPrimaryEmail Dim strCCEmail Dim bolSaveToDB Dim bolAllowAdminToAdd Dim bolAllowAdminToEdit Dim bolUserCanOnlySubmitOnce Dim bolUserCanSubscribe Dim intMaxPossibleAnswers Dim intGroupId 'set french vars to null strName_fr = Null strSubmitButtonCaption_fr = Null strFeedback_fr = Null strAlreadyFilledOutFeedback_fr = Null strExternalURL_fr = Null 'initialize the boolean variables bolSubmitsToExternalURL = 0 bolEmailForm = 0 bolSaveToDB = 0 bolAllowAdminToAdd = 0 bolAllowAdminToEdit = 0 bolUserCanOnlySubmitOnce = 0 bolUserCanSubscribe = 0 'initialize the default for intMaxPossibleAnswers intMaxPossibleAnswers = 5 If Request.Form <> "" Then 'get the mode strMode = Request.Form("txtMode") 'get the form field values strName_en = Request.Form("txtName_en") strFeedback_en = Request.Form("txtFeedback_en") strAlreadyFilledOutFeedback_en = Request.Form("txtAlreadyFilledOutFeedback_en") strSubmitButtonCaption_en = Request.Form("txtSubmitButtonCaption_en") strExternalURL = Request.Form("txtExternalURL") strPrimaryEmail = Request.Form("txtPrimaryEmail") strCCEmail = Request.Form("txtCCEmail") intMaxPossibleAnswers = Request.Form("selMaxPossibleAnswers") 'get the boolean values If Request.Form("chkSubmitToExternal") <> "" Then bolSubmitsToExternalURL = 1 End If If Request.Form("chkEmailTheForm") <> "" Then bolEmailForm = 1 End If If Request.Form("chkSaveToDB") <> "" Then bolSaveToDB = 1 End If If Request.Form("chkAllowAdminToAdd") <> "" Then bolAllowAdminToAdd = 1 End If If Request.Form("chkAllowAdminToEdit") <> "" Then bolAllowAdminToEdit = 1 End If If Request.Form("chkUserCanOnlySubmitOnce") <> "" Then bolUserCanOnlySubmitOnce = 1 End If If Request.Form("chkUserCanSubscribe") <> "" Then bolUserCanSubscribe = 1 End If 'get the group value intGroupId = CInt(Request.Form("txtSelectedGroupId")) Select Case LCase(strMode) Case "add" intDynamicFormId = AddDynamicForm(intGroupId, strName_en, strName_fr, strSubmitButtonCaption_en, strSubmitButtonCaption_fr, strFeedback_en, strFeedback_fr, strAlreadyFilledOutFeedback_en, strAlreadyFilledOutFeedback_fr, bolSubmitsToExternalURL, strExternalURL, strExternalURL_fr, bolEmailForm, strPrimaryEmail, strCCEmail, bolSaveToDB, bolAllowAdminToAdd, bolAllowAdminToEdit, bolUserCanOnlySubmitOnce, bolUserCanSubscribe, intMaxPossibleAnswers) 'if users can subscribe... If bolUserCanSubscribe Then 'add the necessary elements Call AddSubscriberFormElements(intDynamicFormId) End If Case "edit" 'get the id intDynamicFormId = Request.Form("txtDynamicFormId") Call UpdateDynamicForm(intGroupId, intDynamicFormId, strName_en, strName_fr, strSubmitButtonCaption_en, strSubmitButtonCaption_fr, strFeedback_en, strFeedback_fr, strAlreadyFilledOutFeedback_en, strAlreadyFilledOutFeedback_fr, bolSubmitsToExternalURL, strExternalURL, strExternalURL_fr, bolEmailForm, strPrimaryEmail, strCCEmail, bolSaveToDB, bolAllowAdminToAdd, bolAllowAdminToEdit, bolUserCanOnlySubmitOnce, bolUserCanSubscribe, intMaxPossibleAnswers) End Select 'update the html field in the form element table Call CreateAndUpdateDynamicFormPageContent(intDynamicFormId) 'give the user feedback with regards to the success of the database transaction Session("FeedbackMode") = LCase(strMode) Session("FeedbackError") = err.number Session("FeedbackModule") = "dynamic_form" Session("Referer") = "/admin/form_element_edit.asp?id=" & intDynamicFormId Response.Write("") Response.Write("") 'end add/edit (db transactions) Else 'get the mode strMode = Request.QueryString("mode") Select Case LCase(strMode) Case "add" Case "edit" 'get the id intDynamicFormId = Request.QueryString("id") 'if the id is numeric and not an empty string... If IsNumeric(intDynamicFormId) And intDynamicFormId <> "" Then Dim rsDynamicForm Set rsDynamicForm = GetDynamicForm(intDynamicFormId) If rsDynamicForm.EOF = False Then Do Until rsDynamicForm.EOF 'populate the variable with the database fields strName_en = rsDynamicForm("DYNAMIC_FORM_NAME_EN") strFeedback_en = rsDynamicForm("DYNAMIC_FORM_FEEDBACK_EN") strAlreadyFilledOutFeedback_en = rsDynamicForm("DYNAMIC_FORM_ALREADY_FILLED_OUT_FEEDBACK_EN") strSubmitButtonCaption_en = rsDynamicForm("DYNAMIC_FORM_SUBMIT_BUTTON_EN") bolSubmitsToExternalURL = rsDynamicForm("DYNAMIC_FORM_SUBMITS_TO_EXTERNAL_FORM") strExternalURL = rsDynamicForm("DYNAMIC_FORM_EXTERNAL_FORM_URL_EN") bolEmailForm = rsDynamicForm("DYNAMIC_FORM_ENTRIES_ARE_EMAILED") strPrimaryEmail = rsDynamicForm("DYNAMIC_FORM_EMAIL_ADDRESS_PRIMARY") strCCEmail = rsDynamicForm("DYNAMIC_FORM_EMAIL_ADDRESS_CC") bolSaveToDB = rsDynamicForm("DYNAMIC_FORM_SAVES_TO_DATABASE") bolAllowAdminToAdd = rsDynamicForm("DYNAMIC_FORM_ALLOWS_ADMIN_USERS_TO_ADD_ENTRY") bolAllowAdminToEdit = rsDynamicForm("DYNAMIC_FORM_ALLOWS_ADMIN_USERS_TO_EDIT_ENTRY") bolUserCanOnlySubmitOnce = rsDynamicForm("DYNAMIC_FORM_ONLY_ANSWERED_ONCE_PER_USER") bolUserCanSubscribe = rsDynamicForm("DYNAMIC_FORM_ALLOWS_SUBSCRIPTION") intMaxPossibleAnswers = rsDynamicForm("DYNAMIC_FORM_MAX_POSSIBLE_ANSWERS") intGroupId = rsDynamicForm("GROUP_ID") rsDynamicForm.MoveNext Loop rsDynamicForm.Close Set rsDynamicForm = Nothing Else Set rsDynamicForm = Nothing 'redirect the user Response.Redirect "/admin/default.asp" End If Else 'redirect the user Response.Redirect "/admin/default.asp" End If Case Else 'redirect the user Response.Redirect "/admin/default.asp" End Select %>
<% End If 'close the data connection Call CloseConn() %>