update not working

G

Guest

I made a datebase update page using fp03 and that database wizard. I can
delete records and add but i can't edit. Everytime i try to edit i get this
error

The operation failed. If this continues please contact your server
administrator.

what i can do about this?
 
G

Guest

ok changed that code and tried to update the database and now get this now

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
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.

So i guess that means add something for each field right?
 
T

Thomas A. Rowe

You can't UPDATE a record until you have added the record first using the INSERT statement. So the
record must be create with an Add form prior to using an Edit form or Delete form.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
G

Guest

ok i tried adding something in each field and that didn't work. how do i fix
this

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
 
T

Thomas A. Rowe

You have to use Add form, not an Edit form.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
G

Guest

I already have a page (not made by that wizard) that adds records to the
results pages. I want to be able to edit records that are there already.
 
T

Thomas A. Rowe

Ok, you already have records in the database, you are displaying a group of records on a page, and
you want to now edit each individual record, correct?
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
G

Guest

Yes.

Thomas A. Rowe said:
Ok, you already have records in the database, you are displaying a group of records on a page, and
you want to now edit each individual record, correct?
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
Click to expand...
 
T

Thomas A. Rowe

Ok, now you need to wait for someone that use the FP database components, for help, but here is what
you need:

1. create page with an update form

2. pass the record id of the record you want to edit, to the form

3. the form page will then load the record in to the update form, so that it can be edited. You only
need to include the fields that actual want to allow to be updated.

When use hit submit, the database is updated and the user is return to the original listing of
record.



--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
G

Guest

do have any idea of what the code should look like?

or could i turn that page that adds records to an update page?
 
G

Guest

I just looked through all of pages made by that frontpage wizard there is an
edit/update page but i when i try to update the record i get this error

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
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.

and then if i add something to each field and try to update it again i get
this

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

what can i do?
 
T

Thomas A. Rowe

If using the FP database component, you have to create new page, and can't just change the FP code.

Yes, I know how to code it, but you will need to know how to code it with ASP/VBscript and not rely
on the FP database components. When you learn ASP/VBScript or other server-side scripting
technologies, you will have many more options available to you, then using any application that
write the code for you.

A good place to start learning ASP is http://www.asp101.com, look at the examples under Samples for
ASP, not ASP.net.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
G

Guest

i don't have time at the moment to learn asp. I just need to fix this problem
which seems to be a server problem or something small and stupid that i seem
to be missing.
 
S

Stefan B Rusynko

Post a snippet of your update code ( the string that builds the update query)
- or post a copy of the problem page online as say .txt unsteady of .asp so we can see the code

The update error you are getting could be because of any constraints you placed on the DB fields (in creating the DB), any field
name/type errors, or any conflicts in the data types (or content) you are passing vs the fields that are supposed to accept them
--




| i don't have time at the moment to learn asp. I just need to fix this problem
| which seems to be a server problem or something small and stupid that i seem
| to be missing.
|
| "Thomas A. Rowe" wrote:
|
| > If using the FP database component, you have to create new page, and can't just change the FP code.
| >
| > Yes, I know how to code it, but you will need to know how to code it with ASP/VBscript and not rely
| > on the FP database components. When you learn ASP/VBScript or other server-side scripting
| > technologies, you will have many more options available to you, then using any application that
| > write the code for you.
| >
| > A good place to start learning ASP is http://www.asp101.com, look at the examples under Samples for
| > ASP, not ASP.net.
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > WEBMASTER Resources(tm)
| >
| > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > ==============================================
| > To assist you in getting the best answers for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| >
| > | > > do have any idea of what the code should look like?
| > >
| > > or could i turn that page that adds records to an update page?
| > >
| > > "Thomas A. Rowe" wrote:
| > >
| > >> Ok, now you need to wait for someone that use the FP database components, for help, but here is
| > >> what
| > >> you need:
| > >>
| > >> 1. create page with an update form
| > >>
| > >> 2. pass the record id of the record you want to edit, to the form
| > >>
| > >> 3. the form page will then load the record in to the update form, so that it can be edited. You
| > >> only
| > >> need to include the fields that actual want to allow to be updated.
| > >>
| > >> When use hit submit, the database is updated and the user is return to the original listing of
| > >> record.
| > >>
| > >>
| > >>
| > >> --
| > >> ==============================================
| > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> WEBMASTER Resources(tm)
| > >>
| > >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > >> ==============================================
| > >> To assist you in getting the best answers for FrontPage support see:
| > >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > >>
| > >> | > >> > Yes.
| > >> >
| > >> > "Thomas A. Rowe" wrote:
| > >> >
| > >> >> Ok, you already have records in the database, you are displaying a group of records on a page,
| > >> >> and
| > >> >> you want to now edit each individual record, correct?
| > >> >> --
| > >> >> ==============================================
| > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> WEBMASTER Resources(tm)
| > >> >>
| > >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > >> >> ==============================================
| > >> >> To assist you in getting the best answers for FrontPage support see:
| > >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > >> >>
| > >> >> | > >> >> >I already have a page (not made by that wizard) that adds records to the
| > >> >> > results pages. I want to be able to edit records that are there already.
| > >> >> >
| > >> >> > "Thomas A. Rowe" wrote:
| > >> >> >
| > >> >> >> You have to use Add form, not an Edit form.
| > >> >> >>
| > >> >> >> --
| > >> >> >> ==============================================
| > >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > >> >> >> WEBMASTER Resources(tm)
| > >> >> >>
| > >> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > >> >> >> ==============================================
| > >> >> >> To assist you in getting the best answers for FrontPage support see:
| > >> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > >> >> >>
| > >> >> >> | > >> >> >> > ok i tried adding something in each field and that didn't work. how do i fix
| > >> >> >> > this
| > >> >> >> >
| > >> >> >> > Database Results Wizard Error
| > >> >> >> > Description: Syntax error in UPDATE statement.
| > >> >> >> > Number: -2147217900 (0x80040E14)
| > >> >> >> > Source: Microsoft JET Database Engine
| > >> >> >> >
| > >> >> >> >
| > >> >> >> >
| > >> >> >> > "alex" wrote:
| > >> >> >> >
| > >> >> >> >> ok changed that code and tried to update the database and now get this now
| > >> >> >> >>
| > >> >> >> >> Database Results Wizard Error
| > >> >> >> >> Description: Syntax error in UPDATE statement.
| > >> >> >> >> Number: -2147217900 (0x80040E14)
| > >> >> >> >> 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.
| > >> >> >> >>
| > >> >> >> >> So i guess that means add something for each field right?
| > >> >> >> >>
| > >> >> >> >> "alex" wrote:
| > >> >> >> >>
| > >> >> >> >> > I run my own servers.
| > >> >> >> >> >
| > >> >> >> >> > Kathleen
| > >> >> >> >> >
| > >> >> >> >> > I will try this and post back.
| > >> >> >> >> >
| > >> >> >> >> > "MD Websunlimited" wrote:
| > >> >> >> >> >
| > >> >> >> >> > > Hi Alex,
| > >> >> >> >> > >
| > >> >> >> >> > > Have you contacted your ISP?
| > >> >> >> >> > >
| > >> >> >> >> > >
| > >> >> >> >> > > --
| > >> >> >> >> > > Mike -- FrontPage MVP '97-'02
| > >> >> >> >> > > J-Bots 2004 102 Components For FP
| > >> >> >> >> > > http://www.websunlimited.com
| > >> >> >> >> > > FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
| > >> >> >> >> > >
| > >> >> >> >> > > | > >> >> >> >> > > >I made a datebase update page using fp03 and that database wizard. I can
| > >> >> >> >> > > > delete records and add but i can't edit. Everytime i try to edit i get this
| > >> >> >> >> > > > error
| > >> >> >> >> > > >
| > >> >> >> >> > > > The operation failed. If this continues please contact your server
| > >> >> >> >> > > > administrator.
| > >> >> >> >> > > >
| > >> >> >> >> > > > what i can do about this?
| > >> >> >> >> > >
| > >> >> >> >> > >
| > >> >> >> >> > >
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >
 
S

Stefan B Rusynko

Your problem was with Updating a DB record
- posting the code to select the record is not doing the update

According to your form the process of the update is done in edit.asp
<form method="POST" action="edit.asp">
<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
<p><input type="submit" value=" Edit " name="B1"></p></form>

The code that is giving you an update error is the code from edit.asp, not the record selection page you posted

PS
If the field ID is an autonumber field you can not update it

IMHO
If you are going to use ASP and DB (even the DRW) you will need to learn ASP enough to understand what the code is doing and how to
trouble shoot it
--




| <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>Results -- Home</title>
| <meta name="GENERATOR" content="Microsoft FrontPage 6.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="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-columntypes="3,202,202,202,203,202,202,202,202,202,135"
| s-dataconnection="Projects" b-tableformat="FALSE" b-menuformat="FALSE"
| s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE"
| i-listformat="5" b-makeform="FALSE" s-recordsource="Results"
|
s-displaycolumns="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type
,Timestamp"
| s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM Results WHERE (ID =
| ::ID::)" b-procedure="FALSE" clientside suggestedext="asp"
| s-defaultfields="ID=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"><font color="#000000">This is the start of a Database
| Results region.</font></td></tr></table>" b-usedotnet="FALSE" currentext
| sa-inputtypes="3" b-datagridformat="FALSE" b-dgridalternate="TRUE"
| sa-crittypes="3" b-wastableformat="FALSE" --><!--#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 Results WHERE (ID = ::ID::)"
| fp_sDefault="ID=0"
| fp_sNoRecords="No records returned."
| fp_sDataConn="Projects"
| fp_iMaxRecords=1
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=False
| fp_sMenuChoice="ID"
| fp_sMenuValue="ID"
|
fp_sColTypes="&ID=3&Project_Status=202&Dns_Status=202&WebSite_Name=202&Comments=203&staff_name=202&Location=202&Remote_computer_name
=202&User_name=202&Browser_type=202&Timestamp=135&"
| fp_iDisplayCols=11
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="../../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="9134" -->
| <table border="0">
| <tr>
| <td><b><font size="2">ID:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" clientside startspan
| b-makelink b-menuformat preview="&lt;font size="-1">&lt;&lt;</font>ID<font
| size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="62813" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Project_Status:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Project_Status" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1">&lt;&lt;</font>Project_Status<font size="-1">&gt;&gt;</font>"
| --><%=FP_FieldVal(fp_rs,"Project_Status")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="43305" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Dns_Status:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Dns_Status" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1">&lt;&lt;</font>Dns_Status<font size="-1">&gt;&gt;</font>"
| --><%=FP_FieldVal(fp_rs,"Dns_Status")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="31370" --></td>
| </tr>
| <tr>
| <td><b><font size="2">WebSite_Name:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="WebSite_Name" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1">&lt;&lt;</font>WebSite_Name<font size="-1">&gt;&gt;</font>"
| --><%=FP_FieldVal(fp_rs,"WebSite_Name")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="28664" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Comments:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Comments" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1">&lt;&lt;</font>Comments<font size="-1">&gt;&gt;</font>"
| --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="16369" --></td>
| </tr>
| <tr>
| <td><b><font size="2">staff_name:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="staff_name" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1">&lt;&lt;</font>staff_name<font size="-1">&gt;&gt;</font>"
| --><%=FP_FieldVal(fp_rs,"staff_name")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="32346" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Timestamp:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1">&lt;&lt;</font>Timestamp<font size="-1">&gt;&gt;</font>"
| --><%=FP_FieldVal(fp_rs,"Timestamp")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="20579" --></td>
| </tr>
| <tr>
| <td>
| <table>
| <tr>
| <td>
| <form method="POST" action="edit.asp">
| <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| <p><input type="submit" value=" Edit " name="B1"></p>
| </form>
| </td>
| <td>
| <form method="POST" action="delete.asp">
| <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| <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"><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="65064" -->
|
| </body>
|
| </html>
|
|
| "Stefan B Rusynko" wrote:
|
| > Post a snippet of your update code ( the string that builds the update query)
| > - or post a copy of the problem page online as say .txt unsteady of .asp so we can see the code
| >
| > The update error you are getting could be because of any constraints you placed on the DB fields (in creating the DB), any field
| > name/type errors, or any conflicts in the data types (or content) you are passing vs the fields that are supposed to accept them
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | i don't have time at the moment to learn asp. I just need to fix this problem
| > | which seems to be a server problem or something small and stupid that i seem
| > | to be missing.
| > |
| > | "Thomas A. Rowe" wrote:
| > |
| > | > If using the FP database component, you have to create new page, and can't just change the FP code.
| > | >
| > | > Yes, I know how to code it, but you will need to know how to code it with ASP/VBscript and not rely
| > | > on the FP database components. When you learn ASP/VBScript or other server-side scripting
| > | > technologies, you will have many more options available to you, then using any application that
| > | > write the code for you.
| > | >
| > | > A good place to start learning ASP is http://www.asp101.com, look at the examples under Samples for
| > | > ASP, not ASP.net.
| > | >
| > | > --
| > | > ==============================================
| > | > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > WEBMASTER Resources(tm)
| > | >
| > | > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > ==============================================
| > | > To assist you in getting the best answers for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | >
| > | > | > | > > do have any idea of what the code should look like?
| > | > >
| > | > > or could i turn that page that adds records to an update page?
| > | > >
| > | > > "Thomas A. Rowe" wrote:
| > | > >
| > | > >> Ok, now you need to wait for someone that use the FP database components, for help, but here is
| > | > >> what
| > | > >> you need:
| > | > >>
| > | > >> 1. create page with an update form
| > | > >>
| > | > >> 2. pass the record id of the record you want to edit, to the form
| > | > >>
| > | > >> 3. the form page will then load the record in to the update form, so that it can be edited. You
| > | > >> only
| > | > >> need to include the fields that actual want to allow to be updated.
| > | > >>
| > | > >> When use hit submit, the database is updated and the user is return to the original listing of
| > | > >> record.
| > | > >>
| > | > >>
| > | > >>
| > | > >> --
| > | > >> ==============================================
| > | > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> WEBMASTER Resources(tm)
| > | > >>
| > | > >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> ==============================================
| > | > >> To assist you in getting the best answers for FrontPage support see:
| > | > >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > >>
| > | > >> | > | > >> > Yes.
| > | > >> >
| > | > >> > "Thomas A. Rowe" wrote:
| > | > >> >
| > | > >> >> Ok, you already have records in the database, you are displaying a group of records on a page,
| > | > >> >> and
| > | > >> >> you want to now edit each individual record, correct?
| > | > >> >> --
| > | > >> >> ==============================================
| > | > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> >> WEBMASTER Resources(tm)
| > | > >> >>
| > | > >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> >> ==============================================
| > | > >> >> To assist you in getting the best answers for FrontPage support see:
| > | > >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > >> >>
| > | > >> >> | > | > >> >> >I already have a page (not made by that wizard) that adds records to the
| > | > >> >> > results pages. I want to be able to edit records that are there already.
| > | > >> >> >
| > | > >> >> > "Thomas A. Rowe" wrote:
| > | > >> >> >
| > | > >> >> >> You have to use Add form, not an Edit form.
| > | > >> >> >>
| > | > >> >> >> --
| > | > >> >> >> ==============================================
| > | > >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> >> >> WEBMASTER Resources(tm)
| > | > >> >> >>
| > | > >> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> >> >> ==============================================
| > | > >> >> >> To assist you in getting the best answers for FrontPage support see:
| > | > >> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > >> >> >>
| > | > >> >> >> | > | > >> >> >> > ok i tried adding something in each field and that didn't work. how do i fix
| > | > >> >> >> > this
| > | > >> >> >> >
| > | > >> >> >> > Database Results Wizard Error
| > | > >> >> >> > Description: Syntax error in UPDATE statement.
| > | > >> >> >> > Number: -2147217900 (0x80040E14)
| > | > >> >> >> > Source: Microsoft JET Database Engine
| > | > >> >> >> >
| > | > >> >> >> >
| > | > >> >> >> >
| > | > >> >> >> > "alex" wrote:
| > | > >> >> >> >
| > | > >> >> >> >> ok changed that code and tried to update the database and now get this now
| > | > >> >> >> >>
| > | > >> >> >> >> Database Results Wizard Error
| > | > >> >> >> >> Description: Syntax error in UPDATE statement.
| > | > >> >> >> >> Number: -2147217900 (0x80040E14)
| > | > >> >> >> >> 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.
| > | > >> >> >> >>
| > | > >> >> >> >> So i guess that means add something for each field right?
| > | > >> >> >> >>
| > | > >> >> >> >> "alex" wrote:
| > | > >> >> >> >>
| > | > >> >> >> >> > I run my own servers.
| > | > >> >> >> >> >
| > | > >> >> >> >> > Kathleen
| > | > >> >> >> >> >
| > | > >> >> >> >> > I will try this and post back.
| > | > >> >> >> >> >
| > | > >> >> >> >> > "MD Websunlimited" wrote:
| > | > >> >> >> >> >
| > | > >> >> >> >> > > Hi Alex,
| > | > >> >> >> >> > >
| > | > >> >> >> >> > > Have you contacted your ISP?
| > | > >> >> >> >> > >
| > | > >> >> >> >> > >
| > | > >> >> >> >> > > --
| > | > >> >> >> >> > > Mike -- FrontPage MVP '97-'02
| > | > >> >> >> >> > > J-Bots 2004 102 Components For FP
| > | > >> >> >> >> > > http://www.websunlimited.com
| > | > >> >> >> >> > > FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
| > | > >> >> >> >> > >
| > | > >> >> >> >> > > | > | > >> >> >> >> > > >I made a datebase update page using fp03 and that database wizard. I can
| > | > >> >> >> >> > > > delete records and add but i can't edit. Everytime i try to edit i get this
| > | > >> >> >> >> > > > error
| > | > >> >> >> >> > > >
| > | > >> >> >> >> > > > The operation failed. If this continues please contact your server
| > | > >> >> >> >> > > > administrator.
| > | > >> >> >> >> > > >
| > | > >> >> >> >> > > > what i can do about this?
| > | > >> >> >> >> > >
| > | > >> >> >> >> > >
| > | > >> >> >> >> > >
| > | > >> >> >>
| > | > >> >> >>
| > | > >> >> >>
| > | > >> >>
| > | > >> >>
| > | > >> >>
| > | > >>
| > | > >>
| > | > >>
| > | >
| > | >
| > | >
| >
| >
| >
 
G

Guest

ok here's the code from edit.asp



<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Results -- Edit</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.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="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Timestamp"
s-columntypes="3,202,202,202,203,202,202,202,202,202,135"
s-dataconnection="Projects" 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="Results"
s-displaycolumns="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Timestamp"
s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM Results WHERE ID =
::ID::" b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="ID=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"><font color="#000000">This is the start of a Database
Results region.</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 Results WHERE ID = ::ID::"
fp_sDefault="ID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Projects"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue="
fp_sColTypes="&ID=3&Project_Status=202&Dns_Status=202&WebSite_Name=202&Comments=203&staff_name=202&Location=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=11
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="60709" --> <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">Project_Status:</font></b></td>
<td>&nbsp;<!--webbot bot="Validation" s-display-name="Project_Status"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="Project_Status" size="64"
value="<%=FP_FieldHTML(fp_rs,"Project_Status")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Dns_Status:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Dns_Status"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="Dns_Status" size="64"
value="<%=FP_FieldHTML(fp_rs,"Dns_Status")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">WebSite_Name:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="WebSite_Name"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="WebSite_Name" size="64"
value="<%=FP_FieldHTML(fp_rs,"WebSite_Name")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Comments:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Comments"
s-data-type="String" b-value-required="False" i-maximum-length="0"
--><textarea rows="10" name="Comments"
cols="64"><%=FP_FieldHTML(fp_rs,"Comments")%></textarea></td>
</tr>
<tr>
<td><b><font size="2">staff_name:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="staff_name"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="staff_name" size="64"
value="<%=FP_FieldHTML(fp_rs,"staff_name")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Location:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Location"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="Location" size="64"
value="<%=FP_FieldHTML(fp_rs,"Location")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Remote_computer_name:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Remote_computer_name"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="Remote_computer_name" size="64"
value="<%=FP_FieldHTML(fp_rs,"Remote_computer_name")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">User_name:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="User_name"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="User_name" size="64"
value="<%=FP_FieldHTML(fp_rs,"User_name")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Browser_type:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Browser_type"
s-data-type="String" b-value-required="False" i-maximum-length="255"
--><input type="TEXT" name="Browser_type" size="64"
value="<%=FP_FieldHTML(fp_rs,"Browser_type")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Timestamp:</font></b></td>
<td> <!--webbot bot="Validation" s-display-name="Timestamp"
s-data-type="String" b-value-required="False" i-maximum-length="0" --><input
type="TEXT" name="Timestamp" size="19"
value="<%=FP_FieldHTML(fp_rs,"Timestamp")%>"></td>
</tr>


<tr>
<td colspan="2"><input type="submit" value=" OK "><input type="reset"
value=" Reset "></td>
</tr>

</table>

<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
</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"><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="65064" -->

</body>

</html>


Stefan B Rusynko said:
Your problem was with Updating a DB record
- posting the code to select the record is not doing the update

According to your form the process of the update is done in edit.asp
<form method="POST" action="edit.asp">
<input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
<p><input type="submit" value=" Edit " name="B1"></p></form>

The code that is giving you an update error is the code from edit.asp, not the record selection page you posted

PS
If the field ID is an autonumber field you can not update it

IMHO
If you are going to use ASP and DB (even the DRW) you will need to learn ASP enough to understand what the code is doing and how to
trouble shoot it
--




| <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>Results -- Home</title>
| <meta name="GENERATOR" content="Microsoft FrontPage 6.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="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-columntypes="3,202,202,202,203,202,202,202,202,202,135"
| s-dataconnection="Projects" b-tableformat="FALSE" b-menuformat="FALSE"
| s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE"
| i-listformat="5" b-makeform="FALSE" s-recordsource="Results"
|
s-displaycolumns="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type
,Timestamp"
| s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM Results WHERE (ID =
| ::ID::)" b-procedure="FALSE" clientside suggestedext="asp"
| s-defaultfields="ID=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"><font color="#000000">This is the start of a Database
| Results region.</font></td></tr></table>" b-usedotnet="FALSE" currentext
| sa-inputtypes="3" b-datagridformat="FALSE" b-dgridalternate="TRUE"
| sa-crittypes="3" b-wastableformat="FALSE" --><!--#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 Results WHERE (ID = ::ID::)"
| fp_sDefault="ID=0"
| fp_sNoRecords="No records returned."
| fp_sDataConn="Projects"
| fp_iMaxRecords=1
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=False
| fp_sMenuChoice="ID"
| fp_sMenuValue="ID"
|
fp_sColTypes="&ID=3&Project_Status=202&Dns_Status=202&WebSite_Name=202&Comments=203&staff_name=202&Location=202&Remote_computer_name
=202&User_name=202&Browser_type=202&Timestamp=135&"
| fp_iDisplayCols=11
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="../../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="9134" -->
| <table border="0">
| <tr>
| <td><b><font size="2">ID:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" clientside startspan
| b-makelink b-menuformat preview="&lt;font size="-1"><<</font>ID<font
| size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="62813" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Project_Status:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Project_Status" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1"><<</font>Project_Status<font size="-1">>></font>"
| --><%=FP_FieldVal(fp_rs,"Project_Status")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="43305" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Dns_Status:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Dns_Status" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1"><<</font>Dns_Status<font size="-1">>></font>"
| --><%=FP_FieldVal(fp_rs,"Dns_Status")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="31370" --></td>
| </tr>
| <tr>
| <td><b><font size="2">WebSite_Name:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="WebSite_Name" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1"><<</font>WebSite_Name<font size="-1">>></font>"
| --><%=FP_FieldVal(fp_rs,"WebSite_Name")%><!--webbot
| bot="DatabaseResultColumn" endspan i-checksum="28664" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Comments:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Comments" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1"><<</font>Comments<font size="-1">>></font>"
| --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="16369" --></td>
| </tr>
| <tr>
| <td><b><font size="2">staff_name:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="staff_name" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1"><<</font>staff_name<font size="-1">>></font>"
| --><%=FP_FieldVal(fp_rs,"staff_name")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="32346" --></td>
| </tr>
| <tr>
| <td><b><font size="2">Timestamp:</font></b></td>
| <td>
| <!--webbot bot="DatabaseResultColumn"
|
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| startspan b-makelink b-menuformat preview="<font
| size="-1"><<</font>Timestamp<font size="-1">>></font>"
| --><%=FP_FieldVal(fp_rs,"Timestamp")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="20579" --></td>
| </tr>
| <tr>
| <td>
| <table>
| <tr>
| <td>
| <form method="POST" action="edit.asp">
| <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| <p><input type="submit" value=" Edit " name="B1"></p>
| </form>
| </td>
| <td>
| <form method="POST" action="delete.asp">
| <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| <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"><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="65064" -->
|
| </body>
|
| </html>
|
|
| "Stefan B Rusynko" wrote:
|
| > Post a snippet of your update code ( the string that builds the update query)
| > - or post a copy of the problem page online as say .txt unsteady of .asp so we can see the code
| >
| > The update error you are getting could be because of any constraints you placed on the DB fields (in creating the DB), any field
| > name/type errors, or any conflicts in the data types (or content) you are passing vs the fields that are supposed to accept them
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | i don't have time at the moment to learn asp. I just need to fix this problem
| > | which seems to be a server problem or something small and stupid that i seem
| > | to be missing.
| > |
| > | "Thomas A. Rowe" wrote:
| > |
| > | > If using the FP database component, you have to create new page, and can't just change the FP code.
| > | >
| > | > Yes, I know how to code it, but you will need to know how to code it with ASP/VBscript and not rely
| > | > on the FP database components. When you learn ASP/VBScript or other server-side scripting
| > | > technologies, you will have many more options available to you, then using any application that
| > | > write the code for you.
| > | >
| > | > A good place to start learning ASP is http://www.asp101.com, look at the examples under Samples for
| > | > ASP, not ASP.net.
| > | >
| > | > --
| > | > ==============================================
| > | > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > WEBMASTER Resources(tm)
| > | >
| > | > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > ==============================================
| > | > To assist you in getting the best answers for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | >
| > | > | > | > > do have any idea of what the code should look like?
| > | > >
| > | > > or could i turn that page that adds records to an update page?
| > | > >
| > | > > "Thomas A. Rowe" wrote:
| > | > >
| > | > >> Ok, now you need to wait for someone that use the FP database components, for help, but here is
| > | > >> what
| > | > >> you need:
| > | > >>
| > | > >> 1. create page with an update form
| > | > >>
| > | > >> 2. pass the record id of the record you want to edit, to the form
| > | > >>
| > | > >> 3. the form page will then load the record in to the update form, so that it can be edited. You
| > | > >> only
| > | > >> need to include the fields that actual want to allow to be updated.
| > | > >>
| > | > >> When use hit submit, the database is updated and the user is return to the original listing of
| > | > >> record.
| > | > >>
| > | > >>
| > | > >>
| > | > >> --
| > | > >> ==============================================
| > | > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> WEBMASTER Resources(tm)
| > | > >>
| > | > >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> ==============================================
| > | > >> To assist you in getting the best answers for FrontPage support see:
| > | > >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > >>
| > | > >> | > | > >> > Yes.
| > | > >> >
| > | > >> > "Thomas A. Rowe" wrote:
| > | > >> >
| > | > >> >> Ok, you already have records in the database, you are displaying a group of records on a page,
| > | > >> >> and
| > | > >> >> you want to now edit each individual record, correct?
| > | > >> >> --
| > | > >> >> ==============================================
| > | > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> >> WEBMASTER Resources(tm)
| > | > >> >>
| > | > >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> >> ==============================================
| > | > >> >> To assist you in getting the best answers for FrontPage support see:
| > | > >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > >> >>
| > | > >> >> | > | > >> >> >I already have a page (not made by that wizard) that adds records to the
| > | > >> >> > results pages. I want to be able to edit records that are there already.
| > | > >> >> >
| > | > >> >> > "Thomas A. Rowe" wrote:
| > | > >> >> >
| > | > >> >> >> You have to use Add form, not an Edit form.
| > | > >> >> >>
| > | > >> >> >> --
| > | > >> >> >> ==============================================
| > | > >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > >> >> >> WEBMASTER Resources(tm)
| > | > >> >> >>
| > | > >> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > >> >> >> ==============================================
| > | > >> >> >> To assist you in getting the best answers for FrontPage support see:
| > | > >> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > >> >> >>
| > | > >> >> >> | > | > >> >> >> > ok i tried adding something in each field and that didn't work. how do i fix
| > | > >> >> >> > this
| > | > >> >> >> >
| > | > >> >> >> > Database Results Wizard Error
| > | > >> >> >> > Description: Syntax error in UPDATE statement.
| > | > >> >> >> > Number: -2147217900 (0x80040E14)
| > | > >> >> >> > Source: Microsoft JET Database Engine
| > | > >> >> >> >
| > | > >> >> >> >
| > | > >> >> >> >
| > | > >> >> >> > "alex" wrote:
| > | > >> >> >> >
| > | > >> >> >> >> ok changed that code and tried to update the database and now get this now
| > | > >> >> >> >>
| > | > >> >> >> >> Database Results Wizard Error
| > | > >> >> >> >> Description: Syntax error in UPDATE statement.
| > | > >> >> >> >> Number: -2147217900 (0x80040E14)
| > | > >> >> >> >> 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.
| > | > >> >> >> >>
| > | > >> >> >> >> So i guess that means add something for each field right?
| > | > >> >> >> >>
| > | > >> >> >> >> "alex" wrote:
| > | > >> >> >> >>
| > | > >> >> >> >> > I run my own servers.
| > | > >> >> >> >> >
| > | > >> >> >> >> > Kathleen
| > | > >> >> >> >> >
| > | > >> >> >> >> > I will try this and post back.
| > | > >> >> >> >> >
| > | > >> >> >> >> > "MD Websunlimited" wrote:
| > | > >> >> >> >> >
| > | > >> >> >> >> > > Hi Alex,
| > | > >> >> >> >> > >
| > | > >> >> >> >> > > Have you contacted your ISP?
| > | > >> >> >> >> > >
| > | > >> >> >> >> > >
| > | > >> >> >> >> > > --
| > | > >> >> >> >> > > Mike -- FrontPage MVP '97-'02
| > | > >> >> >> >> > > J-Bots 2004 102 Components For FP
| > | > >> >> >> >> > > http://www.websunlimited.com
| > | > >> >> >> >> > > FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
| > | > >> >> >> >> > >
| > | > >> >> >> >> > > | > | > >> >> >> >> > > >I made a datebase update page using fp03 and that database wizard. I can
| > | > >> >> >> >> > > > delete records and add but i can't edit. Everytime i try to edit i get this
| > | > >> >> >> >> > > > error
| > | > >> >> >> >> > > >
| > | > >> >> >> >> > > > The operation failed. If this continues please contact your server
| > | > >> >> >> >> > > > administrator.
| > | > >> >> >> >> > > >
| > | > >> >> >> >> > > > what i can do about this?
| > | > >> >> >> >> > >
| > | > >> >> >> >> > >
| > | > >> >> >> >> > >
| > | > >> >> >>
| > | > >> >> >>
| > | > >> >> >>
| > | > >> >>
| > | > >> >>
| > | > >> >>
| > | > >>
| > | > >>
| > | > >>
| > | >
| > | >
| > | >
| >
| >
| >
Click to expand...
 
S

Stefan B Rusynko

Frankly this is absolute nonsense
You have no Idea what you are doing if you don't know which page is doing the update and generating the error
The edit page sends to another page: update.asp
<form METHOD="POST" action="update.asp" onsubmit="return
FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">

Study what you have done, determine in what page the error is occurring and the post back to the newsgroup only w/ the specific
error from the specific page

If you had listened to Thomas 3 days ago and gone to the link he gave you them, you could have hand coded it w/o the DRW in this
time from the samples there

--




| ok here's the code from edit.asp
|
|
|
| <html>
|
| <head>
| <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| <title>Results -- Edit</title>
| <meta name="GENERATOR" content="Microsoft FrontPage 6.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="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
mestamp"
| s-columntypes="3,202,202,202,203,202,202,202,202,202,135"
| s-dataconnection="Projects" 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="Results"
|
s-displaycolumns="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type
,Timestamp"
| s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM Results WHERE ID =
| ::ID::" b-procedure="FALSE" clientside SuggestedExt="asp"
| s-DefaultFields="ID=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"><font color="#000000">This is the start of a Database
| Results region.</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 Results WHERE ID = ::ID::"
| fp_sDefault="ID=0"
| fp_sNoRecords="No records returned."
| fp_sDataConn="Projects"
| fp_iMaxRecords=1
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
|
fp_sColTypes="&ID=3&Project_Status=202&Dns_Status=202&WebSite_Name=202&Comments=203&staff_name=202&Location=202&Remote_computer_name
=202&User_name=202&Browser_type=202&Timestamp=135&"
| fp_iDisplayCols=11
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="../../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="60709" --> <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">Project_Status:</font></b></td>
| <td>&nbsp;<!--webbot bot="Validation" s-display-name="Project_Status"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="Project_Status" size="64"
| value="<%=FP_FieldHTML(fp_rs,"Project_Status")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">Dns_Status:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="Dns_Status"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="Dns_Status" size="64"
| value="<%=FP_FieldHTML(fp_rs,"Dns_Status")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">WebSite_Name:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="WebSite_Name"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="WebSite_Name" size="64"
| value="<%=FP_FieldHTML(fp_rs,"WebSite_Name")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">Comments:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="Comments"
| s-data-type="String" b-value-required="False" i-maximum-length="0"
| --><textarea rows="10" name="Comments"
| cols="64"><%=FP_FieldHTML(fp_rs,"Comments")%></textarea></td>
| </tr>
| <tr>
| <td><b><font size="2">staff_name:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="staff_name"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="staff_name" size="64"
| value="<%=FP_FieldHTML(fp_rs,"staff_name")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">Location:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="Location"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="Location" size="64"
| value="<%=FP_FieldHTML(fp_rs,"Location")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">Remote_computer_name:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="Remote_computer_name"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="Remote_computer_name" size="64"
| value="<%=FP_FieldHTML(fp_rs,"Remote_computer_name")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">User_name:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="User_name"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="User_name" size="64"
| value="<%=FP_FieldHTML(fp_rs,"User_name")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">Browser_type:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="Browser_type"
| s-data-type="String" b-value-required="False" i-maximum-length="255"
| --><input type="TEXT" name="Browser_type" size="64"
| value="<%=FP_FieldHTML(fp_rs,"Browser_type")%>" maxlength="255"></td>
| </tr>
| <tr>
| <td><b><font size="2">Timestamp:</font></b></td>
| <td> <!--webbot bot="Validation" s-display-name="Timestamp"
| s-data-type="String" b-value-required="False" i-maximum-length="0" --><input
| type="TEXT" name="Timestamp" size="19"
| value="<%=FP_FieldHTML(fp_rs,"Timestamp")%>"></td>
| </tr>
|
|
| <tr>
| <td colspan="2"><input type="submit" value=" OK "><input type="reset"
| value=" Reset "></td>
| </tr>
|
| </table>
|
| <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| </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"><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="65064" -->
|
| </body>
|
| </html>
|
|
| "Stefan B Rusynko" wrote:
|
| > Your problem was with Updating a DB record
| > - posting the code to select the record is not doing the update
| >
| > According to your form the process of the update is done in edit.asp
| > <form method="POST" action="edit.asp">
| > <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| > <p><input type="submit" value=" Edit " name="B1"></p></form>
| >
| > The code that is giving you an update error is the code from edit.asp, not the record selection page you posted
| >
| > PS
| > If the field ID is an autonumber field you can not update it
| >
| > IMHO
| > If you are going to use ASP and DB (even the DRW) you will need to learn ASP enough to understand what the code is doing and how
to
| > trouble shoot it
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | <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>Results -- Home</title>
| > | <meta name="GENERATOR" content="Microsoft FrontPage 6.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="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-columntypes="3,202,202,202,203,202,202,202,202,202,135"
| > | s-dataconnection="Projects" b-tableformat="FALSE" b-menuformat="FALSE"
| > | s-menuchoice="ID" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE"
| > | b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE"
| > | i-listformat="5" b-makeform="FALSE" s-recordsource="Results"
| > |
| >
s-displaycolumns="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type
| > ,Timestamp"
| > | s-criteria="{ID} EQ {ID} +" s-order s-sql="SELECT * FROM Results WHERE (ID =
| > | ::ID::)" b-procedure="FALSE" clientside suggestedext="asp"
| > | s-defaultfields="ID=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"><font color="#000000">This is the start of a Database
| > | Results region.</font></td></tr></table>" b-usedotnet="FALSE" currentext
| > | sa-inputtypes="3" b-datagridformat="FALSE" b-dgridalternate="TRUE"
| > | sa-crittypes="3" b-wastableformat="FALSE" --><!--#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 Results WHERE (ID = ::ID::)"
| > | fp_sDefault="ID=0"
| > | fp_sNoRecords="No records returned."
| > | fp_sDataConn="Projects"
| > | fp_iMaxRecords=1
| > | fp_iCommandType=1
| > | fp_iPageSize=0
| > | fp_fTableFormat=False
| > | fp_fMenuFormat=False
| > | fp_sMenuChoice="ID"
| > | fp_sMenuValue="ID"
| > |
| >
fp_sColTypes="&ID=3&Project_Status=202&Dns_Status=202&WebSite_Name=202&Comments=203&staff_name=202&Location=202&Remote_computer_name
| > =202&User_name=202&Browser_type=202&Timestamp=135&"
| > | fp_iDisplayCols=11
| > | fp_fCustomQuery=False
| > | BOTID=0
| > | fp_iRegion=BOTID
| > | %>
| > | <!--#include file="../../_fpclass/fpdbrgn1.inc"-->
| > | <!--webbot bot="DatabaseRegionStart" endspan i-checksum="9134" -->
| > | <table border="0">
| > | <tr>
| > | <td><b><font size="2">ID:</font></b></td>
| > | <td>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-column="ID" b-tableformat="FALSE" b-hashtml="FALSE" clientside startspan
| > | b-makelink b-menuformat preview="&lt;font size="-1"><<</font>ID<font
| > | size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"ID")%><!--webbot
| > | bot="DatabaseResultColumn" endspan i-checksum="62813" --></td>
| > | </tr>
| > | <tr>
| > | <td><b><font size="2">Project_Status:</font></b></td>
| > | <td>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-column="Project_Status" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| > | startspan b-makelink b-menuformat preview="<font
| > | size="-1"><<</font>Project_Status<font size="-1">>></font>"
| > | --><%=FP_FieldVal(fp_rs,"Project_Status")%><!--webbot
| > | bot="DatabaseResultColumn" endspan i-checksum="43305" --></td>
| > | </tr>
| > | <tr>
| > | <td><b><font size="2">Dns_Status:</font></b></td>
| > | <td>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-column="Dns_Status" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| > | startspan b-makelink b-menuformat preview="<font
| > | size="-1"><<</font>Dns_Status<font size="-1">>></font>"
| > | --><%=FP_FieldVal(fp_rs,"Dns_Status")%><!--webbot bot="DatabaseResultColumn"
| > | endspan i-checksum="31370" --></td>
| > | </tr>
| > | <tr>
| > | <td><b><font size="2">WebSite_Name:</font></b></td>
| > | <td>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-column="WebSite_Name" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| > | startspan b-makelink b-menuformat preview="<font
| > | size="-1"><<</font>WebSite_Name<font size="-1">>></font>"
| > | --><%=FP_FieldVal(fp_rs,"WebSite_Name")%><!--webbot
| > | bot="DatabaseResultColumn" endspan i-checksum="28664" --></td>
| > | </tr>
| > | <tr>
| > | <td><b><font size="2">Comments:</font></b></td>
| > | <td>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-column="Comments" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| > | startspan b-makelink b-menuformat preview="<font
| > | size="-1"><<</font>Comments<font size="-1">>></font>"
| > | --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot bot="DatabaseResultColumn"
| > | endspan i-checksum="16369" --></td>
| > | </tr>
| > | <tr>
| > | <td><b><font size="2">staff_name:</font></b></td>
| > | <td>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-column="staff_name" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| > | startspan b-makelink b-menuformat preview="<font
| > | size="-1"><<</font>staff_name<font size="-1">>></font>"
| > | --><%=FP_FieldVal(fp_rs,"staff_name")%><!--webbot bot="DatabaseResultColumn"
| > | endspan i-checksum="32346" --></td>
| > | </tr>
| > | <tr>
| > | <td><b><font size="2">Timestamp:</font></b></td>
| > | <td>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="ID,Project_Status,Dns_Status,WebSite_Name,Comments,staff_name,Location,Remote_computer_name,User_name,Browser_type,Ti
| > mestamp"
| > | s-column="Timestamp" b-tableformat="FALSE" b-hashtml="FALSE" clientside
| > | startspan b-makelink b-menuformat preview="<font
| > | size="-1"><<</font>Timestamp<font size="-1">>></font>"
| > | --><%=FP_FieldVal(fp_rs,"Timestamp")%><!--webbot bot="DatabaseResultColumn"
| > | endspan i-checksum="20579" --></td>
| > | </tr>
| > | <tr>
| > | <td>
| > | <table>
| > | <tr>
| > | <td>
| > | <form method="POST" action="edit.asp">
| > | <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| > | <p><input type="submit" value=" Edit " name="B1"></p>
| > | </form>
| > | </td>
| > | <td>
| > | <form method="POST" action="delete.asp">
| > | <input type="hidden" name="ID" value="<%=FP_FieldHTML(fp_rs,"ID")%>">
| > | <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"><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="65064" -->
| > |
| > | </body>
| > |
| > | </html>
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Post a snippet of your update code ( the string that builds the update query)
| > | > - or post a copy of the problem page online as say .txt unsteady of .asp so we can see the code
| > | >
| > | > The update error you are getting could be because of any constraints you placed on the DB fields (in creating the DB), any
field
| > | > name/type errors, or any conflicts in the data types (or content) you are passing vs the fields that are supposed to accept
them
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | i don't have time at the moment to learn asp. I just need to fix this problem
| > | > | which seems to be a server problem or something small and stupid that i seem
| > | > | to be missing.
| > | > |
| > | > | "Thomas A. Rowe" wrote:
| > | > |
| > | > | > If using the FP database component, you have to create new page, and can't just change the FP code.
| > | > | >
| > | > | > Yes, I know how to code it, but you will need to know how to code it with ASP/VBscript and not rely
| > | > | > on the FP database components. When you learn ASP/VBScript or other server-side scripting
| > | > | > technologies, you will have many more options available to you, then using any application that
| > | > | > write the code for you.
| > | > | >
| > | > | > A good place to start learning ASP is http://www.asp101.com, look at the examples under Samples for
| > | > | > ASP, not ASP.net.
| > | > | >
| > | > | > --
| > | > | > ==============================================
| > | > | > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > | > WEBMASTER Resources(tm)
| > | > | >
| > | > | > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > | > ==============================================
| > | > | > To assist you in getting the best answers for FrontPage support see:
| > | > | > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | >
| > | > | > | > | > | > > do have any idea of what the code should look like?
| > | > | > >
| > | > | > > or could i turn that page that adds records to an update page?
| > | > | > >
| > | > | > > "Thomas A. Rowe" wrote:
| > | > | > >
| > | > | > >> Ok, now you need to wait for someone that use the FP database components, for help, but here is
| > | > | > >> what
| > | > | > >> you need:
| > | > | > >>
| > | > | > >> 1. create page with an update form
| > | > | > >>
| > | > | > >> 2. pass the record id of the record you want to edit, to the form
| > | > | > >>
| > | > | > >> 3. the form page will then load the record in to the update form, so that it can be edited. You
| > | > | > >> only
| > | > | > >> need to include the fields that actual want to allow to be updated.
| > | > | > >>
| > | > | > >> When use hit submit, the database is updated and the user is return to the original listing of
| > | > | > >> record.
| > | > | > >>
| > | > | > >>
| > | > | > >>
| > | > | > >> --
| > | > | > >> ==============================================
| > | > | > >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > | > >> WEBMASTER Resources(tm)
| > | > | > >>
| > | > | > >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > | > >> ==============================================
| > | > | > >> To assist you in getting the best answers for FrontPage support see:
| > | > | > >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > >>
| > | > | > >> | > | > | > >> > Yes.
| > | > | > >> >
| > | > | > >> > "Thomas A. Rowe" wrote:
| > | > | > >> >
| > | > | > >> >> Ok, you already have records in the database, you are displaying a group of records on a page,
| > | > | > >> >> and
| > | > | > >> >> you want to now edit each individual record, correct?
| > | > | > >> >> --
| > | > | > >> >> ==============================================
| > | > | > >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > | > >> >> WEBMASTER Resources(tm)
| > | > | > >> >>
| > | > | > >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > | > >> >> ==============================================
| > | > | > >> >> To assist you in getting the best answers for FrontPage support see:
| > | > | > >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > >> >>
| > | > | > >> >> | > | > | > >> >> >I already have a page (not made by that wizard) that adds records to the
| > | > | > >> >> > results pages. I want to be able to edit records that are there already.
| > | > | > >> >> >
| > | > | > >> >> > "Thomas A. Rowe" wrote:
| > | > | > >> >> >
| > | > | > >> >> >> You have to use Add form, not an Edit form.
| > | > | > >> >> >>
| > | > | > >> >> >> --
| > | > | > >> >> >> ==============================================
| > | > | > >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | > | > >> >> >> WEBMASTER Resources(tm)
| > | > | > >> >> >>
| > | > | > >> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | > | > >> >> >> ==============================================
| > | > | > >> >> >> To assist you in getting the best answers for FrontPage support see:
| > | > | > >> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > >> >> >>
| > | > | > >> >> >> | > | > | > >> >> >> > ok i tried adding something in each field and that didn't work. how do i fix
| > | > | > >> >> >> > this
| > | > | > >> >> >> >
| > | > | > >> >> >> > Database Results Wizard Error
| > | > | > >> >> >> > Description: Syntax error in UPDATE statement.
| > | > | > >> >> >> > Number: -2147217900 (0x80040E14)
| > | > | > >> >> >> > Source: Microsoft JET Database Engine
| > | > | > >> >> >> >
| > | > | > >> >> >> >
| > | > | > >> >> >> >
| > | > | > >> >> >> > "alex" wrote:
| > | > | > >> >> >> >
| > | > | > >> >> >> >> ok changed that code and tried to update the database and now get this now
| > | > | > >> >> >> >>
| > | > | > >> >> >> >> Database Results Wizard Error
| > | > | > >> >> >> >> Description: Syntax error in UPDATE statement.
| > | > | > >> >> >> >> Number: -2147217900 (0x80040E14)
| > | > | > >> >> >> >> 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.
| > | > | > >> >> >> >>
| > | > | > >> >> >> >> So i guess that means add something for each field right?
| > | > | > >> >> >> >>
| > | > | > >> >> >> >> "alex" wrote:
| > | > | > >> >> >> >>
| > | > | > >> >> >> >> > I run my own servers.
| > | > | > >> >> >> >> >
| > | > | > >> >> >> >> > Kathleen
| > | > | > >> >> >> >> >
| > | > | > >> >> >> >> > I will try this and post back.
| > | > | > >> >> >> >> >
| > | > | > >> >> >> >> > "MD Websunlimited" wrote:
| > | > | > >> >> >> >> >
| > | > | > >> >> >> >> > > Hi Alex,
| > | > | > >> >> >> >> > >
| > | > | > >> >> >> >> > > Have you contacted your ISP?
| > | > | > >> >> >> >> > >
| > | > | > >> >> >> >> > >
| > | > | > >> >> >> >> > > --
| > | > | > >> >> >> >> > > Mike -- FrontPage MVP '97-'02
| > | > | > >> >> >> >> > > J-Bots 2004 102 Components For FP
| > | > | > >> >> >> >> > > http://www.websunlimited.com
| > | > | > >> >> >> >> > > FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
| > | > | > >> >> >> >> > >
| > | > | > >> >> >> >> > > | > | > | > >> >> >> >> > > >I made a datebase update page using fp03 and that database wizard. I can
| > | > | > >> >> >> >> > > > delete records and add but i can't edit. Everytime i try to edit i get this
| > | > | > >> >> >> >> > > > error
| > | > | > >> >> >> >> > > >
| > | > | > >> >> >> >> > > > The operation failed. If this continues please contact your server
| > | > | > >> >> >> >> > > > administrator.
| > | > | > >> >> >> >> > > >
| > | > | > >> >> >> >> > > > what i can do about this?
| > | > | > >> >> >> >> > >
| > | > | > >> >> >> >> > >
| > | > | > >> >> >> >> > >
| > | > | > >> >> >>
| > | > | > >> >> >>
| > | > | > >> >> >>
| > | > | > >> >>
| > | > | > >> >>
| > | > | > >> >>
| > | > | > >>
| > | > | > >>
| > | > | > >>
| > | > | >
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

database_editor.asp 1
DRW 1
Database editor does not change data in the database. 5
update a post in access db 1
Error when editing after importing Access Database 14
error message in FP Database editor 7
DB Wizard - cannot edit 8
Database Results Wizards Error 1

Top