navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Database Update Problem

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Database Update Problem 		Page: [1]
 
steveg

 

Posts: 274
Joined: 10/20/2004
Status: offline

  		Database Update Problem - 6/25/2008 5:30:14   
I have done this a few times before but I guess I must be missing something this time!!

I am getting a database update error message:

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

Here is the code for the update form (where I do my editing) 
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' 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>New Page 1</title>
</head>

<body>

<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,ItemPosition,ItemDate,ItemTitle,ItemContent,ItemActive,Remote_computer_name,User_name,Browser_type,Timestamp" s-columntypes="3,202,202,202,203,202,202,202,202,135" s-dataconnection="walker" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="7" b-makeform="TRUE" s-recordsource="Results" s-displaycolumns="ID,ItemPosition,ItemDate,ItemTitle,ItemContent,ItemActive" s-criteria s-order s-sql="SELECT * FROM Results" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="1" botid="0" u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan --><!--#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"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="walker"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=1
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&ItemPosition=202&ItemDate=202&ItemTitle=202&ItemContent=203&ItemActive=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="16271" --><form METHOD="POST" action="update.asp">
  <p>
  <!--webbot bot="PurpleText" preview="Set this form's properties so it submits user input to the appropriate page." --></p>
  <table BORDER="0">
    <tr>
      <td><b>ID:</b></td>
      <td>
      <input TYPE="TEXT" NAME="ID" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"></td>
    </tr>
    <tr>
      <td><b>ItemPosition:</b></td>
      <td>
      <input TYPE="TEXT" NAME="ItemPosition" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"ItemPosition")%>"></td>
    </tr>
    <tr>
      <td><b>ItemDate:</b></td>
      <td>
      <input TYPE="TEXT" NAME="ItemDate" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"ItemDate")%>"></td>
    </tr>
    <tr>
      <td><b>ItemTitle:</b></td>
      <td>
      <input TYPE="TEXT" NAME="ItemTitle" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"ItemTitle")%>"></td>
    </tr>
    <tr>
      <td><b>ItemContent:</b></td>
      <td>
      <input TYPE="TEXT" NAME="ItemContent" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"ItemContent")%>"></td>
    </tr>
    <tr>
      <td><b>ItemActive:</b></td>
      <td>
      <input TYPE="TEXT" NAME="ItemActive" SIZE="40" VALUE="<%=FP_FieldHTML(fp_rs,"ItemActive")%>"></td>
    </tr>
    <tr>
      <td COLSPAN="2"><br>
      <input TYPE="submit" NAME="fp_submit" value="Update"><input TYPE="Reset" NAME="fp_reset"></td>
    </tr>
  </table>
</form>
<hr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="1" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/1]</NOBR><BR></td></tr></table>" startspan --><!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></body></html>


Here is the code for the update file (to post the data to the database) 
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' 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>New Page 1</title>
</head>

<body>

<table width="100%" border="1">
  <thead>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes s-dataconnection="walker" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource s-displaycolumns s-criteria s-order s-sql="UPDATE RESULTS<br>SET ItemTitle='%%ItemTitle%%',<br>ItemContent='%%ItemContent%%',<br>ItemDate='%%ItemDate%%',<br>ItemActive='%%ItemActive%%',<br>ItemPosition='%%ItemPosition%%'<br>WHERE ID='%%ID%%'<br>" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE RESULTS SET ItemTitle='%%ItemTitle%%', ItemContent='%%ItemContent%%', ItemDate='%%ItemDate%%', ItemActive='%%ItemActive%%', ItemPosition='%%ItemPosition%%' WHERE ID='%%ID%%' "
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=16 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="walker"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="54952" --><!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></tbody>
</table>

</body>

</html>


I asume that it is something really stupid but I am just not seeing it.

Steve

pd_it_guy

 

Posts: 139
Joined: 3/4/2008
Status: offline

  		RE: Database Update Problem - 6/25/2008 9:56:05   
A very look shows:

'%%value%%' when expected would be '::value::'

Is this FP generated or user generated.

Perhaps others may see something else. The % is part of the <% demarc for code, perhaps you can also use it in a variable but I have not seen it.


(in reply to steveg)
steveg

 

Posts: 274
Joined: 10/20/2004
Status: offline

  		RE: Database Update Problem - 6/25/2008 10:16:02   
I probably should have changed that. I originally had the ::????:: and then in desperation Microsoft Support article Q240090 showed %%???%%. In desperation I tried it but have now changed back to ::???::

It would appear that all elements work well until the updating of the database. Then I get the message in the yellow box. Is there any way to be able to get something more informative than the yellow error message box?

Steve

(in reply to pd_it_guy)
pd_it_guy

 

Posts: 139
Joined: 3/4/2008
Status: offline

  		RE: Database Update Problem - 6/25/2008 10:35:12   
See what happens when you get rid of all the gray code EXCEPT for the 3 critical include files and their encasing verbiage within the <!.....> brackets. Should not see any 'do not edits' and 'bots' if it is pure essentialized code which for an update page makes sense. There may be something in the gray area that is causing problems.

<!........fpdblib> (at the start, BEFORE the query block)
<!........fpdbrgn1> (after the query block)
<!........fpdbrgn2> (at the end, can be the very next line down)

That should make things MUCH easier to see.


(in reply to steveg)
pd_it_guy

 

Posts: 139
Joined: 3/4/2008
Status: offline

  		RE: Database Update Problem - 6/25/2008 13:28:16   
OOPS I just thought of something else.

The variable 'ID' I presume, is a sequential record number, is it not, and thus, a numeric variable.

Try recovering thus: ::ID:: not '::ID::' Doing it with a quote will cause trouble. At least it caused me many wasted hours running down the problem. Can't give you a better explanation except it just seems to work that way. And I would have to guess that any other specifically declared numeric doesn't like the single quotes when you pull them out to write to the DB.

Good Luck. Hope we provided some ideas.

(in reply to steveg)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Database Update Problem 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.