|
| |
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
 |
RE: Update Data Error - 5/18/2004 15:24:57
Sorry to keep answering questions with questions, but what error message does the above generate (With Revision from False to True statement)?
Also, what does the page that takes the user to the UPDATE page look like? Can you post the HTML code for the Update form?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
|
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/19/2004 7:51:33
I appreciate all the help I can get...so no problem reposting just hope I explain this well. It initially opens with the following page which has two panes... The top one lists the Purchase Order Numbers and you click on them and they are then displayed in the lower pane. You can click edit which brings up the form that allows a record to be modified and its when submit is clicked on the update form which causes the error. I think I would write this entire page myself manually if I understood ASP more. But I did attempt this same task on another table in the database that manages PO's and had the same results.
The error message says:Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
Initial Screen - Upper Pane
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>tblPurchaseOrders_Minton_PO -- List</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<script Language="JavaScript"><!--
var sAction = "form";
var NoRecordsChecked = true;
function OnClickBtn( el )
{
if( el.name != "form_list" )
{
if( el.value == "Add New Record" )
{
document.form_list.target = "detail";
document.form_list.action = "new.asp";
sAction = "btn"
}
else if( el.value == "Delete Selected Records" )
{
for (i=0;i<document.form_list.elements.length;i++)
{
if (document.form_list.elements.checked)
{
NoRecordsChecked = false;
}
}
if (NoRecordsChecked)
{
sAction = "form";
alert("Select the records you wish to delete and then choose Delete Selected Records.");
return;
}
document.form_list.target = "detail";
document.form_list.action = "delete.asp";
sAction = "btn"
}
}
else
{
if( sAction != "btn" )
{
document.form_list.target = "_self";
document.form_list.action = "list.asp";
}
sAction = "form";
}
}
-->
</script>
<table width="100%" align=left>
<tr>
<td width="50%">
<b><font size=+3 color="#000080"> Database Editor - <i>tblPurchaseOrders_Minton_PO</i></font></b>
</td>
<td width="50%" align=right>
<table>
<tr>
<td>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br clear=all>
<form name="form_list" target="_self" action="list.asp" method="POST" OnClick="OnClickBtn(this)">
<table>
<td>
<p><input name="btnAction" type="submit" value="Add New Record" OnClick="OnClickBtn(this)"></p>
</td>
<td>
<p><input name="btnAction" type="submit" value="Delete Selected Records" OnClick="OnClickBtn(this)"></p>
</td>
</table>
<hr>
<table border="0">
<thead>
<tr>
<td></td>
<td bgcolor="black"><font color="white" size="2"><b>PurchaseOrder</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>Classification_Type</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>Requestor</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>Vendor</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>Created</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>NotToExceed</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>EnteredBy</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>EnteredIntoManMan?</b></font></td>
<td bgcolor="black"><font color="white" size="2"><b>POStatus</b></font></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus," s-columntypes="3,202,202,202,202,202,202,202,202," s-dataconnection="Purchase_Orders" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0" b-makeform="TRUE" s-RecordSource="tblPurchaseOrders_Minton_PO" s-displaycolumns="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-criteria s-order s-sql="SELECT * FROM tblPurchaseOrders_Minton_PO ORDER BY PurchaseOrder ASC" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="5" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="TBODY" startspan BOTID="0" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr>" --><!--#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 tblPurchaseOrders_Minton_PO ORDER BY PurchaseOrder ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=9 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Purchase_Orders"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PurchaseOrder=3&Classification_Type=202&Requestor=202&Vendor=202&Created=202&NotToExceed=202&EnteredBy=202&EnteredIntoManMan?=202&POStatus=202&"
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="8371" -->
<tr>
<td><input type="checkbox" name="<%=FP_FieldURL(fp_rs,"PurchaseOrder")%>" value="ON"></td>
<td><a href="detail.asp?PurchaseOrder=<%=FP_FieldURL(fp_rs,"PurchaseOrder")%>" target="detail">
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="PurchaseOrder" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>PurchaseOrder<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"PurchaseOrder")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36299" --></a></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Classification_Type" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Classification_Type<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Classification_Type")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="56183" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Requestor" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Requestor<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Requestor")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20407" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Vendor" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Vendor<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Vendor")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15399" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Created" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Created<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Created")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13698" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="NotToExceed" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>NotToExceed<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"NotToExceed")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29721" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="EnteredBy" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>EnteredBy<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"EnteredBy")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19390" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="EnteredIntoManMan?" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>EnteredIntoManMan?<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"EnteredIntoManMan?")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="50776" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="POStatus" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>POStatus<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"POStatus")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13141" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside Tag="TBODY" startspan preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</tbody>
</table>
</form>
</body>
</html>
Initial Screen - Lower Pane
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>tblPurchaseOrders_Minton_PO -- Home</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work. If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
<!--webbot bot="DatabaseRegionStart" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-columntypes="3,202,202,202,202,202,202,202,202" s-dataconnection="Purchase_Orders" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE" i-ListFormat="5" b-makeform="FALSE" s-RecordSource="tblPurchaseOrders_Minton_PO" s-displaycolumns="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-criteria="{PurchaseOrder} EQ {PurchaseOrder} +" s-order s-sql="SELECT * FROM tblPurchaseOrders_Minton_PO WHERE PurchaseOrder = ::PurchaseOrder::" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="PurchaseOrder=0" s-NoRecordsFound="No records returned." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" --><!--#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 tblPurchaseOrders_Minton_PO WHERE PurchaseOrder = ::PurchaseOrder::"
fp_sDefault="PurchaseOrder=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Purchase_Orders"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PurchaseOrder=3&Classification_Type=202&Requestor=202&Vendor=202&Created=202&NotToExceed=202&EnteredBy=202&EnteredIntoManMan?=202&POStatus=202&"
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14609" -->
<table BORDER=0>
<tr>
<td><b><font size="2">PurchaseOrder:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="PurchaseOrder" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>PurchaseOrder<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"PurchaseOrder")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36299" --></td>
</tr><tr>
<td><b><font size="2">Classification_Type:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Classification_Type" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Classification_Type<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Classification_Type")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="56183" --></td>
</tr><tr>
<td><b><font size="2">Requestor:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Requestor" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Requestor<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Requestor")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20407" --></td>
</tr><tr>
<td><b><font size="2">Vendor:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Vendor" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Vendor<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Vendor")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15399" --></td>
</tr><tr>
<td><b><font size="2">Created:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="Created" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>Created<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Created")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13698" --></td>
</tr><tr>
<td><b><font size="2">NotToExceed:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="NotToExceed" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>NotToExceed<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"NotToExceed")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29721" --></td>
</tr><tr>
<td><b><font size="2">EnteredBy:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="EnteredBy" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>EnteredBy<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"EnteredBy")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19390" --></td>
</tr><tr>
<td><b><font size="2">EnteredIntoManMan?:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="EnteredIntoManMan?" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>EnteredIntoManMan?<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"EnteredIntoManMan?")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="50776" --></td>
</tr><tr>
<td><b><font size="2">POStatus:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-column="POStatus" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1"><<</font>POStatus<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"POStatus")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13141" --></td>
</tr>
<tr><td><table>
<tr>
<td>
<form method="POST" action="edit.asp?PurchaseOrder=<%=FP_FieldURL(fp_rs,"PurchaseOrder")%>">
<p><input type="submit" value=" Edit " name="B1"></p>
</form>
</td>
<td>
<form method="POST" action="delete.asp?PurchaseOrder=<%=FP_FieldURL(fp_rs,"PurchaseOrder")%>">
<p><input type="submit" value="Delete" name="B1"></p>
</form>
</td>
</tr>
</table></td></tr>
</table>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
Screen that appears when you click on a PO number in the upper pane.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>tblPurchaseOrders_Minton_PO -- Edit</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work. If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
<!--webbot bot="DatabaseRegionStart" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-columntypes="3,202,202,202,202,202,202,202,202" s-dataconnection="Purchase_Orders" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE" i-ListFormat="5" b-makeform="FALSE" s-RecordSource="tblPurchaseOrders_Minton_PO" s-displaycolumns="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-criteria="{PurchaseOrder} EQ {PurchaseOrder} +" s-order s-sql="SELECT * FROM tblPurchaseOrders_Minton_PO WHERE PurchaseOrder = ::PurchaseOrder::" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="PurchaseOrder=0" s-NoRecordsFound="No records returned." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" --><!--#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 tblPurchaseOrders_Minton_PO WHERE PurchaseOrder = ::PurchaseOrder::"
fp_sDefault="PurchaseOrder=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Purchase_Orders"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PurchaseOrder=3&Classification_Type=202&Requestor=202&Vendor=202&Created=202&NotToExceed=202&EnteredBy=202&EnteredIntoManMan?=202&POStatus=202&"
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14609" --> <form METHOD="POST" action="update.asp" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
<table BORDER=0>
<tr>
<td><b><font size="2">Classification_Type:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Classification_Type" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="Classification_Type" size="50" value="<%=FP_FieldHTML(fp_rs,"Classification_Type")%>" maxlength="50"></td>
</tr>
<tr>
<td><b><font size="2">Requestor:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Requestor" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="Requestor" size="50" value="<%=FP_FieldHTML(fp_rs,"Requestor")%>" maxlength="50"></td>
</tr>
<tr>
<td><b><font size="2">Vendor:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Vendor" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="Vendor" size="50" value="<%=FP_FieldHTML(fp_rs,"Vendor")%>" maxlength="50"></td>
</tr>
<tr>
<td><b><font size="2">Created:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Created" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="Created" size="50" value="<%=FP_FieldHTML(fp_rs,"Created")%>" maxlength="50"></td>
</tr>
<tr>
<td><b><font size="2">NotToExceed:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="NotToExceed" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="NotToExceed" size="50" value="<%=FP_FieldHTML(fp_rs,"NotToExceed")%>" maxlength="50"></td>
</tr>
<tr>
<td><b><font size="2">EnteredBy:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="EnteredBy" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="EnteredBy" size="50" value="<%=FP_FieldHTML(fp_rs,"EnteredBy")%>" maxlength="50"></td>
</tr>
<tr>
<td><b><font size="2">EnteredIntoManMan?:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Field8" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="Field8" size="50" value="<%=FP_FieldHTML(fp_rs,"EnteredIntoManMan?")%>" maxlength="50"></td>
</tr>
<tr>
<td><b><font size="2">POStatus:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="POStatus" s-data-type="String" b-value-required="False" i-maximum-length="50" --><input type="TEXT" name="POStatus" size="50" value="<%=FP_FieldHTML(fp_rs,"POStatus")%>" maxlength="50"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value=" OK "><input type="reset" value=" Reset "></td>
</tr>
</table>
<input type="hidden" name="PurchaseOrder" value="<%=FP_FieldHTML(fp_rs,"PurchaseOrder")%>">
</form>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
Window that you update record in and submit to database but provides error.
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>tblPurchaseOrders_Minton_PO -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work. If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
<script Language="JavaScript">
<!--
top.list.location.href = top.list.location.href;
// -->
</script>
<!--webbot bot="DatabaseRegionStart" s-columnnames="PurchaseOrder,Classification_Type,Requestor,Vendor,Created,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-columntypes="3,202,202,202,202,202,202,202,202" s-dataconnection="Purchase_Orders" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource s-displaycolumns s-criteria s-order s-sql="UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created = '::Created::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan? = '::Field8::' , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Classification_Type=&Requestor=&Vendor=&Created=&NotToExceed=&EnteredBy=&EnteredIntoManMan?=&POStatus=&PurchaseOrder=0" s-NoRecordsFound="Record updated in table." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" --><!--#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="UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created = '::Created::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan? = '::Field8::' , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)"
fp_sDefault="Classification_Type=&Requestor=&Vendor=&Created=&NotToExceed=&EnteredBy=&EnteredIntoManMan?=&POStatus=&PurchaseOrder=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="Purchase_Orders"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&PurchaseOrder=3&Classification_Type=202&Requestor=202&Vendor=202&Created=202&NotToExceed=202&EnteredBy=202&EnteredIntoManMan?=202&POStatus=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="7917" -->
<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
| |
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Update Data Error - 5/19/2004 9:11:10
I think someone mentioned this earlier in this thread, but you cannot have a "?" as part of a field name. You will need to go into the database and change the name of "EnteredIntoManMan?" to just "EnteredIntoManMan". Then, it may be easier to recreate your pages rather than change the field name in the existing ones as FP will try to undo everything you try and change.
I copied your pages into my web and used your form to create a db with the same field names. The update threw an error until I got rid of the "?".
Once I changed the field name in the db and fixed the pages, this SQL worked perfectly:
fp_sQry="UPDATE Results SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created = '::Created::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan = '::Field8::' , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)"
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/19/2004 12:46:13
Thanks for all of your help...I had to recreate the tables and forms for it to start working. But it appears the question marks may have been the cause in addition to a database setting that was set to No on Activated Unicode Compression.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
