FP98: Error Browsing Active Server Page if Form Field Empty

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q175170

Expand all | Collapse all

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.

Back to the top

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.

Back to the top

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.

Back to the top

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 (http://support.microsoft.com/kb/161155/EN-US/ ) FP97: How to Make a Web Page Display Data from a Database

Back to the top

APPLIES TO

Microsoft FrontPage 98 Standard Edition

Back to the top

kbprb kbusage KB175170

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top