FP97: Error Performing Query in HTX File If-Then Conditional

Last reviewed: March 18, 1998
Article ID: Q164280

The information in this article applies to:

Microsoft FrontPage 98 for Windows
Microsoft FrontPage 97 for Windows with Bonus Pack

SYMPTOMS

When you use the Internet Database Connector (IDC) features to query a data source table where the field names begin with a number, you receive the following error message:

  Error Performing Query
  The template file contains an expression with an unrecognized
  operator. Valid operators are GT, LT, EQ and CONTAINS.

CAUSE

Field names in the If-Then Conditional section of the HTX file cannot begin with a number.

RESOLUTION

Rename the field for the results set using the SQL reserved word 'AS'. For example, to use a table field named, "900Line," rename the field as Line900:

   SELECT 900Line AS Line900 FROM Employees

Additional query words: 97
Keywords : fpodbc kbusage kbdta
Version : windows:97,98
Platform : WINDOWS
Hardware : x86
Issue type : kbhowto

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.