Ryan's right, and I'll go so far as to say what he's described to you is a *much* better way to create new sweepstakes. Think about it: once you start creating a bunch of subdirectories and copying .cfm templates into them, at some point in the future you may find yourself maintaining them all too and eventually wishing that you hadn't created such a mess of redundancy for yourself to wade through and try to keep straight. So you'll almost certainly be much better off using one code set for all your sweepstakes, providing that the sweepstakes are going to resemble each other in their functioning which it sounds like you are planning to do. There are a number of ways to do it too, not necessarily with .htaccess mods either. I would think about using a single /sweepstakes/ subdirectory containing a custom .cfm landing page for each individual sweepstakes event (which your client is going to want anyway) so that each landing page could contain a unique Sweepstakes_ID in a hidden form field that gets passed from one page to the next. Less cleanly you could pass a URL.Sweepstakes_ID between pages, or better, you might even want to set a cookie with a Sweepstakes_ID that doesn't get deleted until the user finishes the questions. There are a lot of ways to skin this cat.
The only reason to NOT do it with one code set might be if you planned to use your Admin functionality to actually write out static files so that your users working their way through the questions wouldn't be hitting the database at all or hardly at all (you could accumulate all their answers in hidden form fields or in a cookie without hitting the database until the very end, just once). You could get away with using a not-very-powerful server and database doing it that way if you had to (MS Access on a 500Mhz shared server for example) but if you have a fast dedicated web server and any version of MSSQL running on a second machine then you ought to keep it all dynamic, the way CF was meant to be. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
