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
Posts: 4 Joined: 12/8/2006 Status: offline
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?
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.
Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline
RE: DRW prepopulated search - 12/11/2006 16:13:21
What is the full SQL you are trying?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
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.