FP98: Error Browsing Active Server Page if Form Field Empty (175170)
The information in this article applies to:
- Microsoft FrontPage 98 for Windows
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
| Modification Type: | Major | Last Reviewed: | 12/1/2000 |
|---|
| Keywords: | kbprb kbusage KB175170 |
|---|
|