Microsoft KB Archive/265193

= FP2000: Duplicates Appear in Combo Boxes Populated by Database Results Pages =

Article ID: 265193

Article Last Modified on 8/27/2002

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



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 =' ' AND value2=' ')

Additional query words: ocsso front page

Keywords: kbprb KB265193

-

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

© Microsoft Corporation. All rights reserved.