Creating a page to populate a list from db query
Posted on 2008-06-17
I'm looking for assistance, if possible for something I'm trying to do. I have a web page, that the user needs to enter new records in my database. The user would enter a project name, and then the lcoation of the project. There are hundreds of project locations, and I'd like the user to select the project location from a popup window. I have that part accomplished with the help of everyone here. The problem is that I still have too many records for the user to have to sift through to get the location they want. Currently I have a page with a blank form field, and three radio buttons. The user selects a radio button, to select the region of the project locations, and then a popup window opens with a drop down box showing all locations in that region. The user selects the location, and then clicks on the submit button, and it fills in the blank form field on the main page. What I really would like to do is have the popup window have a list of states, maybe on one side, or frame, then the user selects the state and the locations for that state appear in another frame, or somewhere on that popup wondow page that the user can select and send back to the main page. This would let the user define the location search a bit more and not have to go through all of the hundreds of locations for each region. Is this doabale, and if so, could someone help me get going with it???? It's a little above my knowledge of Coldfusion, and JAVA.....THANKS!!!!!