<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
var rsSwapsDisplay__MMColParam = "0";
if (String(Request.QueryString("authNbr")) != "undefined" &&
String(Request.QueryString("authNbr")) != "") {
rsSwapsDisplay__MMColParam = String(Request.QueryString("authNbr"));
}
%>
<%
if (rsSwapsDisplay__MMColParam != "0"){
var rsSwapsDisplay = Server.CreateObject("ADODB.Recordset");
rsSwapsDisplay.ActiveConnection = MM_cnnMtn_STRING;
rsSwapsDisplay.Source = "SELECT * FROM tblSwaps WHERE authorizationNbr = '"+ rsSwapsDisplay__MMColParam.replace(/'/g, "''") + "'";
rsSwapsDisplay.CursorType = 0;
rsSwapsDisplay.CursorLocation = 2;
rsSwapsDisplay.LockType = 1;
rsSwapsDisplay.Open();
var rsSwapsDisplay_numRows = 0;
}
%>
<%
var rsSwapsUpdate__MMColParam = "0";
if (String(Request.QueryString("authorizationNbr")) != "undefined" &&
String(Request.QueryString("authorizationNbr")) != "") {
rsSwapsUpdate__MMColParam = String(Request.QueryString("authorizationNbr"));
}
%>
<%
if (rsSwapsUpdate__MMColParam != "0"){
var adoCon=Server.CreateObject("ADODB.Connection");
adoCon.Open(MM_cnnMtn_STRING);
var rsSwaps = Server.CreateObject("ADODB.Recordset");
var strSQL="SELECT * FROM tblSwaps WHERE authorizationNbr = '"+ rsSwapsUpdate__MMColParam.replace(/'/g, "''") + "'";
rsSwaps.CursorType = 2;
rsSwaps.LockType = 3;
rsSwaps.Open(strSQL,adoCon);
rsSwaps.fields("itemName")=String(Request.QueryString("itemName"));
rsSwaps.fields("Description")=String(Request.QueryString("Description"));
rsSwaps.fields("City")=String(Request.QueryString("City"));
rsSwaps.fields("State")=String(Request.QueryString("State"));
rsSwaps.fields("Price")=(Request.QueryString("Price"));
rsSwaps.fields("firstName")=String(Request.QueryString("firstName"));
rsSwaps.fields("lastName")=String(Request.QueryString("lastName"));
rsSwaps.fields("Phone")=String(Request.QueryString("Phone"));
rsSwaps.fields("Email")=String(Request.QueryString("Email"));
rsSwaps.Update();
//rsSwaps.CursorLocation = 2;
//var rsSwaps_numRows = 0;
rsSwaps.Close();
Response.Redirect("mtn_swp_list.asp?updated");
}
%>
Update an Item
<% if (rsSwapsDisplay__MMColParam != "0" ){
if(!rsSwapsDisplay.EOF && !rsSwapsDisplay.BOF){ %>
<% } else { %>
No Item with that Authorization Number found.
Try
again.
Home
<%
if (rsSwapsDisplay__MMColParam != "0") rsSwapsDisplay.Close();
%>
