DRW prepopulated search (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database



Message

ybrown -> DRW prepopulated search (12/8/2006 15:09:06)

I need to only show unique values in the drop down. I did it last week and lost the code to do it. Help, please!

Thanks.



ybrown -> RE: DRW prepopulated search (12/8/2006 15:59:05)

SELECT DISTINCT is not working when I add it to the custom query. Any suggestions?

Thanks.



ybrown -> RE: DRW prepopulated search (12/11/2006 13:55:25)

Anybody? Is there a condition where the DISTINCT statement will not work? I've been at this for days now and I'm completely stumped. I've tried several times with new pages and still the same thing.

Any help would be greatly, greatly appreciated. Thanks. [:(]



BeTheBall -> RE: DRW prepopulated search (12/11/2006 16:13:21)

What is the full SQL you are trying?



colfrancis -> RE: DRW prepopulated search (12/13/2006 13:16:28)

can we see your code segment please.



colfrancis -> RE: DRW prepopulated search (12/13/2006 13:26:03)

Remember DISTINCT looks for a totally unique record FOR ALL FIELDS that you are selecting.... the whole row must be unique and any variation of a secondary field will give you another record.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875