Microsoft KB Archive/167862

= FP97: IDC Query Returns No Records If Field Name Has Space =

Article ID: 167862

Article Last Modified on 11/8/2001

-

APPLIES TO


 * Microsoft FrontPage 98 Standard Edition
 * Microsoft FrontPage 97 Standard Edition
 * Microsoft FrontPage 1.0 for Macintosh

-



This article was previously published under Q167862



SUMMARY
When you use the Microsoft Internet Database Connector (IDC) features to query a data source table that has a space in the field name, the query returns no records found.

When you create a new IDC query to retrieve data from a field that contains a space in the field name, you can rename the field for the results set by using the SQL reserved word 'AS'. The following example shows how this would be used when your table contains a field called "Last Name":

SELECT "Last Name" AS LastName FROM Employees

Additional query words: 97

Keywords: kbinfo kbusage KB167862

-

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

© Microsoft Corporation. All rights reserved.