I'm a beginner and I'm having the hardest time with inserting a record to the database from a form. The problem is that I want the site to be open to all colleges across the nation. I have a list of all of the colleges, but it's WAY too many for a pick list. I know how to have them search the database for their college, but they might type "ASU" instead of "Arizona State" and therefore wouldn't find their college. I want them to choose their state in one form field and have the page auto refresh with a new pick list of just the colleges in that state under it. Is there an easier way? If not, how in the world do I do that? Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
