Microsoft KB Archive/175170

From BetaArchive Wiki
Knowledge Base


FP98: Error Browsing Active Server Page if Form Field Empty

Article ID: 175170

Article Last Modified on 12/1/2000



APPLIES TO

  • Microsoft FrontPage 98 Standard Edition



This article was previously published under Q175170

SYMPTOMS

When you browse an Active Server Page (ASP), you receive the following error message in the Database Region Wizard:

Database Error: [Microsoft] [ODBC Microsoft Access 97 Driver]
The SELECT statement includes a reserved word or an argument
name that is misspelled or missing, or the punctuation is incorrect.
One or more form fields were empty.

NOTE: The error message you receive will vary depending on which ODBC driver you are using.

CAUSE

This error appears if your SQL statement uses a parameter field that is populated by form data, but the form field that generates this data is unpopulated.

RESOLUTION

To resolve this problem, ensure that your form fields have been filled in before the query is submitted. To do this, use form field validation to require that the form field be filled in before it is submitted.

For more information about validating form fields, click the Index tab in FrontPage Help, type the following text

forms, validating text box fields


and then double-click the selected text to go to the "To validate a text box field" topic.


REFERENCES

For more information about the Database Region Wizard, click the Index tab in FrontPage Help, type the following text

Database Region Wizard, overview


and then double-click the selected text to go to the "Database Region Wizard" topic.

For more information about using ODBC data source files, please see the following article in the Microsoft Knowledge Base:

161155 FP97: How to Make a Web Page Display Data from a Database



Additional query words: front page

Keywords: kbprb kbusage KB175170