|
| |
|
|
ybrown
Posts: 4
Joined: 12/8/2006
Status: offline
 |
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?
Thanks.
| |
|
|
|
BeTheBall
Posts: 6502
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.
| |
|
|
|
colfrancis
Posts: 6
Joined: 12/13/2006
Status: offline
|
RE: DRW prepopulated search - 12/13/2006 13:16:28
can we see your code segment please.
| |
|
|
|
colfrancis
Posts: 6
Joined: 12/13/2006
Status: offline
|
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.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
