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

ID: Q194441

The information in this article applies to:

Microsoft FrontPage 98 for Windows

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 : fpodbc
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbhowto