FP97: Strings with Spaces Fail as Default Values in IDC

Last reviewed: March 18, 1998
Article ID: Q159442
The information in this article applies to:
  • Microsoft FrontPage 97 for Windows with Bonus Pack

SYMPTOMS

If you insert a default parameter value containing spaces in the Add Parameter dialog box of the Database Connector Wizard, the server may not return any data or it may return an error.

CAUSE

The Internet Database Connector considers spaces to be delimiters, and will truncate data after a space if it does not apply, as in the case of default parameters, which can only have one value.

RESOLUTION

Replace the space in the Default parameter value with "%20" (without the quotation marks). For example, if the default parameter value needs to be

   Aniseed Syrup

then type the following text in the Default Value box:

   Aniseed%20Syrup

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

For more information on Internet Database Connector technology, see Chapter 8, "Publishing Information and Applications" of the online documentation for Microsoft Internet Information Server. Note that Chapter 8 of this documentation is available at the following Web site:

   http://www.microsoft.com/infoserv/docs/program.htm

NOTE: Because the Microsoft Web site is constantly updated, the site address may change without notice. If this occurs, link to the Microsoft home page at the following address:

   http://www.microsoft.com


Additional query words: 97
Keywords : fpodbc kbnetwork kbdta
Version : windows:97
Platform : WINDOWS
Hardware : x86
Issue type : kbprb


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.