Microsoft KB Archive/164280

= FP97: Error Performing Query in HTX File If-Then Conditional =

Article ID: 164280

Article Last Modified on 8/10/2001

-

APPLIES TO


 * Microsoft FrontPage 98 Standard Edition
 * Microsoft FrontPage 97 Standard Edition

-



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

Additional query words: 97

Keywords: kbhowto kbusage KB164280

-

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

© Microsoft Corporation. All rights reserved.