Update Quesry oddity (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

vqitinc -> Update Quesry oddity (1/14/2007 20:21:39)

I have a form that gets the last updated record from the database and allows the user to update the record. Here is the form: 



<html>

<%
myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("../../fpdb/sms.mdb")

FUNCTION dropDownMenu(tableName,dbFieldName,formFieldName,sortBy,selectItem)
	ddSQL = "SELECT " & dbFieldName & " FROM " & tableName & " ORDER BY " & dbFieldName & " ASC"
	set conntemp=server.createobject("adodb.connection")
	conntemp.open myDSN
	set rstemp=conntemp.execute(ddSQL)
	IF  rstemp.eof THEN
	   response.write "No records matched so cannot make menu."
	   Call CloseAll
	ELSE
		menuArray=rstemp.getrows
		Call CloseAll
		Response.write("<select size='1' name='" & formFieldName & "'>" & VbCrLf)
		FOR m = 0 TO ubound(menuArray,2)
			Response.write("<option")
			IF menuArray(0,m) = selectItem THEN
				Response.write(" selected")
			END IF
			Response.write(">" & menuArray(0,m) & "</option>" & VbCrLf)
		NEXT
		Response.write("</select>" & VbCrLf)
	END IF
END FUNCTION


SUB CloseAll
   'rstemp.close
   'set rstemp=nothing
   'conntemp.close
   'set conntemp=nothing
END SUB

%>


<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Shipment Management System</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<style href>a {text-decoration: none} </style>
<link rel="stylesheet" type="text/css" href="../../sms_bin/includes/sms_style.css">
<style fprolloverstyle>A:hover {color: #800000}
</style>
</head>

<body bgcolor="#CFDBE7" topmargin="0" leftmargin="0" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" style="text-align: center">

<div align="center">

<div align="center">
	<table border="0" width="740" id="table9" cellpadding="0" height="54" background="../../images/Header.gif" style="border-collapse: collapse" bordercolor="#638AB0">
		<tr>
			<td valign="top" style="border-left-style: solid; border-left-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px" width="446"> </td>
			<td valign="top" style="border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
			<table border="0" width="100%" id="table10" cellspacing="0" cellpadding="0">
				<tr>
					<td valign="bottom">
					<p align="center">
					<img border="0" src="../../images/entcentertext.gif" width="201" height="15"></td>
				</tr>
			</table>
			<table border="0" width="100%" id="table11" cellspacing="0" cellpadding="0">
				<tr>
					<td>
					<p align="center">
					<img border="0" src="../../images/headerline.gif" width="240" height="7"></td>
				</tr>
			</table>
			<table border="0" width="100%" id="table12" cellspacing="0" cellpadding="0" height="30" style="color: #800000">
				<tr>
					<td>
					<div align="center">
						<!-- #include file="../../sms_bin/includes/menu_title_header.htm" --></div>
					</td>
				</tr>
			</table>
			</td>
		</tr>
	</table>
</div>
	<table border="0" width="740" id="table13" cellpadding="0" style="border-collapse: collapse" bordercolor="#638AB0" height="25">
		<tr>
			<td style="border-left-style: solid; border-left-width: 1px; border-top-width: 1px; " width="160" bgcolor="#638AB0">
			<p align="center"><b><font color="#FFFFFF" size="2" face="Arial">
			<a href="../../contractor/default.asp">Main </a></font></b>
			<a href="../../contractor/default.asp"><b><font face="Arial" size="2">Page</font></b></a></td>
			<td style="border-right-style: solid; border-right-width: 1px; border-top-width: 1px; " bgcolor="#EDEDE1" valign="bottom">
			<p align="center">
			<iframe name="menu_top_admin" src="../menu_top_enterprise.htm" marginwidth="1" marginheight="1" scrolling="no" border="0" frameborder="0" width="555" height="20" target="_top">
			Your browser does not support inline frames or is currently configured not to display inline frames.
			</iframe></p>
			</td>
		</tr>
	</table>
	<table border="0" width="740" id="table2" cellpadding="0" bgcolor="#FFFFFF" style="border-collapse: collapse" bordercolor="#638AB0">
		<tr>
			<td valign="top" style="border-style:solid; border-width:1px; " width="159" bgcolor="#EDEDE1">
			<table border="0" width="100%" id="table14" cellpadding="0" height="30" style="border-collapse: collapse" bordercolor="#638AB0">
				<tr>
					<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" bgcolor="#EAEFF4">
					<p align="center"><b>
					<font face="Arial" size="2" color="#878750">Shipment Manager</font></b></td>
				</tr>
			</table>
			<p>
			<iframe name="I1" src="menu_left_shipment_ent.asp" marginwidth="1" marginheight="1" scrolling="no" border="0" frameborder="0" width="149" height="300" target="_top">
			Your browser does not support inline frames or is currently configured not to display inline frames.
			</iframe>
			<p> </td>
			<td valign="top" style="border-style:solid; border-width:1px; ">
			<table border="0" width="100%" id="table15" cellspacing="0" cellpadding="8">
				<tr>
					<td valign="top" width="50%">
					<p align="center">
					<font size="4" face="Arial" color="#878750">Latest Shipment 
					Added</font></p>
					<!--#include file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Query_Shipment WHERE ModifiedDate =  (SELECT Max(ModifiedDate) FROM Query_Shipment);"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="sms"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&IDShpmt=3&EnterDate=135&ModifiedDate=202&OLastName=202&OFirstName=202&OPostfix=202&OPrefix=202&OAddress1=202&OAddress2=202&OCity=202&OState=202&OCounty=202&OZip=202&OTelephone1=202&OExt1=202&OTelephone2=202&OExt2=202&OCellPhone=202&OFax1=202&OEmail=202&DLastName=202&DFirstName=202&DPostfix=202&DPrefix=202&DAddress1=202&DAddress2=202&DCity=202&DState=202&DCounty=202&DZip=202&DTelephone1=202&DExt1=202&DTelephone2=202&DExt2=202&DCellPhone=202&DFax1=202&DEmail=202&GeneralInstructions=203&OriginInstructions=203&DestInstructions=203&BillTo=202&SalesRep=202&Contractor=202&DeliveryPrice=3&PickUpPrice=3&OriginFlightsQty=202&OriginFlightsPrice=3&DeliveryFlightsQty=202&DeliveryFlightsPrice=3&AdtlMilesQty=202&AdtlMilesPrice=3&Accessorial01=202&AccessorialPrice01=3&Accessorial02=202&AccessorialPrice02=3&Accessorial03=202&AccessorialPrice03=3&Accessorial04=202&AccessorialPrice04=3&Accessorial05=202&AccessorialPrice05=3&Accessorial06=202&AccessorialPrice06=3&Accessorial07=202&AccessorialPrice07=3&Total=3&"
fp_iDisplayCols=66
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<form METHOD="POST" action="main_shipment_ent_update_processor.asp">
						<table border="1" width="100%" id="table146" cellspacing="0" cellpadding="2" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td bgcolor="#EDEDE1" width="33%">
								<p align="center"><b>
								<font face="Arial" size="2" color="#547BA2">
								Shipment ID</font></b></td>
								<td bgcolor="#EDEDE1" width="33%">
								<p align="center"><b>
								<font face="Arial" size="2" color="#547BA2">
								Entry Date</font></b></td>
								<td bgcolor="#EDEDE1" width="33%">
								<p align="center"><b>
								<font face="Arial" size="2" color="#547BA2">Last 
								Modified Date</font></b></td>
							</tr>
							<tr>
								<td width="33%">
								<p align="center"><font size="2" face="Arial">
								<%=FP_FieldVal(fp_rs,"IDShpmt")%></font></td>
								<td width="33%">
								<p align="center"><font size="2" face="Arial">
								<%=FP_FieldVal(fp_rs,"EnterDate")%></font></td>
								<td width="33%">
								<p align="center"><font size="2" face="Arial">
								<%=FP_FieldVal(fp_rs,"ModifiedDate")%></font></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table147" cellspacing="0" cellpadding="0">
							<tr>
								<td> </td>
							</tr>
						</table>
						<table border="1" width="100%" id="table128" cellpadding="0" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td width="50%">
								<table border="0" width="100%" id="table129" cellpadding="3" bgcolor="#EDEDE1" style="border-collapse: collapse" bordercolor="#878750">
									<tr>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
										<p align="center">
										<font face="Arial" size="4" color="#547BA2">
										Shipper</font></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table130" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								<table border="0" width="100%" id="table131" cellspacing="0" cellpadding="3">
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Honorific:</font></b></td>
										<td><%call dropDownMenu("Dropdown_Honorific","DisplayValue","OPrefix","OptionName",FP_FieldVal(fp_rs,"OPrefix"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">First Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OFirstName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OFirstName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Last Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OLastName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OLastName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address1:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OAddress1" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OAddress1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address2:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OAddress2" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OAddress2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">City:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OCity" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OCity")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">State:</font></b></td>
										<td><%call dropDownMenu("Dropdown_State","DisplayValue","OState","OptionName",FP_FieldVal(fp_rs,"OState"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">County:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OCounty" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OCounty")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Zip:</font></b></td>
										<td>
										<input NAME="OZip" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OZip")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone:</font></b></td>
										<td>
										<input NAME="OTelephone1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OTelephone1")%>">
										<b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="OExt1" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"OExt1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone</font></b></td>
										<td>
										<input NAME="OTelephone2" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OTelephone2")%>">
										<b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="OExt2" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"OExt2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Cell Phone:</font></b></td>
										<td>
										<input NAME="OCellPhone" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OCellPhone")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Fax:</font></b></td>
										<td>
										<input NAME="OFax1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OFax1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Email:</font></b></td>
										<td>
										<input NAME="OEmail" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OEmail")%>"></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table132" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								</td>
								<td width="50%">
								<table border="0" width="100%" id="table133" cellpadding="3" bgcolor="#EDEDE1" style="border-collapse: collapse" bordercolor="#878750">
									<tr>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
										<p align="center">
										<font face="Arial" size="4" color="#547BA2">
										Consignee</font></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table134" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								<table border="0" width="100%" id="table135" cellspacing="0" cellpadding="3">
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Honorific:</font></b></td>
										<td><%call dropDownMenu("Dropdown_Honorific","DisplayValue","DPrefix","OptionName",FP_FieldVal(fp_rs,"DPrefix"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">First Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DFirstName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DFirstName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Last Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DLastName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DLastName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address1:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DAddress1" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DAddress1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address2:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DAddress2" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DAddress2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">City:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DCity" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DCity")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">State:</font></b></td>
										<td><%call dropDownMenu("Dropdown_State","DisplayValue","DState","OptionName",FP_FieldVal(fp_rs,"DState"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">County:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DCounty" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DCounty")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Zip:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DZip" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DZip")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone:</font></b></td>
										<td>
										<input NAME="DTelephone1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DTelephone1")%>"> <b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="DExt1" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"DExt1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone</font></b></td>
										<td>
										<input NAME="DTelephone2" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DTelephone2")%>"> <b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="DExt2" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"DExt2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Cell Phone:</font></b></td>
										<td>
										<input NAME="DCellPhone" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DCellPhone")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Fax:</font></b></td>
										<td>
										<input NAME="DFax1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DFax1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Email:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DEmail" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DEmail")%>"></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table136" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table137" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table138" cellspacing="0" cellpadding="5">
							<tr>
								<td width="162" align="right"><b>
								<font face="Arial" size="2">Sales 
								Representative:</font></b></td>
								<td width="380"><%call dropDownMenu("Dropdown_Sales","FullName","SalesRep","FullName",FP_FieldVal(fp_rs,"SalesRep"))%></td>
							</tr>
							<tr>
								<td width="162" align="right"><b>
								<font face="Arial" size="2">Contractor:</font></b></td>
								<td width="380"><%call dropDownMenu("Dropdown_Contractor","FullName","Contractor","FullName",FP_FieldVal(fp_rs,"Contractor"))%></td>
							</tr>
							<tr>
								<td width="162" align="right"><b>
								<font face="Arial" size="2">Bill To:</font></b></td>
								<td width="380">
								<nobr>
<select NAME="BillTo" SIZE="1">
								<option value="<%=FP_FieldHTML(fp_rs,"BillTo")%>"><%=FP_FieldHTML(fp_rs,"BillTo")%>
								</option>
								<option>Shipper</option>
								<option>Consignee</option>
								</select></nobr></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table139" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table140" cellspacing="0" cellpadding="5">
							<tr>
								<td>
								<p align="center"><b>
								<font size="2" face="Arial">Shipment Description 
								and Instructions</font></b></td>
							</tr>
							<tr>
								<td>
								<p align="center">
								<textarea rows="8" name="GeneralInstructions" cols="66"><%=FP_FieldHTML(fp_rs,"GeneralInstructions")%></textarea></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table141" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table142" cellspacing="0" cellpadding="5">
							<tr>
								<td align="center"><b>
								<font size="2" face="Arial">Origin Special 
								Instructions</font></b></td>
								<td align="center"><b>
								<font size="2" face="Arial">Destination Special 
								Instructions</font></b></td>
							</tr>
							</table>
						<table border="0" width="100%" id="table143" cellspacing="0" cellpadding="5">
							<tr>
								<td>
								<p align="center">
								<textarea rows="8" name="OriginInstructions" cols="31"><%=FP_FieldHTML(fp_rs,"OriginInstructions")%></textarea></td>
								<td>
								<p align="center">
								<textarea rows="8" name="DestInstructions" cols="31"><%=FP_FieldHTML(fp_rs,"DestInstructions")%></textarea></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table144" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table145" cellpadding="5" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Delivery:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<input NAME="DeliveryPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DeliveryPrice")%>"></td>
								<td align="right" style="border-left-width: 1px; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial01","OptionName",FP_FieldVal(fp_rs,"Accessorial01"))%><td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice01" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice01")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Pick-Up:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input NAME="PickUpPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"PickUpPrice")%>"></td>
								<td align="right">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial02","OptionName",FP_FieldVal(fp_rs,"Accessorial02"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice02" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice02")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Orig. Flights:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" style="font-size: 9pt">
								Qty: </font>
								</b>
								<input NAME="OriginFlightsQty" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"OriginFlightsQty")%>"> 
								<input NAME="OriginFlightsPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OriginFlightsPrice")%>"></td>
								<td align="right">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial03","OptionName",FP_FieldVal(fp_rs,"Accessorial03"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice03" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice03")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Del. Flights:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" style="font-size: 9pt">
								Qty: </font>
								</b>
								<input NAME="DeliveryFlightsQty" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"DeliveryFlightsQty")%>"> 
								<input NAME="DeliveryFlightsPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DeliveryFlightsPrice")%>"></td>
								<td align="right">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial04","OptionName",FP_FieldVal(fp_rs,"Accessorial04"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice04" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice04")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; border-bottom-style:solid">
								<b><font face="Arial" size="2">Addl. Miles:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; border-bottom-style:solid">
								<b><font face="Arial" style="font-size: 9pt">
								Qty: </font>
								</b>
								<input NAME="AdtlMilesQty" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"AdtlMilesQty")%>"> 
								<input NAME="AdtlMilesPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AdtlMilesPrice")%>"></td>
								<td align="right" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial05","OptionName",FP_FieldVal(fp_rs,"Accessorial05"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; border-bottom-style:solid">
								<input TYPE="TEXT" NAME="AccessorialPrice05" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice05")%>"></td>
							</tr>
						</table>
						<table border="1" width="100%" id="table148" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td> </td>
								<td width="97">
								<p align="center">
								<input TYPE="TEXT" NAME="Total" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"Total")%>"></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table149" cellspacing="0" cellpadding="0">
							<tr>
								<td> </td>
							</tr>
						</table>
						<div align="center">
							<table BORDER="0" width="454">
							<tr>
								<td>
								<p align="center">
								<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset" NAME="fp_reset"></td>
							</tr>
						</table>
						</div>
						<input type="hidden" name="ModifiedDate" value="<%=now()%>">
						<input type="hidden" name="IDShpmt" value="<%=FP_FieldHTML(fp_rs,"IDShpmt")%>">
					</form>
					<!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<p>
					 </p>
	
					</td>
				</tr>
			</table>
			</td>
		</tr>
	</table>
<p align="center"> </p>
<p align="center"> </div>
</body>

</html>


The form is submitted to my Update_Processor page. Here is the code: 

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Shipment Management System</title>
<META HTTP-EQUIV="refresh" content="2;URL=main_shipment_ent_last_record.asp">
</head>

<body topmargin="0" leftmargin="0" bgcolor="#EAEFF4">

					<div align="center">

<div align="center">
	<table border="0" width="740" id="table42" cellpadding="0" height="54" background="../../images/Header.gif" style="border-collapse: collapse" bordercolor="#638AB0">
		<tr>
			<td valign="top" style="border-left-style: solid; border-left-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px" width="446"> </td>
			<td valign="top" style="border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
			 </td>
		</tr>
	</table>
</div>
	<table border="0" width="740" id="table43" cellpadding="0" style="border-collapse: collapse" bordercolor="#638AB0" height="25">
		<tr>
			<td style="border-left-style: solid; border-left-width: 1px; border-top-width: 1px; " width="160" bgcolor="#638AB0">
			<p align="center"> </td>
			<td style="border-right-style: solid; border-right-width: 1px; border-top-width: 1px; " bgcolor="#EDEDE1" valign="bottom">
			<p align="center">
			 </p>
			</td>
		</tr>
	</table>
	<table border="0" width="740" id="table44" cellpadding="0" bgcolor="#FFFFFF" style="border-collapse: collapse" bordercolor="#638AB0" height="241">
		<tr>
			<td valign="top" style="border-style:solid; border-width:1px; " width="159" bgcolor="#EDEDE1">
			<table border="0" width="100%" id="table45" cellpadding="0" height="30" style="border-collapse: collapse" bordercolor="#638AB0">
				<tr>
					<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" bgcolor="#EAEFF4">
					<p align="center"> </td>
				</tr>
			</table>
			<p>
			 <p> </td>
			<td valign="top" style="border-style:solid; border-width:1px; ">
			<table border="0" width="100%" id="table46" cellspacing="0" cellpadding="8">
				<tr>
					<td valign="top">
					<p align="center">
					<font face="Arial" size="4" color="#878750">Contractor 
					Information Updating</font></p>
					<div align="center">

					<table border="0" width="100%" id="table47" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
						<tr>
							<td>

					 <div align="center">
						<table border="0" width="100%" id="table48" cellspacing="0" cellpadding="5">
							<tr>
								<td>
								<p align="center"><b>
								<font face="Arial" size="2">Please wait while 
								your Contact Record is updated.</font></b></td>
							</tr>
						</table>
						<table border="0" width="50%" id="table49" cellspacing="0" cellpadding="0">
							<tr>
								<td><script language="javascript" type="text/javascript">
    var SIZE=240;
    var STEP=2;
    window.onload = progress;
    function progress(){
        var bar=document.getElementById("progressbar");
        bar.style.width=(parseInt(bar.style.width)+STEP)%SIZE;
        setTimeout("progress()",40);		
    }
</script>
								<div id="progressbar" style="width:226px;height:10px;background-color:#BFCBE3">
								</div>
								</td>
							</tr>
						</table>
					</div>
					<p> </td>
						</tr>
					</table>
							</div>
					</td>
				</tr>
			</table>
			</td>
		</tr>
	</table>
</div>
					<p> </p>
					<p> </p>
					<table width="100%" border="0">
						<thead>
						</thead>
						<tbody>
							<!--#include file="../../_fpclassx/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE Query_Shipment  SET Accessorial01 = '::Accessorial01::', Accessorial02 = '::Accessorial02::', Accessorial03 = '::Accessorial03::', Accessorial04 = '::Accessorial04::', Accessorial05 = '::Accessorial05::', AccessorialPrice01 = '::AccessorialPrice01::', AccessorialPrice02 = '::AccessorialPrice02::', AccessorialPrice03 = '::AccessorialPrice03::', AccessorialPrice04 = '::AccessorialPrice04::', AccessorialPrice05 = '::AccessorialPrice05::', AdtlMilesPrice = '::AdtlMilesPrice::', AdtlMilesQty = '::AdtlMilesQty::', BillTo = '::BillTo::', DAddress1 = '::DAddress1::', DAddress2 = '::DAddress2::', DCellPhone = '::DCellPhone::', DCity = '::DCity::', DCounty = '::DCounty::', DeliveryFlightsPrice = '::DeliveryFlightsPrice::', DeliveryFlightsQty = '::DeliveryFlightsQty::', DeliveryPrice = '::DeliveryPrice::', DEmail = '::DEmail::', DestInstructions = '::DestInstructions::', DExt1 = '::DExt1::', DExt2 = '::DExt2::', DFax1 = '::DFax1::', DFirstName = '::DFirstName::', DLastName = '::DLastName::', DPrefix = '::DPrefix::', DState = '::DState::', DTelephone1 = '::DTelephone1::', DTelephone2 = '::DTelephone2::', DZip = '::DZip::', GeneralInstructions = '::GeneralInstructions::', OAddress1 = '::OAddress1::', OAddress2 = '::OAddress2::', OCellPhone = '::OCellPhone::', OCity = '::OCity::', OCounty = '::OCounty::', OEmail = '::OEmail::', OExt1 = '::OExt1::', OExt2 = '::OExt2::', OFax1 = '::OFax1::', OFirstName = '::OFirstName::', OLastName = '::OLastName::', OPrefix = '::OPrefix::', OriginFlightsPrice = '::OriginFlightsPrice::', OriginFlightsQty = '::OriginFlightsQty::', OriginInstructions = '::OriginInstructions::', OState = '::OState::', OTelephone1 = '::OTelephone1::', OTelephone2 = '::OTelephone2::', OZip = '::OZip::', PickUpPrice = '::PickUpPrice::', SalesRep = '::SalesRep::', ModifiedDate = '::ModifiedDate::'   WHERE IDShpmt = ::IDShpmt:: "
fp_sDefault="Accessorial01=&Accessorial02=&Accessorial03=&Accessorial04=&Accessorial05=&AccessorialPrice01=&AccessorialPrice02=&AccessorialPrice03=&AccessorialPrice04=&AccessorialPrice05=&AdtlMilesPrice=&AdtlMilesQty=&BillTo=&DAddress1=&DAddress2=&DCellPhone=&DCity=&DCounty=&DeliveryFlightsPrice=&DeliveryFlightsQty=&DeliveryPrice=&DEmail=&DestInstructions=&DExt1=&DExt2=&DFax1=&DFirstName=&DLastName=&DPrefix=&DState=&DTelephone1=&DTelephone2=&DZip=&GeneralInstructions=&OAddress1=&OAddress2=&OCellPhone=&OCity=&OCounty=&OEmail=&OExt1=&OExt2=&OFax1=&OFirstName=&OLastName=&OPrefix=&OriginFlightsPrice=&OriginFlightsQty=&OriginInstructions=&OState=&OTelephone1=&OTelephone2=&OZip=&PickUpPrice=&SalesRep=&ModifiedDate=&IDShpmt="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%""></td></tr>"
fp_sDataConn="sms"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&DetailTotal=3&AccessorialPrice07=3&Accessorial07=202&AccessorialPrice06=3&Accessorial06=202&AccessorialPrice05=3&Accessorial05=202&AccessorialPrice04=3&Accessorial04=202&AccessorialPrice03=3&Accessorial03=202&AccessorialPrice02=3&Accessorial02=202&AccessorialPrice01=3&Accessorial01=202&AdtlMilesPrice=3&AdtlMilesQty=202&DeliveryFlightsPrice=3&DeliveryFlightsQty=202&OriginFlightsPrice=3&OriginFlightsQty=202&PickUpPrice=3&DeliveryPrice=3&Contractor=202&SalesRep=202&BillTo=202&DestInstructions=203&OriginInstructions=203&GeneralInstructions=203&DEmail=202&DFax1=202&DCellPhone=202&DExt2=202&DTelephone2=202&DExt1=202&DTelephone1=202&DZip=202&DCounty=202&DState=202&DCity=202&DAddress2=202&DAddress1=202&DPrefix=202&DPostfix=202&DFirstName=202&DLastName=202&OEmail=202&OFax1=202&OCellPhone=202&OExt2=202&OTelephone2=202&OExt1=202&OTelephone1=202&OZip=202&OCounty=202&OState=202&OCity=202&OAddress2=202&OAddress1=202&OPrefix=202&OPostfix=202&OFirstName=202&OLastName=202&ModifiedDate=135&EnterDate=135&IDShpmt=3&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclassx/fpdbrgn1.inc"-->
<!--#include file="../../_fpclassx/fpdbrgn2.inc"-->
</tbody>
					</table>
					<p> </p>
					<p> </p>
					
</body>

</html>


This works great.

However, I want to use the same form I use to get the last record but instead select a record based on and ID field call IDShpmt. I link to the form from a simple list of shipments and the page displays the corrected shipment based on the ID. This works great.

BUT

When is submit the form to the update processor I get this error:



Database Results Error
Description: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
Number: -2147217833 (0x80040E57)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

Here is the update form: 

<html>

<%
myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("../../fpdb/sms.mdb")

FUNCTION dropDownMenu(tableName,dbFieldName,formFieldName,sortBy,selectItem)
	ddSQL = "SELECT " & dbFieldName & " FROM " & tableName & " ORDER BY " & dbFieldName & " ASC"
	set conntemp=server.createobject("adodb.connection")
	conntemp.open myDSN
	set rstemp=conntemp.execute(ddSQL)
	IF  rstemp.eof THEN
	   response.write "No records matched so cannot make menu."
	   Call CloseAll
	ELSE
		menuArray=rstemp.getrows
		Call CloseAll
		Response.write("<select size='1' name='" & formFieldName & "'>" & VbCrLf)
		FOR m = 0 TO ubound(menuArray,2)
			Response.write("<option")
			IF menuArray(0,m) = selectItem THEN
				Response.write(" selected")
			END IF
			Response.write(">" & menuArray(0,m) & "</option>" & VbCrLf)
		NEXT
		Response.write("</select>" & VbCrLf)
	END IF
END FUNCTION


SUB CloseAll
   'rstemp.close
   'set rstemp=nothing
   'conntemp.close
   'set conntemp=nothing
END SUB

%>


<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Shipment Management System</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<style href>a {text-decoration: none} </style>
<link rel="stylesheet" type="text/css" href="../../sms_bin/includes/sms_style.css">
<style fprolloverstyle>A:hover {color: #800000}
</style>
</head>

<body bgcolor="#CFDBE7" topmargin="0" leftmargin="0" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" style="text-align: center">

<div align="center">

<div align="center">
	<table border="0" width="740" id="table9" cellpadding="0" height="54" background="../../images/Header.gif" style="border-collapse: collapse" bordercolor="#638AB0">
		<tr>
			<td valign="top" style="border-left-style: solid; border-left-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px" width="446"> </td>
			<td valign="top" style="border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
			<table border="0" width="100%" id="table10" cellspacing="0" cellpadding="0">
				<tr>
					<td valign="bottom">
					<p align="center">
					<img border="0" src="../../images/entcentertext.gif" width="201" height="15"></td>
				</tr>
			</table>
			<table border="0" width="100%" id="table11" cellspacing="0" cellpadding="0">
				<tr>
					<td>
					<p align="center">
					<img border="0" src="../../images/headerline.gif" width="240" height="7"></td>
				</tr>
			</table>
			<table border="0" width="100%" id="table12" cellspacing="0" cellpadding="0" height="30" style="color: #800000">
				<tr>
					<td>
					<div align="center">
						<!-- #include file="../../sms_bin/includes/menu_title_header.htm" --></div>
					</td>
				</tr>
			</table>
			</td>
		</tr>
	</table>
</div>
	<table border="0" width="740" id="table13" cellpadding="0" style="border-collapse: collapse" bordercolor="#638AB0" height="25">
		<tr>
			<td style="border-left-style: solid; border-left-width: 1px; border-top-width: 1px; " width="160" bgcolor="#638AB0">
			<p align="center"><b><font color="#FFFFFF" size="2" face="Arial">
			<a href="../../contractor/default.asp">Main </a></font></b>
			<a href="../../contractor/default.asp"><b><font face="Arial" size="2">Page</font></b></a></td>
			<td style="border-right-style: solid; border-right-width: 1px; border-top-width: 1px; " bgcolor="#EDEDE1" valign="bottom">
			<p align="center">
			<iframe name="menu_top_admin" src="../menu_top_enterprise.htm" marginwidth="1" marginheight="1" scrolling="no" border="0" frameborder="0" width="555" height="20" target="_top">
			Your browser does not support inline frames or is currently configured not to display inline frames.
			</iframe></p>
			</td>
		</tr>
	</table>
	<table border="0" width="740" id="table2" cellpadding="0" bgcolor="#FFFFFF" style="border-collapse: collapse" bordercolor="#638AB0">
		<tr>
			<td valign="top" style="border-style:solid; border-width:1px; " width="159" bgcolor="#EDEDE1">
			<table border="0" width="100%" id="table14" cellpadding="0" height="30" style="border-collapse: collapse" bordercolor="#638AB0">
				<tr>
					<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" bgcolor="#EAEFF4">
					<p align="center"><b>
					<font face="Arial" size="2" color="#878750">Shipment Manager</font></b></td>
				</tr>
			</table>
			<p>
			<iframe name="I1" src="menu_left_shipment_ent.asp" marginwidth="1" marginheight="1" scrolling="no" border="0" frameborder="0" width="149" height="300" target="_top">
			Your browser does not support inline frames or is currently configured not to display inline frames.
			</iframe>
			<p> </td>
			<td valign="top" style="border-style:solid; border-width:1px; ">
			<table border="0" width="100%" id="table15" cellspacing="0" cellpadding="8">
				<tr>
					<td valign="top" width="50%">
					<p align="center">
					<font size="4" face="Arial" color="#878750">Latest Shipment 
					Added</font></p>
					<!--#include file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Query_Shipment WHERE (IDShpmt =  ::IDShpmt::)"
fp_sDefault="IDShpmt="
fp_sNoRecords="No records returned."
fp_sDataConn="sms"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="EnterDate"
fp_sMenuValue="EnterDate"
fp_sColTypes="&IDShpmt=3&EnterDate=135&ModifiedDate=135&OLastName=202&OFirstName=202&OPostfix=202&OPrefix=202&OAddress1=202&OAddress2=202&OCity=202&OState=202&OCounty=202&OZip=202&OTelephone1=202&OExt1=202&OTelephone2=202&OExt2=202&OCellPhone=202&OFax1=202&OEmail=202&DLastName=202&DFirstName=202&DPostfix=202&DPrefix=202&DAddress1=202&DAddress2=202&DCity=202&DState=202&DCounty=202&DZip=202&DTelephone1=202&DExt1=202&DTelephone2=202&DExt2=202&DCellPhone=202&DFax1=202&DEmail=202&GeneralInstructions=203&OriginInstructions=203&DestInstructions=203&BillTo=202&SalesRep=202&Contractor=202&DeliveryPrice=3&PickUpPrice=3&OriginFlightsQty=202&OriginFlightsPrice=3&DeliveryFlightsQty=202&DeliveryFlightsPrice=3&AdtlMilesQty=202&AdtlMilesPrice=3&Accessorial01=202&AccessorialPrice01=3&Accessorial02=202&AccessorialPrice02=3&Accessorial03=202&AccessorialPrice03=3&Accessorial04=202&AccessorialPrice04=3&Accessorial05=202&AccessorialPrice05=3&Accessorial06=202&AccessorialPrice06=3&Accessorial07=202&AccessorialPrice07=3&Total=3&"
fp_iDisplayCols=66
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<form METHOD="POST" action="main_shipment_ent_update_processor.asp">
						<table border="1" width="100%" id="table146" cellspacing="0" cellpadding="2" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td bgcolor="#EDEDE1" width="33%">
								<p align="center"><b>
								<font face="Arial" size="2" color="#547BA2">
								Shipment ID</font></b></td>
								<td bgcolor="#EDEDE1" width="33%">
								<p align="center"><b>
								<font face="Arial" size="2" color="#547BA2">
								Entry Date</font></b></td>
								<td bgcolor="#EDEDE1" width="33%">
								<p align="center"><b>
								<font face="Arial" size="2" color="#547BA2">Last 
								Modified Date</font></b></td>
							</tr>
							<tr>
								<td width="33%">
								 </td>
								<td width="33%">
								<p align="center"><font size="2" face="Arial">
								<%=FP_FieldVal(fp_rs,"EnterDate")%></font></td>
								<td width="33%">
								<p align="center"><font size="2" face="Arial">
								<%=FP_FieldVal(fp_rs,"ModifiedDate")%></font></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table147" cellspacing="0" cellpadding="0">
							<tr>
								<td> </td>
							</tr>
						</table>
						<table border="1" width="100%" id="table128" cellpadding="0" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td width="50%">
								<table border="0" width="100%" id="table129" cellpadding="3" bgcolor="#EDEDE1" style="border-collapse: collapse" bordercolor="#878750">
									<tr>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
										<p align="center">
										<font face="Arial" size="4" color="#547BA2">
										Shipper</font></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table130" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								<table border="0" width="100%" id="table131" cellspacing="0" cellpadding="3">
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Honorific:</font></b></td>
										<td><%call dropDownMenu("Dropdown_Honorific","DisplayValue","OPrefix","OptionName",FP_FieldVal(fp_rs,"OPrefix"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">First Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OFirstName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OFirstName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Last Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OLastName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OLastName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address1:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OAddress1" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OAddress1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address2:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OAddress2" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OAddress2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">City:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OCity" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OCity")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">State:</font></b></td>
										<td><%call dropDownMenu("Dropdown_State","DisplayValue","OState","OptionName",FP_FieldVal(fp_rs,"OState"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">County:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="OCounty" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"OCounty")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Zip:</font></b></td>
										<td>
										<input NAME="OZip" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OZip")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone:</font></b></td>
										<td>
										<input NAME="OTelephone1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OTelephone1")%>">
										<b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="OExt1" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"OExt1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone</font></b></td>
										<td>
										<input NAME="OTelephone2" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OTelephone2")%>">
										<b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="OExt2" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"OExt2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Cell Phone:</font></b></td>
										<td>
										<input NAME="OCellPhone" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OCellPhone")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Fax:</font></b></td>
										<td>
										<input NAME="OFax1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OFax1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Email:</font></b></td>
										<td>
										<input NAME="OEmail" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OEmail")%>"></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table132" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								</td>
								<td width="50%">
								<table border="0" width="100%" id="table133" cellpadding="3" bgcolor="#EDEDE1" style="border-collapse: collapse" bordercolor="#878750">
									<tr>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
										<p align="center">
										<font face="Arial" size="4" color="#547BA2">
										Consignee</font></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table134" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								<table border="0" width="100%" id="table135" cellspacing="0" cellpadding="3">
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Honorific:</font></b></td>
										<td><%call dropDownMenu("Dropdown_Honorific","DisplayValue","DPrefix","OptionName",FP_FieldVal(fp_rs,"DPrefix"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">First Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DFirstName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DFirstName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Last Name:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DLastName" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DLastName")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address1:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DAddress1" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DAddress1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Address2:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DAddress2" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DAddress2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">City:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DCity" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DCity")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">State:</font></b></td>
										<td><%call dropDownMenu("Dropdown_State","DisplayValue","DState","OptionName",FP_FieldVal(fp_rs,"DState"))%></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">County:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DCounty" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DCounty")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Zip:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DZip" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DZip")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone:</font></b></td>
										<td>
										<input NAME="DTelephone1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DTelephone1")%>"> <b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="DExt1" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"DExt1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Telephone</font></b></td>
										<td>
										<input NAME="DTelephone2" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DTelephone2")%>"> <b><font face="Arial" size="2">Ext:
										</font></b>
								<input NAME="DExt2" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"DExt2")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Cell Phone:</font></b></td>
										<td>
										<input NAME="DCellPhone" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DCellPhone")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Fax:</font></b></td>
										<td>
										<input NAME="DFax1" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DFax1")%>"></td>
									</tr>
									<tr>
										<td align="right"><b>
										<font face="Arial" size="2">Email:</font></b></td>
										<td>
										<input TYPE="TEXT" NAME="DEmail" SIZE="20" VALUE="<%=FP_FieldHTML(fp_rs,"DEmail")%>"></td>
									</tr>
								</table>
								<table border="0" width="100%" id="table136" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<p align="center"> </td>
									</tr>
								</table>
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table137" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table138" cellspacing="0" cellpadding="5">
							<tr>
								<td width="162" align="right"><b>
								<font face="Arial" size="2">Sales 
								Representative:</font></b></td>
								<td width="380"><%call dropDownMenu("Dropdown_Sales","FullName","SalesRep","FullName",FP_FieldVal(fp_rs,"SalesRep"))%></td>
							</tr>
							<tr>
								<td width="162" align="right"><b>
								<font face="Arial" size="2">Contractor:</font></b></td>
								<td width="380"><%call dropDownMenu("Dropdown_Contractor","FullName","Contractor","FullName",FP_FieldVal(fp_rs,"Contractor"))%></td>
							</tr>
							<tr>
								<td width="162" align="right"><b>
								<font face="Arial" size="2">Bill To:</font></b></td>
								<td width="380">
								<nobr>
<select NAME="BillTo" SIZE="1">
								<option value="<%=FP_FieldHTML(fp_rs,"BillTo")%>"><%=FP_FieldHTML(fp_rs,"BillTo")%>
								</option>
								<option>Shipper</option>
								<option>Consignee</option>
								</select></nobr></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table139" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table140" cellspacing="0" cellpadding="5">
							<tr>
								<td>
								<p align="center"><b>
								<font size="2" face="Arial">Shipment Description 
								and Instructions</font></b></td>
							</tr>
							<tr>
								<td>
								<p align="center">
								<textarea rows="8" name="GeneralInstructions" cols="66"><%=FP_FieldHTML(fp_rs,"GeneralInstructions")%></textarea></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table141" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table142" cellspacing="0" cellpadding="5">
							<tr>
								<td align="center"><b>
								<font size="2" face="Arial">Origin Special 
								Instructions</font></b></td>
								<td align="center"><b>
								<font size="2" face="Arial">Destination Special 
								Instructions</font></b></td>
							</tr>
							</table>
						<table border="0" width="100%" id="table143" cellspacing="0" cellpadding="5">
							<tr>
								<td>
								<p align="center">
								<textarea rows="8" name="OriginInstructions" cols="31"><%=FP_FieldHTML(fp_rs,"OriginInstructions")%></textarea></td>
								<td>
								<p align="center">
								<textarea rows="8" name="DestInstructions" cols="31"><%=FP_FieldHTML(fp_rs,"DestInstructions")%></textarea></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table144" cellspacing="0" cellpadding="0">
							<tr>
								<td><hr color="#878750" width="80%" size="1">
								</td>
							</tr>
						</table>
						<table border="0" width="100%" id="table145" cellpadding="5" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Delivery:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<input NAME="DeliveryPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DeliveryPrice")%>"></td>
								<td align="right" style="border-left-width: 1px; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial01","OptionName",FP_FieldVal(fp_rs,"Accessorial01"))%><td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice01" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice01")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Pick-Up:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input NAME="PickUpPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"PickUpPrice")%>"></td>
								<td align="right">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial02","OptionName",FP_FieldVal(fp_rs,"Accessorial02"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice02" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice02")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Orig. Flights:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" style="font-size: 9pt">
								Qty: </font>
								</b>
								<input NAME="OriginFlightsQty" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"OriginFlightsQty")%>"> 
								<input NAME="OriginFlightsPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"OriginFlightsPrice")%>"></td>
								<td align="right">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial03","OptionName",FP_FieldVal(fp_rs,"Accessorial03"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice03" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice03")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" size="2">Del. Flights:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<b><font face="Arial" style="font-size: 9pt">
								Qty: </font>
								</b>
								<input NAME="DeliveryFlightsQty" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"DeliveryFlightsQty")%>"> 
								<input NAME="DeliveryFlightsPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"DeliveryFlightsPrice")%>"></td>
								<td align="right">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial04","OptionName",FP_FieldVal(fp_rs,"Accessorial04"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px">
								<input TYPE="TEXT" NAME="AccessorialPrice04" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice04")%>"></td>
							</tr>
							<tr>
								<td width="90" align="right" style="border-left-style: solid; border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; border-bottom-style:solid">
								<b><font face="Arial" size="2">Addl. Miles:</font></b></td>
								<td width="200" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; border-bottom-style:solid">
								<b><font face="Arial" style="font-size: 9pt">
								Qty: </font>
								</b>
								<input NAME="AdtlMilesQty" SIZE="5" VALUE="<%=FP_FieldHTML(fp_rs,"AdtlMilesQty")%>"> 
								<input NAME="AdtlMilesPrice" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AdtlMilesPrice")%>"></td>
								<td align="right" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
								<%call dropDownMenu("Dropdown_Accessorial","DisplayValue","Accessorial05","OptionName",FP_FieldVal(fp_rs,"Accessorial05"))%></td>
								<td width="85" style="border-left-width: 1px; border-right-style: solid; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; border-bottom-style:solid">
								<input TYPE="TEXT" NAME="AccessorialPrice05" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"AccessorialPrice05")%>"></td>
							</tr>
						</table>
						<table border="1" width="100%" id="table148" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#878750">
							<tr>
								<td> </td>
								<td width="97">
								<p align="center">
								<input TYPE="TEXT" NAME="Total" SIZE="11" VALUE="<%=FP_FieldHTML(fp_rs,"Total")%>"></td>
							</tr>
						</table>
						<table border="0" width="100%" id="table149" cellspacing="0" cellpadding="0">
							<tr>
								<td> </td>
							</tr>
						</table>
						<div align="center">
							<table BORDER="0" width="454">
							<tr>
								<td>
								<p align="center">
								<input TYPE="Submit" NAME="fp_submit"><input TYPE="Reset" NAME="fp_reset"></td>
							</tr>
						</table>
						</div>
						<input type="hidden" name="IDShpmt" value="<%=FP_FieldHTML(fp_rs,"IDShpmt")%>">
					</form>
					<!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<p>
					 </p>
	
					</td>
				</tr>
			</table>
			</td>
		</tr>
	</table>
<p align="center"> </p>
<p align="center"> </div>
</body>

</html>


Here is the only difference between the two forms:


Update Last Record Form
fp_sQry="SELECT * FROM Query_Shipment WHERE ModifiedDate = (SELECT Max(ModifiedDate) FROM Query_Shipment);"

Update ID Record Form

fp_sQry="SELECT * FROM Query_Shipment WHERE (IDShpmt = ::IDShpmt::)"



To see it in action:

Update Last Record Form

http://sms.pianomove.com/enterprise/shipment_ent/main_shipment_ent_last_record.asp

This works great




Record List and update shipment based on ID

http://sms.pianomove.com/enterprise/shipment_ent/main_shipment_ent_shipment_list.asp

When you attempt to update the record, you'll get an error.

Can someone tell me what I am missing?

Allan



Spooky -> RE: Update Quesry oddity (1/14/2007 23:53:41)

The error I get suggests that the target database column does not have enough room for the data you are posting.
It would be a case of elimination to find out which it is?



vqitinc -> RE: Update Quesry oddity (1/15/2007 14:13:12)

I would normally agree, and of course have done just that. However, I copied the Last Record Form

http://sms.pianomove.com/enterprise/shipment_ent/main_shipment_ent_last_record.asp

to create the update form

http://sms.pianomove.com/enterprise/shipment_ent/main_shipment_ent_update.asp?IDShpmt=19

THe fields are exactly the same.

Both forms submit to the same update processor page: 

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Shipment Management System</title>
<META HTTP-EQUIV="refresh" content="2;URL=main_shipment_ent_last_record.asp">
</head>

<body topmargin="0" leftmargin="0" bgcolor="#EAEFF4">

					<div align="center">

<div align="center">
	<table border="0" width="740" id="table42" cellpadding="0" height="54" background="../../images/Header.gif" style="border-collapse: collapse" bordercolor="#638AB0">
		<tr>
			<td valign="top" style="border-left-style: solid; border-left-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px" width="446"> </td>
			<td valign="top" style="border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-width: 1px">
			 </td>
		</tr>
	</table>
</div>
	<table border="0" width="740" id="table43" cellpadding="0" style="border-collapse: collapse" bordercolor="#638AB0" height="25">
		<tr>
			<td style="border-left-style: solid; border-left-width: 1px; border-top-width: 1px; " width="160" bgcolor="#638AB0">
			<p align="center"> </td>
			<td style="border-right-style: solid; border-right-width: 1px; border-top-width: 1px; " bgcolor="#EDEDE1" valign="bottom">
			<p align="center">
			 </p>
			</td>
		</tr>
	</table>
	<table border="0" width="740" id="table44" cellpadding="0" bgcolor="#FFFFFF" style="border-collapse: collapse" bordercolor="#638AB0" height="241">
		<tr>
			<td valign="top" style="border-style:solid; border-width:1px; " width="159" bgcolor="#EDEDE1">
			<table border="0" width="100%" id="table45" cellpadding="0" height="30" style="border-collapse: collapse" bordercolor="#638AB0">
				<tr>
					<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" bgcolor="#EAEFF4">
					<p align="center"> </td>
				</tr>
			</table>
			<p>
			 <p> </td>
			<td valign="top" style="border-style:solid; border-width:1px; ">
			<table border="0" width="100%" id="table46" cellspacing="0" cellpadding="8">
				<tr>
					<td valign="top">
					<p align="center">
					<font face="Arial" size="4" color="#878750">Contractor 
					Information Updating</font></p>
					<div align="center">

					<table border="0" width="100%" id="table47" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
						<tr>
							<td>

					 <div align="center">
						<table border="0" width="100%" id="table48" cellspacing="0" cellpadding="5">
							<tr>
								<td>
								<p align="center"><b>
								<font face="Arial" size="2">Please wait while 
								your Contact Record is updated.</font></b></td>
							</tr>
						</table>
						<table border="0" width="50%" id="table49" cellspacing="0" cellpadding="0">
							<tr>
								<td><script language="javascript" type="text/javascript">
    var SIZE=240;
    var STEP=2;
    window.onload = progress;
    function progress(){
        var bar=document.getElementById("progressbar");
        bar.style.width=(parseInt(bar.style.width)+STEP)%SIZE;
        setTimeout("progress()",40);		
    }
</script>
								<div id="progressbar" style="width:226px;height:10px;background-color:#BFCBE3">
								</div>
								</td>
							</tr>
						</table>
					</div>
					<p> </td>
						</tr>
					</table>
							</div>
					</td>
				</tr>
			</table>
			</td>
		</tr>
	</table>
</div>
					<p> </p>
					<p> </p>
					<table width="100%" border="0">
						<thead>
						</thead>
						<tbody>
							<!--#include file="../../_fpclassx/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE Query_Shipment  SET Accessorial01 = '::Accessorial01::', Accessorial02 = '::Accessorial02::', Accessorial03 = '::Accessorial03::', Accessorial04 = '::Accessorial04::', Accessorial05 = '::Accessorial05::', AccessorialPrice01 = '::AccessorialPrice01::', AccessorialPrice02 = '::AccessorialPrice02::', AccessorialPrice03 = '::AccessorialPrice03::', AccessorialPrice04 = '::AccessorialPrice04::', AccessorialPrice05 = '::AccessorialPrice05::', AdtlMilesPrice = '::AdtlMilesPrice::', AdtlMilesQty = '::AdtlMilesQty::', BillTo = '::BillTo::', DAddress1 = '::DAddress1::', DAddress2 = '::DAddress2::', DCellPhone = '::DCellPhone::', DCity = '::DCity::', DCounty = '::DCounty::', DeliveryFlightsPrice = '::DeliveryFlightsPrice::', DeliveryFlightsQty = '::DeliveryFlightsQty::', DeliveryPrice = '::DeliveryPrice::', DEmail = '::DEmail::', DestInstructions = '::DestInstructions::', DExt1 = '::DExt1::', DExt2 = '::DExt2::', DFax1 = '::DFax1::', DFirstName = '::DFirstName::', DLastName = '::DLastName::', DPrefix = '::DPrefix::', DState = '::DState::', DTelephone1 = '::DTelephone1::', DTelephone2 = '::DTelephone2::', DZip = '::DZip::', GeneralInstructions = '::GeneralInstructions::', OAddress1 = '::OAddress1::', OAddress2 = '::OAddress2::', OCellPhone = '::OCellPhone::', OCity = '::OCity::', OCounty = '::OCounty::', OEmail = '::OEmail::', OExt1 = '::OExt1::', OExt2 = '::OExt2::', OFax1 = '::OFax1::', OFirstName = '::OFirstName::', OLastName = '::OLastName::', OPrefix = '::OPrefix::', OriginFlightsPrice = '::OriginFlightsPrice::', OriginFlightsQty = '::OriginFlightsQty::', OriginInstructions = '::OriginInstructions::', OState = '::OState::', OTelephone1 = '::OTelephone1::', OTelephone2 = '::OTelephone2::', OZip = '::OZip::', PickUpPrice = '::PickUpPrice::', SalesRep = '::SalesRep::', ModifiedDate = '::ModifiedDate::'   WHERE IDShpmt = ::IDShpmt:: "
fp_sDefault="Accessorial01=&Accessorial02=&Accessorial03=&Accessorial04=&Accessorial05=&AccessorialPrice01=&AccessorialPrice02=&AccessorialPrice03=&AccessorialPrice04=&AccessorialPrice05=&AdtlMilesPrice=&AdtlMilesQty=&BillTo=&DAddress1=&DAddress2=&DCellPhone=&DCity=&DCounty=&DeliveryFlightsPrice=&DeliveryFlightsQty=&DeliveryPrice=&DEmail=&DestInstructions=&DExt1=&DExt2=&DFax1=&DFirstName=&DLastName=&DPrefix=&DState=&DTelephone1=&DTelephone2=&DZip=&GeneralInstructions=&OAddress1=&OAddress2=&OCellPhone=&OCity=&OCounty=&OEmail=&OExt1=&OExt2=&OFax1=&OFirstName=&OLastName=&OPrefix=&OriginFlightsPrice=&OriginFlightsQty=&OriginInstructions=&OState=&OTelephone1=&OTelephone2=&OZip=&PickUpPrice=&SalesRep=&ModifiedDate=&IDShpmt="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%""></td></tr>"
fp_sDataConn="sms"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&DetailTotal=3&AccessorialPrice07=3&Accessorial07=202&AccessorialPrice06=3&Accessorial06=202&AccessorialPrice05=3&Accessorial05=202&AccessorialPrice04=3&Accessorial04=202&AccessorialPrice03=3&Accessorial03=202&AccessorialPrice02=3&Accessorial02=202&AccessorialPrice01=3&Accessorial01=202&AdtlMilesPrice=3&AdtlMilesQty=202&DeliveryFlightsPrice=3&DeliveryFlightsQty=202&OriginFlightsPrice=3&OriginFlightsQty=202&PickUpPrice=3&DeliveryPrice=3&Contractor=202&SalesRep=202&BillTo=202&DestInstructions=203&OriginInstructions=203&GeneralInstructions=203&DEmail=202&DFax1=202&DCellPhone=202&DExt2=202&DTelephone2=202&DExt1=202&DTelephone1=202&DZip=202&DCounty=202&DState=202&DCity=202&DAddress2=202&DAddress1=202&DPrefix=202&DPostfix=202&DFirstName=202&DLastName=202&OEmail=202&OFax1=202&OCellPhone=202&OExt2=202&OTelephone2=202&OExt1=202&OTelephone1=202&OZip=202&OCounty=202&OState=202&OCity=202&OAddress2=202&OAddress1=202&OPrefix=202&OPostfix=202&OFirstName=202&OLastName=202&ModifiedDate=135&EnterDate=135&IDShpmt=3&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclassx/fpdbrgn1.inc"-->
<!--#include file="../../_fpclassx/fpdbrgn2.inc"-->
</tbody>
					</table>
					<p> </p>
					<p> </p>
					
</body>

</html>


The update works when submitted from the get last record page but not from the update page.

The only difference between the two pages are the SELECT QUERYs.

Update Last Record Form:

fp_sQry="SELECT * FROM Query_Shipment WHERE ModifiedDate = (SELECT Max(ModifiedDate) FROM Query_Shipment);"

Update ID Record Form:

fp_sQry="SELECT * FROM Query_Shipment WHERE (IDShpmt = ::IDShpmt::)"


No field changes were made to the Update form. The are EXACTLY the same as the Get Last Record Form.


Weird. [:(]

Allan




Spooky -> RE: Update Quesry oddity (1/15/2007 14:28:50)

In the design of the DB, all fields allow a null input / zero length?

<edit> They do both post to the same processing page?



vqitinc -> RE: Update Quesry oddity (1/15/2007 15:04:07)

Thanks for your help but I figured it out. It was that a field length was to small. I nver noticied it because of a simple little change I made in the database.

The Prefix field (Mr. Mrs. Ms.) was orginally set to 5. Then, I learned how to create a dynamic dropdown instead of a fixed dropdown I needed to add the word Select as one of my choices. Of course this is more than 5.

Whenver I opened the Get Last page the Prefix fields already had a Prefix of the correct lenght. Of course when I used the update mage some of the records did not have the prefix selected so submit tried to add the word Select and of course this was to big.

Thank you for your time on such a dumb issue. Sometimes you just miss that little something and it creates a big deal.

I notice many times in the forum that people solve their own problems and never come back and tell what they did. There have been several times I have had an issue that someone else solved but never came back to tell. If anyone is reading this, even if you solve it, come back and tell us how.

Allan



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.1699219