|
| |
|
|
shoky
Posts: 25
Joined: 9/13/2005
Status: offline
 |
Dropdown pulled from DB - 12/10/2007 14:18:13
I know I've done this before but I can't remember what the code was -
I need to have a dropdown selection pulled from an access DB - which is City.
I want the City name pulled from existing records, but I want each city to be listed once only. It's a narrow your search kind of thing.
|
|
|
|
shoky
Posts: 25
Joined: 9/13/2005
Status: offline
|
RE: Dropdown pulled from DB - 12/10/2007 14:28:59
Oh I think I remember - Is it just make my SELECT - SELECT DISTINCT instead?
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Dropdown pulled from DB - 12/10/2007 14:29:42
Use distinct in your query as in:
SELECT DISTINCT CityName FROM ....
Hope it helps.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 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 
