Perfect, that part with the getstates query is exactly what I was looking for! We already had a table with states and abbreviations made, so it saved having to do a 50-item cfswitch.
Thank you all so much for your help! >Ok so basically this is a query you want to run ONE time to get the >initial data set into the database? I'm assuming you'd be putting the >page "content" and "title" in later? >I would do something as basic as... > >Select the states ><cfquery name="getstates"> > select state, id from states ></cfquery> > >Loop through the query... ><cfloop query="getstates"> > >If you have 10 pages i would insert each here w/ in the query statement, >which then will loop through all 50 states and add 10 pages for each. >I'm going to assume you would later go back and add the content, page >title etc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:311258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
