Let's say you're making a MySQL database-driven website for states and each state will originally be set up with the same ten pages worth of information. (All states will have a home page saying "Welcome to our state", all will have a contact page saying "Contact our state", etc.)
Obviously each state will want to personalize their pages through a self-administration interface (being able to change their home page to "Welcome to Rhode Island" and adding information about historic sites, for example) so each state will have to have its own entries in the database for each page. Which means you're looking at 500 entries to set up. Is there a way to create the original ten entries, then somehow loop through the next 49? I certainly hope so. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:311174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

