Microsoft KB Archive/194440

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

Article ID: 194440

Article Last Modified on 10/3/2001

-

APPLIES TO


 * Microsoft FrontPage 98 Standard Edition

-



This article was previously published under Q194440



For a Microsoft FrontPage 97 version of this article, see 167862.



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: 98

Keywords: kbinfo KB194440

-

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

© Microsoft Corporation. All rights reserved.