1st of all, let me take a moment to thank for the video session. It is simply of a great help.

Now let me put across the issue that I am having. I have a list of hotels (Around 70000) stored in SQL SERVER with the hotel_id as primary key. And that table contains the name of the hotel as well.

e.g

Hotel_id Hotel_Name
----------------------------
1234 Star Hotel
5678 Chancery Hotel
3456 Havana Hotel
..........................
..........................
7657 Capitol Hotel


Now I have to rewrite the url some thing like this.

Original URL:
https://www.domain.com/UK/London/Hotel_Details/Havana Hotel.html
New URL:
https://www.domain.com/UK/London/Hotel_Details?hotel_id = 3456


Now what is been suggested in the video is to create a mapping. But I can't create a maping as said earlier that I have 70000 hotels. Hence suggest me the best possible solution for this.


I can create a TAB / SPACE separated TXT file which will have the mapping values some thing like below: If this can help in url rewrite

1234 Star Hotel
5678 Chancery Hotel
3456 Havana Hotel
..........................
..........................
7657 Capitol Hotel


Kindly suggest me the solution on this. I'll be gratefull to you in this regard.


Thanks,
Rahul Jha

PLEASE POST YOUR QUESTIONS ABOUT THE MODULE HERE: http://forums.iis.net/1152.aspx. YOU WILL GET MUCH FASTER RESPONSE!