Knowledge Base

FP97: Strings with Spaces Fail as Default Values in IDC

Article ID: 159442

Article Last Modified on 6/25/2007

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