Another option, which makes ColdFusion even better. Is one page acting as a template, then you could write a custom tag to reformat the data the way you want. If that manes loading a template to designate a layout as well.
It can be refactored to minimal code. Agreed Melissa if you are new, try googling as well. The reason being is that you just may luck out, and find someone who may have blogged something similar. But Ben's books are almost a must when you learning the way you can do one thing so many ways:-) Hope that helps. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, 18 August 2008 11:37 PM To: CF-Talk Subject: RE: Creating a database with repeated information Melissa, This is exactly what ColdFusion is designed to do. You will have ten separate ".cfm" files and each of the files represents one of your 10 pages. Whatever information is 'static' for each page (in other words, whatever information stays the same for every state) can be hardcoded into the .cfm file. Anything that is dynamic (can be different for each state) should be referenced in the database. There are a number of ways to accomplish this (as just about anything in ColdFusion can be done different ways) so you might get different ideas on here from other people, but you can simply pass a 'url' parameter called 'state_id' or something like that that references a unique column in your database and that represents the state. Then you will have a <cfquery> tag at the top of each of your .cfm pages that pulls the necessary 'dynamic' information from your database for each state. Finally, when you want to display dynamic information from the query, surround your output with a <cfoutput> tag and your queryname and column names with # signs like this: Welcome to <cfoutput>#qMyQuery.state_name</cfoutput> Something like that. I recommend starting simple, with just creating your first page that displays the dynamic 'welcome to' message and then you can build it up from there. Dave -----Original Message----- From: Melissa Cope [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 8:25 AM To: CF-Talk Subject: Creating a database with repeated information 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:311244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
