Imran
|
| Posted: 04/29/2004, 12:12 PM |
|
Hi 
I need to know how can i include all America city names easily in list box which will pass then the name of that city as value to one column of database to store the city of client through CSS easily. And also that list box give functionality like when any alphabet press it will automatically go to that entry of page
Thanks
Looking forward for kind replay from you people who know that answer. Thanks in advances
Imran
|
|
|
 |
Imran
|
| Posted: 04/29/2004, 12:23 PM |
|
 Hi. I got the idea by going through the internet database example where i can make one table with all cities name and make listbox from that city name and save that value as foreign key but  In usa there is too much city and its a kind of pain process to type all city and what about how can i control if somebody press "w" in that list box it will automatically go to entry of names of city which start from "W". Can any body please explain me this pls. And also does any one have any table with all american city name can he pls forward me only that so i will not going the same proecess of pain 
Thanks in advance
Imran
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/30/2004, 1:40 AM |
|
The Windows or web browser will automatically go to the names starting with "w". At least this works on my computer on every Web page that contains listbox.
I don't know where you can get the names of all cities, however if you create such listbox then the Web page will be so big that it will be loading for 10+ minutes and users' computers will probably hang due to lack of memory wen trying to process or display such listbox... 
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
E43509
Posts: 283
|
| Posted: 04/30/2004, 6:35 AM |
|
That list will be way too big.
Perhaps pop up a window that they can 'search' for a name and give them a list to select from and use that value to populate your field
|
|
|
|
Imran
|
| Posted: 04/30/2004, 9:49 AM |
|
I think peter you are rite regarding the listbox then i think i need to go through with dependent box on don side so i can divided city on the basis of states or other options from E43509 is also appreciated since i m thinking to give fill in the blanks type of text box with popup page so if any one want to include city from there he will otherwise just include it directly. Any way this is my class project which i can mold according the wish but usually i like to go with quality and knowledge.
Thanks a lot for your guidance
Imran
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/30/2004, 10:35 AM |
|
Imran,
Looks like the list of US cities is at http://www.census.gov/tiger/tms/gazetteer/places2k.txt and it is not as long as I thought (previously I tried searching for "a" at http://www.mit.edu:8001/geo and my browser hung).
Still pop-up list may be better but your second posting indicated that your goal is to improve the speed of entry and I don't think that the pop-up window would improve the speed for me, at least when I am entering my own city on various forms. However, our CCS Example Pack includes pop-up list example, which is also live at http://examples.codecharge.com/ExamplePack/PopUpList/PopUpList.php
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
