Database Results Wizard Error

John · Feb 3, 2004

Am using Win2K, IIS5 and FP2k3

Am suddenly receiving this error on a database search results page:

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

This occurs on my local test site (localhost) and the online site has
inherited the problem when I last published. Must have something to do with
the settings in IIS5 but I'm fairly clueless when it comes to that program.

John

Kathleen Anderson [MVP - FP] · Feb 3, 2004

Edit the file fpdbrgn1.inc (in the _fpclass folder) and set fp_DEBUG = True
and then try again and tell us what the error message is.

John · Feb 5, 2004

Kathleen

This is the code for the page which has been creating problems since around
Tuesday last week. Strange thing is that the page wasn't touched, but the
UKDate seems to be creating a problem all of a sudden.

Maybe I'm paranoid, but didn't Microsoft issue a new patch around the same
time?

<START-CODE>

<td>Select Year: </td>
</tr>
<tr>
<td>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>UKDate</b></th>
<th ALIGN="LEFT"><b>Key</b></th>
<th ALIGN="LEFT"><b>LongHeadline</b></th>
</tr>
</thead>
<tbody>

<% 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 format(StoryDate, 'dd/mm/yyyy') AS UKDate, Key, LongHeadline
FROM Results WHERE (FullStory LIKE '%::FullStory::%') ORDER BY StoryDate
DESC"
fp_sDefault="FullStory="
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No records
returned. You may want to refine your search terms.</td></tr>"
fp_sDataConn="news"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=20
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="UKDate"
fp_sMenuValue="UKDate"
fp_sColTypes="&UKDate=202&Key=3&LongHeadline=202&"
fp_iDisplayCols=3
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"UKDate")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Key")%></td>
<td>
<%=FP_FieldVal(fp_rs,"LongHeadline")%></td>
</tr>

</tbody>
</table>
</td>

</END-CODE>

I made the change you specified and the Error message it gives is as
follows:

Database Results Wizard Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing
s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

Thanks

John

Kathleen Anderson [MVP - FP] · Feb 5, 2004

John:
Please try this workaround and let us know if it works (or not):

There is an issue in the way the code is parsed to determine valid field
names in the data view.

To work around this problem, modify the ASP script in the asp page of your
Web site. To do this, follow these steps:
1. Open the asp in Frontpage 2003 and switch to Code View
2. On the "Edit" menu, click "Find".
3. In the "Find what" box, type "fp_sColTypes" (without the quotation
marks), and then click "Find Next".
4. Type a trailing ampersand (&) inside the closing quotation marks. For
example, the fp_sColTypes line should now look exactly like the following
example:
<fp_sColTypes="&name=value&name=value&name=value&">
5. On the "File" menu, click "Save"

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

John said:
Kathleen

This is the code for the page which has been creating problems since
around Tuesday last week. Strange thing is that the page wasn't
touched, but the UKDate seems to be creating a problem all of a
sudden.

Maybe I'm paranoid, but didn't Microsoft issue a new patch around the
same time?

<START-CODE>

<td>Select Year: </td>
</tr>
<tr>
<td>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>UKDate</b></th>
<th ALIGN="LEFT"><b>Key</b></th>
<th ALIGN="LEFT"><b>LongHeadline</b></th>
</tr>
</thead>
<tbody>
 <% 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 format(StoryDate, 'dd/mm/yyyy') AS UKDate, Key,
LongHeadline FROM Results WHERE (FullStory LIKE '%::FullStory::%')
ORDER BY StoryDate DESC"
fp_sDefault="FullStory="
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No
records returned. You may want to refine your search terms.</td></tr>"
fp_sDataConn="news"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=20
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="UKDate"
fp_sMenuValue="UKDate"
fp_sColTypes="&UKDate=202&Key=3&LongHeadline=202&"
fp_iDisplayCols=3
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr> <td>
<%=FP_FieldVal(fp_rs,"UKDate")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Key")%></td>
<td>
<%=FP_FieldVal(fp_rs,"LongHeadline")%></td>
</tr>

</tbody> </table>
</td>

</END-CODE>

I made the change you specified and the Error message it gives is as
follows:

Database Results Wizard Error
Your page contains a query with user input parameters that could not
be resolved.
This could happen if your DatabaseRegionStart webbot has an empty or
missing s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

Thanks

John

Kathleen Anderson said:

Edit the file fpdbrgn1.inc (in the _fpclass folder) and set fp_DEBUG
= True and then try again and tell us what the error message is.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Click to expand...

dave · Mar 31, 2004

Replace the current includes (in the _fpclass directory) with the ones from
FP 2000/2

Paul E Bushnell said:
Kathleen,

I tried your suggestion:

"Edit the file fpdbrgn1.inc (in the _fpclass folder) and set fp_DEBUG = True
and then try again and tell us what the error message is."

I see no difference in the error message.

Sincerely,
Paul E Bushnell

----- Kathleen Anderson [MVP - FP] wrote: -----

Edit the file fpdbrgn1.inc (in the _fpclass folder) and set fp_DEBUG = True
and then try again and tell us what the error message is.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

John said:

Am using Win2K, IIS5 and FP2k3
The operation failed. If this continues, please contact your server
administrator. has
inherited the problem when I last published. Must have something to
do with the settings in IIS5 but I'm fairly clueless when it comes to
that program.

Click to expand...

Guest · Mar 31, 2004

Problem Description: RE: ERROR MESSAGE "The operation failed. If this continues, please contact your server administrator.

IF YOU SEARCH MSN SEARCH ON THE ABOVE ERROR STRING, YOU WILL FIND 5599 SITES THAT ARE EXPERIENCING THE SAME PROBLEM AS I AM FOLLOWING INSTALLATION OF SP3 FOR OFFICE XP.

Guest · Mar 31, 2004

Problem Description: RE: ERROR MESSAGE "The operation failed. If this continues, please contact your server administrator.

NOW CHECK THIS

I TOOK A COPY OF THE FILE "fpdbrgn1.inc" FROM THE FOLDER "_fpclass" FROM A WEB THAT I HAD STORED ON MY HARD DISK LAST YEAR AND COPIED IT TO THE SAME FOLDER ON THE WEB SERVER OF ONE OF MY WEBS THAT HAS BEEN EXPERIENCING THE ERROR - AND GUESS WHAT??? ALL QUERIES WORK AGAIN!!!

WHAT DO YOU ALL MAKE OF THAT????

dave · Apr 2, 2004

Go figure - thats what I told you to do in the first place....

Paul E Bushnell said:
Problem Description: RE: ERROR MESSAGE "The operation failed. If this

continues, please contact your server administrator."

NOW CHECK THIS!

I TOOK A COPY OF THE FILE "fpdbrgn1.inc" FROM THE FOLDER "_fpclass" FROM A

WEB THAT I HAD STORED ON MY HARD DISK LAST YEAR AND COPIED IT TO THE SAME
FOLDER ON THE WEB SERVER OF ONE OF MY WEBS THAT HAS BEEN EXPERIENCING THE
ERROR - AND GUESS WHAT??? ALL QUERIES WORK AGAIN!!!!

kamy882 · Dec 27, 2007

I Edit The File Fpdbrgn1.Inc And Set Fp_DEBUG = True (What " Kathleen Anderson [MVP - FP]" Said) And Now Error Message Is:

Description: Syntax Error (Missing Operator) In Query Expression '&#1606'.
Number: -2147217900 (0x80040e14)
Source: Microsoft JET Database Engine

Now (About Four Years After Beginning This Thread !!!) Is There Anyone To Help Me?

Database Results Wizard Error

John

Kathleen Anderson [MVP - FP]

John

Kathleen Anderson [MVP - FP]

dave

Guest

Guest

dave

kamy882