"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 (817029)

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:
   1. Click ASP.NET.
   2. Click Use an existing database connection, and then click to select your database in the database connection box.
   3. Click Next.
   4. Select your correct Record source, and then click Next.
   5. 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.
   6. Make any other changes to filter, to limit, or to sort the database results that you want.
   7. 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.