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

 Last reviewed: March 18, 1998
Article ID: Q167862
The information in this article applies to:
  • Microsoft FrontPage 98 for Windows
  • Microsoft FrontPage 97 for Windows with Bonus Pack
  • Microsoft FrontPage for Power Macintosh, version 1.0

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 : fpinterop kbusage kbdta
Version : windows:97,98; macintosh:1.0
Platform : WINDOWS
Hardware : x86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.