Melissa, This would be in your Query statement. Insert INTO STATES Where State = '#URL.State#' David G. Moore, Jr. UpstateWeb LLC> Subject: Re: Creating a database with repeated information> From: [EMAIL PROTECTED]> To: cf-talk@houseoffusion.com> Date: Mon, 18 Aug 2008 11:05:02 -0400> > 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:311184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4