Or just a 2 select related type deal. Depending on how many colleges are in your list, it would be a lot of pre-loaded data, but doable.
http://www.google.com/search?hl=en&q=coldfusion+related+selects Matt On 8/28/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > Have you looked at CF8's ajax stuff? It would allow for this. > Otherwise - you can try Spry as well. > > On 8/28/07, Jim Harmer <[EMAIL PROTECTED]> wrote: > > 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:287309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

