FP98: Unknown Field Error When Viewing Page With Database Region

Last reviewed: March 18, 1998
Article ID: Q181655
The information in this article applies to:
  • Microsoft FrontPage 98 for Windows

SYMPTOMS

When you browse to a page containing a database region, you see the following message displayed in the browser:

   Database Error: [Microsoft][ODBC Microsoft Access 97 Driver] The INSERT
   INTO statement contains the following unknown field name: 'Field1'. Make
   sure you've typed the name correctly, and try the operation again.

CAUSE

This behavior occurs when the field name you specified in the INSERT INTO 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 the INSERT INTO statement. To do this, follow these steps:

  1. Determine the correct field name in your database.

        a. Start Microsoft Access and open your database.
    

        b. Select the table you are querying and then click Design View.
    

        c. Note the name of the field you would like to query. The field name
           appears in the Field Name column.
    

        d. On the File menu, click Exit.
    

  2. Start or switch to FrontPage Editor and then open the page that contains the database region.

  3. Right-click any of the column values in your database region and then click Database Region Properties on the menu that appears.

  4. In the INSERT INTO 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:

          INSERT INTO TableName (Field1)
          Values
          ('%%Field1%%')
    

    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:

   ARTICLE-ID: Q175770
   TITLE     : FP98: How to Post Information to a Database Using ASP


Additional query words: front page
Keywords : fpactive kbdta
Version : WINDOWS:98
Platform : WINDOWS
Hardware : x86
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.