I am looking for some advice with regards to creating dynamic seo friendly urls for a ecommerce store I am producing for a client.
I would normally go down the standard route of using url id's to select the relevant data from the database so my urls would have the familiar http://www.myshop.co.uk/viewproducts.cfm?ProdGroup=12&subgroup=1034
I now have the need to be able to turn the above url into something like the following for example
(menswear being the product group and trousers and shorts being the subgroup.
Can anyone suggest a 100% fullproof way of achieving this with Coldfusion that does not include having to use descriptions as Id's in the database. I have seen this used and it is very messy when descriptions change.