Unable to edit certain records in the database

jerod · Mar 18, 2005

Hello all,

I'm getting a frustrating error with my database (I guess all errors are
inherently frustrating, but alas) that I created with the DRW in
FrontPage2003. I have searched the knowledge base, but have been unable to
find anything pertaining to isolated editting issues.

I am able to edit most records, and the URL field seems to work for most of
the records, but not all. It seems that I am unable to change the field at
all. It contains a working link now, and I initially thought the character
string was too long, but after trying to edit it to something shorter, it's
still not working.

Any feedback would be greatly appreciated. I have included my code for your
perusal.

Thank you in advance.

jerod

<body bgcolor="#FFFFFF">



<% 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 Key = ::Key::"
fp_sDefault="Key=0"
fp_sNoRecords="No records returned."
fp_sDataConn="whs"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Product_Name=202&URL=202&Service_Unit=202&Quantity=202&Chemical_Family=202&OEL=202&Health_Risk=202&Control_Measures_Hand=202&Control_Measures_Eye=202&Control_Measures_Respiratory=202&Control_Measures_Other=202&First_Aid_Initial_Actions=202&Spills_Cleanup=202&Flammable_Spill_Code=202&Incompatible_with=202&msdsdate=135&"
fp_iDisplayCols=17
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

 <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">Product_Name:</font></b></td>
<td> <input type="TEXT" name="Product_Name" size="64"
value="<%=FP_FieldHTML(fp_rs,"Product_Name")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">URL:</font></b></td>
<td> <input type="TEXT"
name="URL" size="64" value="<%=FP_FieldHTML(fp_rs,"URL")%>"
maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Service_Unit:</font></b></td>
<td> <input type="TEXT" name="Service_Unit" size="64"
value="<%=FP_FieldHTML(fp_rs,"Service_Unit")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Quantity:</font></b></td>
<td> <input type="TEXT" name="Quantity" size="64"
value="<%=FP_FieldHTML(fp_rs,"Quantity")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Chemical_Family:</font></b></td>
<td> <input type="TEXT" name="Chemical_Family" size="64"
value="<%=FP_FieldHTML(fp_rs,"Chemical_Family")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">OEL:</font></b></td>
<td> <input type="TEXT"
name="OEL" size="64" value="<%=FP_FieldHTML(fp_rs,"OEL")%>"
maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Health_Risk:</font></b></td>
<td> <input type="TEXT" name="Health_Risk" size="64"
value="<%=FP_FieldHTML(fp_rs,"Health_Risk")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Control_Measures_Hand:</font></b></td>
<td> <input type="TEXT" name="Control_Measures_Hand" size="64"
value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Hand")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Control_Measures_Eye:</font></b></td>
<td> <input type="TEXT" name="Control_Measures_Eye" size="64"
value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Eye")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Control_Measures_Respiratory:</font></b></td>
<td> <input type="TEXT"
name="Control_Measures_Respiratory" size="64"
value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Respiratory")%>"
maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Control_Measures_Other:</font></b></td>
<td> <input type="TEXT" name="Control_Measures_Other" size="64"
value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Other")%>"
maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">First_Aid_Initial_Actions:</font></b></td>
<td> <input type="TEXT" name="First_Aid_Initial_Actions" size="64"
value="<%=FP_FieldHTML(fp_rs,"First_Aid_Initial_Actions")%>"
maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Spills_Cleanup:</font></b></td>
<td> <input type="TEXT" name="Spills_Cleanup" size="64"
value="<%=FP_FieldHTML(fp_rs,"Spills_Cleanup")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Flammable_Spill_Code:</font></b></td>
<td> <input type="TEXT" name="Flammable_Spill_Code" size="64"
value="<%=FP_FieldHTML(fp_rs,"Flammable_Spill_Code")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">Incompatible_with:</font></b></td>
<td> <input type="TEXT" name="Incompatible_with" size="64"
value="<%=FP_FieldHTML(fp_rs,"Incompatible_with")%>" maxlength="255"></td>
</tr>
<tr>
<td><b><font size="2">msdsdate:</font></b></td>
<td> <input
type="TEXT" name="msdsdate" size="19"
value="<%=FP_FieldHTML(fp_rs,"msdsdate")%>"></td>
</tr>

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

</table>

<input type="hidden" name="Key" value="<%=FP_FieldHTML(fp_rs,"Key")%>">
</form>



<p>
<a href="../../../adminhelp.htm">Admin Help</a></p>
<p> </p>

</body>

jerod · Mar 18, 2005

Silly me...I forgot to include my generic error message:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

jerod · Mar 18, 2005

My apologies for not including this in my first post (I wish I could edit my
posts).

It seems that I can't touch that record at all...changing any of the other
fields is impossible.

jerod

Kathleen Anderson [MVP - FrontPage] · Mar 18, 2005

Key is a reserved word in SQL - rename the field.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

Stefan B Rusynko · Mar 19, 2005

PS
and to see the true errors, open the hidden folder /_fpclass/ and edit the fpdbrgn1.inc file

At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True

| Key is a reserved word in SQL - rename the field.
|
| --
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| blog: http://msmvps.com/spiderwebwoman/category/321.aspx
|
|
|
| | > Hello all,
| >
| > I'm getting a frustrating error with my database (I guess all errors are
| > inherently frustrating, but alas) that I created with the DRW in
| > FrontPage2003. I have searched the knowledge base, but have been unable to
| > find anything pertaining to isolated editting issues.
| >
| > I am able to edit most records, and the URL field seems to work for most
| > of
| > the records, but not all. It seems that I am unable to change the field at
| > all. It contains a working link now, and I initially thought the character
| > string was too long, but after trying to edit it to something shorter,
| > it's
| > still not working.
| >
| > Any feedback would be greatly appreciated. I have included my code for
| > your
| > perusal.
| >
| > Thank you in advance.
| >
| > jerod
| >
| >
| > <body bgcolor="#FFFFFF">
| > 
| >
| > 
| > <% 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 Key = ::Key::"
| > fp_sDefault="Key=0"
| > fp_sNoRecords="No records returned."
| > fp_sDataConn="whs"
| > fp_iMaxRecords=1
| > fp_iCommandType=1
| > fp_iPageSize=0
| > fp_fTableFormat=False
| > fp_fMenuFormat=False
| > fp_sMenuChoice=""
| > fp_sMenuValue=""
| >
fp_sColTypes="&Key=3&Product_Name=202&URL=202&Service_Unit=202&Quantity=202&Chemical_Family=202&OEL=202&Health_Risk=202&Control_Measures_Hand=202&Control_Measures_Eye=202&Control_Measures_Respiratory=202&Control_Measures_Other=202&First_Aid_Initial_Actions=202&Spills_Cleanup=202&Flammable_Spill_Code=202&Incompatible_with=202&msdsdate=135&"
| > fp_iDisplayCols=17
| > fp_fCustomQuery=False
| > BOTID=0
| > fp_iRegion=BOTID
| > %>
| > 
| >  <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">Product_Name:</font></b></td>
| > <td> <input type="TEXT" name="Product_Name" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Product_Name")%>" maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">URL:</font></b></td>
| > <td> <input type="TEXT"
| > name="URL" size="64" value="<%=FP_FieldHTML(fp_rs,"URL")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Service_Unit:</font></b></td>
| > <td> <input type="TEXT" name="Service_Unit" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Service_Unit")%>" maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Quantity:</font></b></td>
| > <td> <input type="TEXT" name="Quantity" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Quantity")%>" maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Chemical_Family:</font></b></td>
| > <td> <input type="TEXT" name="Chemical_Family" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Chemical_Family")%>" maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">OEL:</font></b></td>
| > <td> <input type="TEXT"
| > name="OEL" size="64" value="<%=FP_FieldHTML(fp_rs,"OEL")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Health_Risk:</font></b></td>
| > <td> <input type="TEXT" name="Health_Risk" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Health_Risk")%>" maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Control_Measures_Hand:</font></b></td>
| > <td> <input type="TEXT" name="Control_Measures_Hand" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Hand")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Control_Measures_Eye:</font></b></td>
| > <td> <input type="TEXT" name="Control_Measures_Eye" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Eye")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Control_Measures_Respiratory:</font></b></td>
| > <td> <input type="TEXT"
| > name="Control_Measures_Respiratory" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Respiratory")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Control_Measures_Other:</font></b></td>
| > <td> <input type="TEXT" name="Control_Measures_Other" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Control_Measures_Other")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">First_Aid_Initial_Actions:</font></b></td>
| > <td> <input type="TEXT" name="First_Aid_Initial_Actions" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"First_Aid_Initial_Actions")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Spills_Cleanup:</font></b></td>
| > <td> <input type="TEXT" name="Spills_Cleanup" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Spills_Cleanup")%>" maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Flammable_Spill_Code:</font></b></td>
| > <td> <input type="TEXT" name="Flammable_Spill_Code" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Flammable_Spill_Code")%>"
| > maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">Incompatible_with:</font></b></td>
| > <td> <input type="TEXT" name="Incompatible_with" size="64"
| > value="<%=FP_FieldHTML(fp_rs,"Incompatible_with")%>" maxlength="255"></td>
| > </tr>
| > <tr>
| > <td><b><font size="2">msdsdate:</font></b></td>
| > <td> <input
| > type="TEXT" name="msdsdate" size="19"
| > value="<%=FP_FieldHTML(fp_rs,"msdsdate")%>"></td>
| > </tr>
| >
| >
| > <tr>
| > <td colspan="2"><input type="submit" value=" OK "><input
| > type="reset"
| > value=" Reset "></td>
| > </tr>
| >
| > </table>
| >
| > <input type="hidden" name="Key" value="<%=FP_FieldHTML(fp_rs,"Key")%>">
| > </form>
| >
| > 
| > 
| > <p>
| > <a href="../../../adminhelp.htm">Admin Help</a></p>
| > <p> </p>
| >
| > </body>
| >
| >
| >
|
|

jerod · Mar 21, 2005

The debug option helped a LOT.

I got this error:

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Field
'Results.Quantity' cannot be a zero-length string.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers

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

Upon adding a value to Quantity, the databse updates fine.

Now, is this problem related to the "Key" issue put forth by Kathleen? Or is
it another value somewhere that's messing things up. Obviously the record can
be created without a value there, it just can't be updated.

Thank you again in advance.

jerod

jerod · Mar 21, 2005

Nevermind, found it here

http://support.microsoft.com/default.aspx?scid=kb;en-us;256136

Thanks again for your help, ladies and gents.

jerod

Adding a date to a form confirmation page	3	Jul 29, 2009
editing database with frontpage	1	Feb 23, 2008
I am trying to understand this code...	3	Jul 26, 2008
editing database with results wizard	1	Feb 23, 2008
form and confirmation not working	1	Mar 1, 2009
File upload into database doesn't work	2	Jan 23, 2008
Help with this calculation!!!	17	Oct 19, 2006
FP Database help needed...	6	Oct 18, 2005

Unable to edit certain records in the database

jerod

jerod

jerod

Kathleen Anderson [MVP - FrontPage]

Stefan B Rusynko

jerod

jerod

Ask a Question

Similar Threads