Thanks for the welcoming answers. :) I am relatively new to ColdFusion, but I may have misstated my question; it's not the pulling information from the database I'm not sure how to do, it's the setting the database up (efficiently) in the first place.
I figure each record will need five fields: the ubiquitous auto-incremented ID, the page title, the page content, then the state and the page name (to call in from the URL, like index.cfm?page=about&state=VA). Since all the states will have the same set of ten pages to start, it seems that one should be able to use a cfloop of insert statements. Where I get jammed up is figuring out how to tell it what state to insert in the state field. Would it need to be a long cfswitch saying if i=1 the state is AL, if i=2 the state is AK, etc.? Thanks again! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
