« Previous Next »

• 05-24-2009, 9:43 PM

  davidpb Joined on 05-25-2009, 1:38 AM Posts 1	Dynamically Generate Rewrite Maps? Reply Contact Hi, Is it possible to dynamically generate rewrite maps?  I have hundreds of products in my product catalogue so it isn't feasible to add a key/value pair for each possibility.  e.g. www.somedomain.com/products.aspx?id=1 should rewrite to www.somedomain.com/products/fitness Or is there a better way of handling this?   Thanks, David.
  	Tags: Rewrite MapURL Rewrite Module

• 05-27-2009, 7:49 PM

  In reply to

  emumford Joined on 02-26-2009, 3:28 PM Posts 13

  Re: Dynamically Generate Rewrite Maps? Reply Contact If you're using SQL Server 2005/2008, here's a trick I have have used...  It will generate an XML node set that you can copy and paste directly into your web.config or linked rewrite map file DECLARE @rewriteMapValues TABLE ([name] NVARCHAR(100), [key] NVARCHAR(256), [value] NVARCHAR(256)) INSERT INTO @rewriteMapValues SELECT 'Some-UrlRewrite-MapName' [name], [Col1] [key], [Col2] [value] FROM Some.TableName [add] -- Add as many variations of this statement, as you need for maps... I usually have an ID to Name, and Name to ID map pair for translation from a rewrite, or to a redirect DECLARE @rewriteMaps TABLE ([name] NVARCHAR(100)) INSERT INTO @rewriteMaps SELECT DISTINCT [name] FROM @rewriteMapValues SELECT [name], (SELECT DISTINCT [key], [value] FROM @rewriteMapValues AS [add] WHERE [name] = [rewriteMap].[name] ORDER BY [key] FOR XML AUTO, TYPE) FROM @rewriteMaps AS [rewriteMap] FOR XML AUTO, TYPE, ROOT('rewriteMaps')