Microsoft KB Archive/175170

= 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.

