Microsoft KB Archive/194441

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.