FP97: Strings with Spaces Fail as Default Values in IDC (159442)


The information in this article applies to:

  • Microsoft FrontPage 97 for Windows with Bonus Pack
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 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 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

Modification Type:MajorLast Reviewed:10/1/2002
Keywords:kbnetwork kbprb KB159442
©2002 Microsoft Corporation. All rights reserved.