Admin Report Update Form

// *** Edit Operations: declare variables // set the form action variable MM_editAction = CGI.SCRIPT_NAME; If (CGI.QUERY_STRING NEQ "") { MM_editAction = MM_editAction & "?" & CGI.QUERY_STRING; } // boolean to abort record edit MM_abortEdit = false; // query string to execute MM_editQuery = ""; // *** Insert Record: set variables If (IsDefined("MM_insert")) { MM_editDatasource = #MM_articlesdb_DSN#; MM_editUserName = #MM_articlesdb_USERNAME#; MM_editPassword = #MM_articlesdb_PASSWORD#; MM_editTable = "admin_reports"; MM_editRedirectUrl = "index.cfm"; MM_fieldsStr = "month|value|year|value|display_loc|value|title|value|author|value|subby|value|article_text|value|language|value|category|value"; MM_columnsStr = "month|',none,''|year|',none,''|displaylocation|',none,''|title|',none,''|author|',none,''|subby|',none,''|article|',none,''|language|',none,''|category|',none,''"; // create the MM_fields and MM_columns arrays MM_fields = ListToArray(MM_fieldsStr,"|"); MM_columns = ListToArray(MM_columnsStr,"|"); // set the form values For (i=1; i+1 LE ArrayLen(MM_fields); i=i+2) { MM_fields[i+1] = IIf(IsDefined(MM_fields[i]),"FORM." & MM_fields[i],DE("")); } // append the query string to the redirect URL If (MM_editRedirectUrl NEQ "" AND CGI.QUERY_STRING NEQ "") { If (Find("?", MM_editRedirectUrl) EQ 0) { MM_editRedirectUrl = MM_editRedirectUrl & "?" & CGI.QUERY_STRING; } Else { MM_editRedirectUrl = MM_editRedirectUrl & "&" & CGI.QUERY_STRING; } } } // *** Insert Record: construct a sql insert statement If (IsDefined("MM_insert")) { // create the insert sql statement MM_tableValues=""; MM_dbValues=""; For (i=1; i+1 LE ArrayLen(MM_fields); i=i+2) { FormVal = MM_fields[i+1]; MM_typesArray = ListToArray(MM_columns[i+1],","); Delim = IIf(MM_typesArray[1] NEQ "none","MM_typesArray[1]",DE("")); AltVal = IIf(MM_typesArray[2] NEQ "none","MM_typesArray[2]",DE("")); EmptyVal = IIf(MM_typesArray[3] NEQ "none","MM_typesArray[3]",DE("")); If (FormVal EQ "") { FormVal = EmptyVal; } Else { If (AltVal NEQ "") { FormVal = AltVal; } Else If (Delim EQ "'") { // escape quotes FormVal = "'" & Replace(FormVal,"'","''","ALL") & "'"; } Else { FormVal = Delim & FormVal & Delim; } } If (i GT 1) { MM_tableValues = MM_tableValues & ","; MM_dbValues = MM_dbValues & ","; } MM_tableValues = MM_tableValues & MM_columns[i]; MM_dbValues = MM_dbValues & FormVal; } MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"; } #PreserveSingleQuotes(MM_editQuery)# SELECT month, month_number FROM months SELECT year FROM year SELECT selection, displaylocation, assigned_to FROM admin_report_displaylocation WHERE assigned_to = '#rs_dsply_loc__aev_uid#' SELECT username FROM auth WHERE username = '#rs_subby__aev_uid#' Admin Report Update Form

Report Submission Form

Submit a report for the WBS Internet Monthly Report

Instructions

Display Info
Please select the following parameters for this report.
Month of the Report:
Year:
Display Location:

Note: Only the areas for your reports will appear in the Display Location.

Fill out the Display Info
Do not forget to select the Month & Year
Fill out the Report Info
Type or Paste the report in the large text box below.
Click "Submit Report"

After you click Submit

You will be returned to the Report Select Page. You will have two options:

View the Report to confirm the article submission was successful.
Return here to the "Report Submission Form" and add another article to the report.

Report Info
Report Title:
Author:
Submitted By:

Report Text Box

Suggestions:
- Type your report in Word or Outlook so you can spell check it.
- Save a copy before you paste it here in case you need to update or correct it later.
- Finally, the text will appear on the report page as plain text. You may choose to add some of the HTML code below if you prefer.

HTML Code
Blank Line: To add a blank line between paragraphs, put:	Return: To end a sentence and return to the next line put:	Bold: To make a word(s) bold, put:	Italics To make a word(s) italic, put:
<p> at the end of the first paragraph.	<br> at the end of the sentence.	<b> before the word and </b> after the word.	<i> before the word and </i> after the word.
Bulleted List: To make a bulleted list put 3 codes:		Link: To make a link to another web page:	Link HTML code you can copy and paste
<ul><li> at the before the first list item <li>before each subsequent item </ul>following the last item		<a href="put the full URL between the quotes including the http://"> Following the arrow, type the text you want to be the link </a> (finally, this </a> goes after the text to close the link)	<a href="">Linked text</a>