Sitemap question

Sorry if this question has been asked, I did a search but could not find my answer after digging through about 100 posts (although I did learn a lot of other things)

Im trying to make a sitemap and have included some of the url's. My question concerns a few of my pages that use url parameters. For instance, store_info.cfm?ID=1. But I have a database of about 10000 stores. This makes listing all of them rather complicated. Any advice?

I also have a url like this, buttons.cfm?Cat=Ceramic. For this I only have about 15 categories so listing them would not be a problem. Does google (or other search engines) not advise these sorts of urls?

Thanks for any advice.

Dynamic URLs with query strings are just fine for Google and all other search engines.

To get those pages into your sitemap simply make your sitemap dynamic, too. Use Cold Fusion to create your site for you. Since it looks like your site is database driven simply pull then out of the database and loop through the results to create their listing in your sitemap. 10 lines of code can add 10,000 pages for you automatically. Not only that, but new pages are automatically added for you as well so you don't need too update your sitemap.

You can use URL masking as done in most of the sites these days using the Redirect Rules/ Conditions.
For e.g. store_info.cfm?ID=1 can be shown as store_info.htm/1 or http://your-site.com/1/store_info.htm
these type of urls are also search engine friendly and even doesn't look bad.

Thanks for the ideas. Although parts of my site are database driven, the entire site is not. I dont have a list of all of my pages in a database just products, stores, events etc. Is it still possible to do something like that?

As for URL masking, i've done a little research but can't find any way of doing this with coldfusion. Any advice on where to look?

This is kind of a ps, how useful is it to run a website completely through a database? I can already see one use for it but what are others?

I guess this topic ran away from SEO, but thanks for any comments.

if your site has a good structure and all pages are reachable, you don't need sitemap IMO

My goal behind this idea wasnt really to make a sitemap for users, but to make a sitemap to submit to google. I'm currently trying to think up ways to make a xml sitemap dynamically like suggested to me but have not struck gold yet. Comments as always are appreciated.

As a ps, what does submitting a google sitemap actually do for me?

Sitemap Generator

http://www.google.com/support/webma...py?answer=40318