Re: Apache and database driven url rewriting

["Haas, Matt (CL Tech Sv)" <matt.haas@xxxxxxxxxxx>]

Mike,

Take a look at RewriteMap. It looks like you can write a program to process the requests. You could also just rewrite the map file as your database changes.

Matt

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Wednesday, April 22, 2009 11:13 AM
To: 'Web Enabling the AS400 / iSeries'
Subject: [WEB400] Apache and database driven url rewriting

I have been searching for articles on this and can't find anything for apache that would do want I want but can find some for IIS. What I would like to do is do a url rewrite that would change xxx.pct.edu to www.pct.edu/schools/'schoolname'/xxx.html<http://www.pct.edu/schools/'schoolname'/xxx.html>  where xxx is a code for a major we offer and 'schoolname' is the name of the school that offers that major. Majors come and go and we have a database with our current majors.  So the rewrite would lookup the xxx in a table where I would get the school or even the full url for that major. Has anyone ever een anything like this for Apache or is there a case where writing my own module would required?