FP98: Error Performing Query in HTX File If-Then Conditional
Article ID: 194441
Article Last Modified on 10/3/2001
APPLIES TO
- Microsoft FrontPage 98 Standard Edition
This article was previously published under Q194441
For a Microsoft FrontPage 97 version of this article, see
164280.
SUMMARY
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.
Field names in the If-Then Conditional section of the HTX file cannot
begin with a number.
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: 98
Keywords: kbhowto KB194441