Microsoft KB Archive/229300

= FP2000: Syntax Error in Database Region When Using a Less Than Comparison =

Article ID: 229300

Article Last Modified on 10/1/2001

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q229300



SYMPTOMS
After you use the Database Results Wizard to insert a database region and you specify criteria or a file name that uses a "less-than" comparison, the following error message may appear:

Database Results Error

Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error

(missing operator) in query expression '(CategoryID < 34)>'.

Number: -2147217900 (0x80040E14)

Source: Microsoft OLE DB Provider for ODBC Drivers

NOTE: The stated error message may vary based on your actual database and the query you are using. However, the error message will contain the phrase "(missing operator) in query expression."



CAUSE
When you use a "less-than" comparison, FrontPage may not write the proper SQL syntax.



RESOLUTION
To resolve this issue, use one of the following methods.

You Are Not Using a Custom Query
If you are not using a custom query, follow these steps:
 * 1) Open the page in Page view of FrontPage.
 * 2) Double-click one of the yellow regions to start the Database Results Wizard.
 * 3) In the wizard, do not make any changes. Click Next four times, and then click Finish.
 * 4) Save the page.

You Are Using a Custom Query
You notice extra characters have been added to the end of your custom SQL statement. Usually, only an extra greater than sign is added (>). You need to modify the statement to remove the extra characters.

In most cases, just remove the "greater-than" sign at the end of your SQL statement in step 2 and then complete the wizard.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: front page

Keywords: kbbug kbpending KB229300

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.