|
| |
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
 |
Update Data Error - 5/18/2004 8:08:17
My webforms are able to create and delete records from an MS Access database with no problem. Yet when I attempt to update an record I receive error "Database Results Error
The operation failed. If this continues, please contact your server administrator." I tried Spooky's changing the settings from False to True but still no results. Can someone help me out?
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Update Data Error - 5/18/2004 9:29:02
Can you post the UPDATE code you're using?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 9:48:35
<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,Requestor,Vendor,Date,NotToExceed,EnteredBy,EnteredIntoManMan?,POStatus" s-columntypes="3,202,202,202,135,3,202,11,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 = '::Classification::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Date = '::Date::' , NotToExceed = ::NotToExceed:: , EnteredBy = '::EnteredBy::' , EnteredIntoManMan? = ::Field8:: , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Classification=&Requestor=&Vendor=&Date=&NotToExceed=0&EnteredBy=&Field8=0&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 = '::Classification::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Date = '::Date::' , NotToExceed = ::NotToExceed:: , EnteredBy = '::EnteredBy::' , EnteredIntoManMan? = ::Field8:: , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)"
fp_sDefault="Classification=&Requestor=&Vendor=&Date=&NotToExceed=0&EnteredBy=&Field8=0&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=202&Requestor=202&Vendor=202&Date=135&NotToExceed=3&EnteredBy=202&EnteredIntoManMan?=11&POStatus=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="40917" -->
<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>
| |
|
|
|
rbr1317
Posts: 49
Joined: 3/31/2004
From: Kent, Wa
Status: offline
|
RE: Update Data Error - 5/18/2004 10:31:53
First I would put your code on the Spooky Diet.
Next I would probably not use Date as a field name in your db. Call it a name date_updated Or what ever makes sense.
Try this: (Modify the date_updated to whatever you want to call the field but don't use just date)
"UPDATE tblPurchaseOrders_Minton_PO SET Classification = '::Classification::',Requestor='::Requestor::',Vendor ='::Vendor::',Date_updated ='::Date_updated::',NotToExceed ='::NotToExceed::',EnteredBy='::EnteredBy::', EnteredIntoManMan = '::Field8::',POStatus = '::POStatus::' WHERE PurchaseOrder='::PurchaseOrder::'"
Rob
< Message edited by rbr1317 -- 5/18/2004 10:36:48 >
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Update Data Error - 5/18/2004 10:49:49
Yes, what Rob said, but also be sure of your delimiters. If you're using Access and it is a Date/Time field, be sure to use #s and I think Classification might be a reserved word so surround it w/ brackets:
"UPDATE tblPurchaseOrders_Minton_PO SET [Classification] = '::Classification::',Requestor='::Requestor::',Vendor ='::Vendor::',Date_updated =#::Date_updated::#,NotToExceed ='::NotToExceed::',EnteredBy='::EnteredBy::', EnteredIntoManMan = '::Field8::',POStatus = '::POStatus::' WHERE PurchaseOrder='::PurchaseOrder::'"
If you're still getting errors, be sure to turn freindly errors off to get the true error messages. That any help?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 10:56:29
No go on those fixes. Went back and changed the field names on both date and classification. Date field is set to Date/Time and Classification is set to Text. Anymore ideas?
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 10:57:47
Where is the friendly error setting in Frontpage?
| |
|
|
|
rbr1317
Posts: 49
Joined: 3/31/2004
From: Kent, Wa
Status: offline
|
RE: Update Data Error - 5/18/2004 11:16:21
I would also verify that the field names in the SQL are exactly what is in the db.
Also, check the field names on your form are correct as in your update sql. The field name field8... Is that still by that name on your form?
Just sending you some ideas...
Rob
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Update Data Error - 5/18/2004 11:18:03
quote:
Where is the friendly error setting in Frontpage?
It's not in FrontPage. If you're using IE, it's under InternetOptions:Advanced.
What is the exact error message now? Is it the same one? (the hokey one about contacting administrator?)
You should NOT use 'Date' as a field name - if you MUST then be sure and put [ and ] around the field name like [Date].
Without a specific error message, one thing I can suggest is to verify all your field types and delimiters:
Datefield = #::DateField::#
Textfield = '::TextField::'
Numberfield = ::NumberField::
Also, if you're trying to update the record with blank/null fields, be sure the Access fields are setup to allow null entries.
That get you any closer? If not,an you repost just the SQL line you're using again and what your Access fields are defined as?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 11:21:53
Same error....everything looks accurate.
| |
|
|
|
rbr1317
Posts: 49
Joined: 3/31/2004
From: Kent, Wa
Status: offline
|
RE: Update Data Error - 5/18/2004 11:30:13
Repost like rdouglas says:
quote:
That get you any closer? If not,an you repost just the SQL line you're using again and what your Access fields are defined as?
< Message edited by rbr1317 -- 5/18/2004 11:31:00 >
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 11:36:21
Field Names:
PurchaseOrder = Autonumber
Classification_Type = Text
Requestor = Text
Vendor = Text
Created_Date = Text
NotToExceed = Text
EnteredBy = Text
EnteredIntoManMan = Text
POStatus = Text
SQL Statement = (I would use the spooky diet but I am not that knowledgable in ASP and it would have to be redone on many pages)
fp_sQry="UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan? = '::Field8::' , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)"
| |
|
|
|
rbr1317
Posts: 49
Joined: 3/31/2004
From: Kent, Wa
Status: offline
|
RE: Update Data Error - 5/18/2004 11:44:04
Try pasting this into the DRW.
UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan = '::Field8::' , POStatus = '::POStatus::' WHERE PurchaseOrder = ::PurchaseOrder::
I am not sure why the ? after EnteredIntoManMan and the () around PurchaseOrder...
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 11:54:35
Should I create a new form or just replace it with this script?
| |
|
|
|
rbr1317
Posts: 49
Joined: 3/31/2004
From: Kent, Wa
Status: offline
|
RE: Update Data Error - 5/18/2004 11:58:31
I would just replace the code in the DRW - custom query area.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 12:08:52
Here is the page code again:
<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_Date,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_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan? = '::Field8::' , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Classification_Type=&Requestor=&Vendor=&Created_Date=&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 %>
<%
UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan = '::Field8::' , POStatus = '::POStatus::' WHERE PurchaseOrder = ::PurchaseOrder::
fp_sDefault="Classification_Type=&Requestor=&Vendor=&Created_Date=&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_Date=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 -->
<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 -->
</body>
</html>
| |
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Update Data Error - 5/18/2004 12:36:08
Hmmm. How did that happen?
Normally, in Frontpage, your SQL statement will look like this:
fp_sQry="UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan = '::Field8::' , POStatus = '::POStatus::' WHERE PurchaseOrder = ::PurchaseOrder:: "
I have no idea how the fp_sQry part disappeared. As far as the Spooky Diet goes, you do not have to apply it to every page. I have some pages that have been "dieted" and others that haven't. You can apply it to this one page and no others. However, getting the fp_sQry part back in should at least get you a different error message. 
_____________________________
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.
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Update Data Error - 5/18/2004 12:42:26
quote:
...
<%
UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan = '::Field8::' , POStatus = '::POStatus::' WHERE PurchaseOrder = ::PurchaseOrder::
fp_sDefault="Classification_Type=&Requestor=&Vendor=&Created_Date=&NotToExceed=&EnteredBy=&EnteredIntoManMan?=&POStatus=&PurchaseOrder=0"
...
If that really is the code currently in your DRW, then something broke. In a DRW, the query (AFAIK) has to be in an fp_sQry= line. It should really look something like this:
...
<%
fp_sQry="UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan = '::Field8::' , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)"
fp_sDefault="Classification_Type=&Requestor=&Vendor=&Created_Date=&NotToExceed=&EnteredBy=&EnteredIntoManMan?=&POStatus=&PurchaseOrder=0"
...
Don't know why it broke, but if it were me, I'd create a new clean DRW and put this code into the custom query:
UPDATE tblPurchaseOrders_Minton_PO SET Classification_Type = '::Classification_Type::' , Requestor = '::Requestor::' , Vendor = '::Vendor::' , Created_Date = '::Created_Date::' , NotToExceed = '::NotToExceed::' , EnteredBy = '::EnteredBy::' , EnteredIntoManMan = '::Field8::' , POStatus = '::POStatus::' WHERE (PurchaseOrder = ::PurchaseOrder::)
and see what happens. Like I said, if that IS the code that is on your page, something in the DRW is broke and it's usually far better to create a new one.
Hope it helps.
EDIT: Boy, I type way too sloooow.
< Message edited by rdouglass -- 5/18/2004 12:43:30 >
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 13:39:17
Here is what I did. I rebuilt the page using the Frontpage wizard with the SQL stated correctly entered as above but now the operation failed error is showing up again.
| |
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Update Data Error - 5/18/2004 14:09:15
Post the code for the entire DRW code (both the gray and red).
quote:
I tried Spooky's changing the settings from False to True but still no results.
That is not supposed to be a fix, per se, but a way to make the page display a more concise error message.
Are you using FP 2003?
_____________________________
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/18/2004 14:19:16
Error Messages:
Frontpage 2000-
Current with revised SQL Statement:
Database Results Error
The operation failed. If this continues, please contact your server administrator.
With Revision from False to True statement:
Database Results Error
Your page contains a query with user input parameters that could not be resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 14:27:52
I followed the wizard steps and it did not resolve the problem. Just gave an database ODBC error. Gonna follow the manual steps next.
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 14:42:59
Yes....the steps gave me the following error:
Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
| |
|
|
|
styrochem
Posts: 212
Joined: 5/11/2004
Status: offline
|
RE: Update Data Error - 5/18/2004 14:45:49
But I don't think .NET is an option for us.
| |
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Update Data Error - 5/18/2004 14:53:02
OK, so you manually added the s-columnnames and s-columntypes? Why don't you post the code for the entire page in case there is something else that may be missing?
_____________________________
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/18/2004 14:55:21
You mean extract all of the page code and post it to fpdbrgn1 file? Is there an area I would post it? I am not a programmer by any means.
| |
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Update Data Error - 5/18/2004 14:58:11
No, I mean copy the HTML of the page and paste it here in this topic so we can see what it looks like now. We have had you make so many changes that it might help if we see what the code of your page looks like now.
_____________________________
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/18/2004 15:01:34
This is the latest version:
<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>
| |
|
 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 
This is starting to push my patience... I do have a new error message now. Page cannot be displayed. Here are the details