FP97: Error Performing Query in HTX File If-Then Conditional (164280)
The information in this article applies to:
- Microsoft FrontPage 98 for Windows
- Microsoft FrontPage 97 for Windows with Bonus Pack
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
| Modification Type: | Major | Last Reviewed: | 8/10/2001 |
|---|
| Keywords: | kbhowto kbusage KB164280 |
|---|
|