Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

"Database Results Wizard" error message when you try to change a record in your database in FrontPage 2003 or in FrontPage 2002 Service Pack 3


View products that this article applies to.

Symptoms

In Microsoft Office FrontPage 2003 or in Microsoft FrontPage 2002 Service Pack 3 (SP3), when you use the Database Editor to make changes to a database record in an Active Server Page (ASP) page that is contained in a Web site that you created by using the Database Interface Wizard, you may receive an error message that is similar to the following:
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.

See Microsoft Knowledge Base Article 817029.

↑ Back to the top


Workaround

Workaround 1

To work around this problem, you can use the Database Results Wizard to change the page to use ASP.NET.

Note You will have to have ASP.NET installed and functional to use these features. See the "More Information" section of this article for additional details about how to install ASP.NET.

To change to database region to use ASP.NET, follow these steps:
1.Open the ASP page in FrontPage.
2.On the Insert menu, point to Database, and then click Results.
3.In the Database Results Wizard dialog box, follow these steps:
a. Click ASP.NET.
b. Click Use an existing database connection, and then click to select your database in the database connection box.
c. Click Next.
d. Select your correct Record source, and then click Next.
e. If fields are missing in the list of fields for your database, click Edit List to add missing Available fields to your Displayed fields, and then click OK.
f. Make any other changes to filter, to limit, or to sort the database results that you want.
g. Click Next two times, and then click Finish.
4.You must resave the page with an .aspx file extension.

Workaround 2

To work around this problem, you can also use ASP option in the Database Results Wizard. Then, manually add the missing column names to the Webbot section of the ASP page.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To use this workaround, follow these steps:
1.Insert a new ASP page.
2.Insert a Database Results Wizard for the same database, and make sure that you select all the fields.
3.Switch to Code View.
4.Locate the following section of code.
<!--webbot bot="DatabaseRegionStart"
5.Copy the values of the s-columnnames attribute and the s-columntypes attribute.
6.Open the failing ASP page.
7.On the View menu, click Page, and then click Code at the bottom of the document window.
8.Locate the following section of code.
<!--webbot bot="DatabaseRegionStart"
9.Update the s-columnnames value to include all field names as in the following example.
s-columnnames="Expr1000,EmployeeID,FirstName"
10.Update the s-columntypes value to include all field types as in the following example.
s-columntypes="3,3,202"
11.At the bottom of the document window, click Design. This will force the update of the section of ASP code generated by the Webbot.
Note If you run the Database Results Wizard on the region again, you will lose all your changes and you must repeat these steps.

↑ Back to the top


More information

For more information about how to use ASP.NET on your Web server, click the following article number to view the article in the Microsoft Knowledge Base:
815176 How to determine whether a server meets the minimum requirements for installing the .NET Framework
For more information, visit the following MSDN Web site: For the latest .NET Framework downloads, visit the following MSDN Web site:

↑ Back to the top


Keywords: KB817029, kbprb, kbdatabase, kbctrl, kbprogramming

↑ Back to the top

Article Info
Article ID : 817029
Revision : 7
Created on : 12/14/2006
Published on : 12/14/2006
Exists online : False
Views : 400