FP98: Too Few Parameters Error Previewing Page w/Database Region (181209)


The information in this article applies to:

  • Microsoft FrontPage 98 for Windows
This article was previously published under Q181209

SYMPTOMS

When you preview a page that contains a database region, you may see the following error message in the Web browser:
Database Error: [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.

CAUSE

This behavior occurs when the field name you specified in your SELECT statement does not exist in the database being queried. Most often this happens if you have mistyped the query.

RESOLUTION

To resolve this behavior, you must specify the correct field name in your SELECT statement. To do this, follow these steps:
  1. Determine the correct field name in your database.

    1. Start Microsoft Access and open your database.
    2. Select the table you are querying and then click Design View.
    3. Note the name of the field you would like to query. The field name appears in the Field Name column.
    4. On the File menu, click Exit.
  2. Start FrontPage Editor and open the page that contains the database region.
  3. Right-click any column value in the database region and then click Database Region Properties on the menu that appears.
  4. In the SELECT statement, type the name of the field you noted in step 1 For example, if the field name is Field1, type your query like this:

    SELECT Field1 from TABLE

    NOTE: Your query may be different depending on the name of your table and the number of fields you are querying.
  5. Click Finish.
  6. On the File menu, click Save.

MORE INFORMATION

For additional information, please see the following article in the Microsoft Knowledge Base:

175771 FP98: How to Display Contents of a Database Using ASP

Modification Type:MajorLast Reviewed:12/1/2000
Keywords:kbprb KB181209
©2002 Microsoft Corporation. All rights reserved.