Update Data Error (Full Version)

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



Message

styrochem -> 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 -> RE: Update Data Error (5/18/2004 9:29:02)

Can you post the UPDATE code you're using?



styrochem -> 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 -> 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



rdouglass -> 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?



styrochem -> 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 -> RE: Update Data Error (5/18/2004 10:57:47)

Where is the friendly error setting in Frontpage?



rbr1317 -> 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 -> 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?



styrochem -> RE: Update Data Error (5/18/2004 11:21:53)

Same error....everything looks accurate.



rbr1317 -> 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?



styrochem -> 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 -> 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 -> RE: Update Data Error (5/18/2004 11:54:35)

Should I create a new form or just replace it with this script?



rbr1317 -> RE: Update Data Error (5/18/2004 11:58:31)

I would just replace the code in the DRW - custom query area.



styrochem -> RE: Update Data Error (5/18/2004 12:06:04)

[:@] This is starting to push my patience... I do have a new error message now. Page cannot be displayed. Here are the details

Technical Information (for support personnel)

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/Purchase_Orders_interface/tblPurchaseOrders_Minton_PO1/editor/update.asp, line 31, column 35


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

Page:
POST 175 bytes to /Purchase_Orders_interface/tblPurchaseOrders_Minton_PO1/editor/update.asp

POST Data:
Classification_Type=Electrical&Requestor=J+Greer&Vendor=CDW%2C+Inc.&Created_Date=5%2F14%2F2004&NotToExceed=8500&EnteredBy=W+Cowan&Field8=No&POStatus=Open&PurchaseOrder=8112360

Time:
Tuesday, May 18, 2004, 10:55:14 AM


More information:
Microsoft Support



styrochem -> 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 -> 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. [8|]



rdouglass -> 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.[8D]



styrochem -> 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 -> 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?



styrochem -> 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 -> 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.



BeTheBall -> RE: Update Data Error (5/18/2004 14:41:36)

So have your read Microsoft Knowledge Base Article 817029?

If your host supports ASP.NET, you might be best off following the instructions in the article.

Seems MS is going to force FP users to migrate to .NET whether they want to or not. [:@]



styrochem -> 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 -> RE: Update Data Error (5/18/2004 14:45:49)

But I don't think .NET is an option for us.



BeTheBall -> 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?



styrochem -> 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 -> 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.



styrochem -> 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>



Page: [1] 2   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625