<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="../Connections/MediaEdge.asp" -->
<%
// *** Edit Operations: declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
  MM_editAction += "?" + Request.QueryString;
}

// boolean to abort record edit
var MM_abortEdit = false;

// query string to execute
var MM_editQuery = "";
%>
<%
// *** Update Record: set variables

if (String(Request("MM_update")) == "form1" &&
    String(Request("MM_recordId")) != "undefined") {

  var MM_editConnection = MM_MediaEdge_STRING;
  var MM_editTable  = "Content";
  var MM_editColumn = "ID";
  var MM_recordId = "" + Request.Form("MM_recordId") + "";
  var MM_editRedirectUrl = "";
  var MM_fieldsStr = "Title|value|Link|value|Image|value|Image_Height|value|Image_Width|value|Vertical_Space|value|Horizontal_Space|value|Keywords|value|Description|value|Title_Main|value|Content_Main|value|Image_Main|value|Image_Width_Main|value|Image_Height_Main|value|Vertical_Space_Main|value|Horizontal_Space_Main|value|Background_Main|value";
  var MM_columnsStr = "Title|',none,''|Link|',none,''|Image|',none,''|Image_Height|none,none,NULL|Image_Width|none,none,NULL|Vertical_Space|none,none,NULL|Horizontal_Space|none,none,NULL|Keywords|',none,''|Description|',none,''|Title_Main|',none,''|Content_Main|',none,''|Image_Main|',none,''|Image_Width_Main|none,none,NULL|Image_Height_Main|none,none,NULL|Vertical_Space_Main|none,none,NULL|Horizontal_Space_Main|none,none,NULL|Background_Main|',none,''";

  // create the MM_fields and MM_columns arrays
  var MM_fields = MM_fieldsStr.split("|");
  var MM_columns = MM_columnsStr.split("|");
  
  // set the form values
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    MM_fields[i+1] = String(Request.Form(MM_fields[i]));
  }

  // append the query string to the redirect URL
  if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) {
    MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString;
  }
}
%>
<%
// *** Update Record: construct a sql update statement and execute it

if (String(Request("MM_update")) != "undefined" &&
    String(Request("MM_recordId")) != "undefined") {

  // create the sql update statement
  MM_editQuery = "update " + MM_editTable + " set ";
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    var formVal = MM_fields[i+1];
    var MM_typesArray = MM_columns[i+1].split(",");
    var delim =    (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
    var altVal =   (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
    var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
    if (formVal == "" || formVal == "undefined") {
      formVal = emptyVal;
    } else {
      if (altVal != "") {
        formVal = altVal;
      } else if (delim == "'") { // escape quotes
        formVal = "'" + formVal.replace(/'/g,"''") + "'";
      } else {
        formVal = delim + formVal + delim;
      }
    }
    MM_editQuery += ((i != 0) ? "," : "") + MM_columns[i] + " = " + formVal;
  }
  MM_editQuery += " where " + MM_editColumn + " = " + MM_recordId;

  if (!MM_abortEdit) {
    // execute the update
    var 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) {
      Response.Redirect(MM_editRedirectUrl);
    }
  }

}
%>
<%
var updateContent__MMColParam = "1";
if (String(Request.QueryString("ID")) != "undefined" && 
    String(Request.QueryString("ID")) != "") { 
  updateContent__MMColParam = String(Request.QueryString("ID"));
}
%>
<%
var updateContent = Server.CreateObject("ADODB.Recordset");
updateContent.ActiveConnection = MM_MediaEdge_STRING;
updateContent.Source = "SELECT * FROM Content WHERE ID = "+ updateContent__MMColParam.replace(/'/g, "''") + "";
updateContent.CursorType = 0;
updateContent.CursorLocation = 2;
updateContent.LockType = 1;
updateContent.Open();
var updateContent_numRows = 0;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Content Update</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
@import url("../blockStyles.css");
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style></head>

<body>
<form method="post" action="<%=MM_editAction%>" name="form1">
  <table align="center">
    <tr valign="baseline">
      <td nowrap align="right">Title:</td>
      <td>
        <input type="text" name="Title" value="<%=(updateContent.Fields.Item("Title").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Link:</td>
      <td>
        <input type="text" name="Link" value="<%=(updateContent.Fields.Item("Link").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Image:</td>
      <td>
        <input type="text" name="Image" value="<%=(updateContent.Fields.Item("Image").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Image_Height:</td>
      <td>
        <input type="text" name="Image_Height" value="<%=(updateContent.Fields.Item("Image_Height").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Image_Width:</td>
      <td>
        <input type="text" name="Image_Width" value="<%=(updateContent.Fields.Item("Image_Width").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Vertical_Space:</td>
      <td>
        <input type="text" name="Vertical_Space" value="<%=(updateContent.Fields.Item("Vertical_Space").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Horizontal_Space:</td>
      <td>
        <input type="text" name="Horizontal_Space" value="<%=(updateContent.Fields.Item("Horizontal_Space").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Keywords:</td>
      <td>
        <input type="text" name="Keywords" value="<%=(updateContent.Fields.Item("Keywords").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Description:</td>
      <td>
        <input type="text" name="Description" value="<%=(updateContent.Fields.Item("Description").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Title_Main:</td>
      <td>
        <input type="text" name="Title_Main" value="<%=(updateContent.Fields.Item("Title_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Content_Main:</td>
      <td>
        <input type="text" name="Content_Main" value="<%=(updateContent.Fields.Item("Content_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Image_Main:</td>
      <td>
        <input type="text" name="Image_Main" value="<%=(updateContent.Fields.Item("Image_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Image_Width_Main:</td>
      <td>
        <input type="text" name="Image_Width_Main" value="<%=(updateContent.Fields.Item("Image_Width_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Image_Height_Main:</td>
      <td>
        <input type="text" name="Image_Height_Main" value="<%=(updateContent.Fields.Item("Image_Height_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Vertical_Space_Main:</td>
      <td>
        <input type="text" name="Vertical_Space_Main" value="<%=(updateContent.Fields.Item("Vertical_Space_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Horizontal_Space_Main:</td>
      <td>
        <input type="text" name="Horizontal_Space_Main" value="<%=(updateContent.Fields.Item("Horizontal_Space_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Background_Main:</td>
      <td>
        <input type="text" name="Background_Main" value="<%=(updateContent.Fields.Item("Background_Main").Value)%>" size="32">
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">&nbsp;</td>
      <td>
        <input type="submit" value="Update record">
      </td>
    </tr>
  </table>
  <input type="hidden" name="MM_update" value="form1">
  <input type="hidden" name="MM_recordId" value="<%= updateContent.Fields.Item("ID").Value %>">
</form>
<p>&nbsp;</p>
</body>
</html>
<%
updateContent.Close();
%>