Article ID: 907307 - View products that this article applies to.
Consider the following scenario. You upgrade Microsoft FrontPage 2002 to Microsoft Front Page 2002 Service Pack 3 (SP3) or to Microsoft Office FrontPage 2003. You open an active server page (ASP) page that was created by using the Database Results Wizard. You save the ASP page. In this scenario, you may receive the following error message when you browse the ASP page:
Additionally, if you set the fp_DEBUG value to True in the Fpdbrgn1.inc file in the _fpclass folder, you receive the following error message when you browse the ASP page:
Database Results Wizard Error The operation failed. If this continues, please contact your server administrator.
Note This behavior also occurs if you browse an ASP page that was created by using the Database Results Wizard in FrontPage 2003.
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. One or more form fields were empty. You should provide default values for all form fields that are used in the query.
This behavior occurs when you use a custom SQL query that has parameters in the Database Results Wizard.
This problem occurs because the .inc files are updated when you upgrade to FrontPage 2002 SP3 or to FrontPage 2003. After the .inc files are updated, the custom SQL queries that have parameters are no longer processed by these .inc files.
Note This problem occurs only if the parameter in the custom SQL query is outside the WHERE clause.
To resolve this problem, obtain the latest service pack for Microsoft Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
887616After you install Microsoft Office 2003 SP2, you have to reopen and save each ASP page that was created by using the Database Results Wizard. When you save the ASP page, the .inc files will be rewritten.
(http://support.microsoft.com/kb/887616/ )Description of Office 2003 Service Pack 2
The .inc files are include files that are generated by the FrontPage Database Results Wizard. The .inc files are saved in the _fpclass folder of a Web site. The .inc files contain all the database functionality. Editing the .inc files is not supported in FrontPage.
The following list describes three common .inc files:
The following text shows examples of valid queries against a database.
Note All FrontPage parameterized custom queries should follow the CLAUSE + (Column name + Operator + ::parameter::) format. All existing queries that do not follow this format cannot be authored by using the FrontPage Database Results Wizard. If you use the correct syntax and still receive the "The custom query contains errors" error, make sure that the case of the field names in the query matches the case of the field names in the tables.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/871267/ )You receive an "Unable to find operator in query string" error message when you use the ORDER BY parameter in a custom SQL query in FrontPage 2003