FP97: Strings with Spaces Fail as Default Values in IDCLast reviewed: March 18, 1998Article ID: Q159442 |
The information in this article applies to:
SYMPTOMSIf 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.
CAUSEThe 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.
RESOLUTIONReplace the space in the Default parameter value with "%20" (without the quotation marks). For example, if the default parameter value needs to be
Aniseed Syrupthen type the following text in the Default Value box:
Aniseed%20Syrup STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATIONFor 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.htmNOTE: 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |