Microsoft KB Archive/159442

= FP97: Strings with Spaces Fail as Default Values in IDC =

Article ID: 159442

Article Last Modified on 6/25/2007

-

APPLIES TO


 * Microsoft FrontPage 97 Standard Edition

-



This article was previously published under Q159442



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. 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: Because the Microsoft Web site is regularly 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: kbnetwork kbprb KB159442

-

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

© Microsoft Corporation. All rights reserved.