FP98: Error Performing Query in HTX File If-Then Conditional (194441)
The information in this article applies to:
- Microsoft FrontPage 98 for Windows
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
| Modification Type: | Major | Last Reviewed: | 10/3/2001 |
|---|
| Keywords: | kbhowto KB194441 |
|---|
|