FP2000: Duplicates Appear in Combo Boxes Populated by Database Results Pages (265193)


The information in this article applies to:

  • Microsoft FrontPage 2000
This article was previously published under Q265193

SYMPTOMS

In Microsoft FrontPage 2000, when you populate a combo box from a Database Results page, any duplicates in the source column also appear in the combo box list.

RESOLUTION

To prevent duplicates from being displayed in the combo box list, customize the SQL statement.

Instead of using

SELECT * FROM TABLE

or

SELECT COLUMN FROM TABLE

use the following:

SELECT DISTINCT COLUMN FROM TABLE

This statement also works with more complex queries, such as:

SELECT DISTINCT COLUMN FROM TABLE WHERE (value1 ='MyValue1' AND value2='MyValue2')

Modification Type:MajorLast Reviewed:8/27/2002
Keywords:kbprb KB265193
©2002 Microsoft Corporation. All rights reserved.