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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
