Knowledge Base

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

Article ID: 164280

Article Last Modified on 8/10/2001

Microsoft FrontPage 98 Standard Edition
Microsoft FrontPage 97 Standard Edition

This article was previously published under Q164280

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: kbhowto kbusage KB164280