Dynamically generated wmv links in ASP

[superduperhiro]

I have a web application in ASP and SQL using Dreamweaver MX 2004 that maintains a large amount of streaming videos (i.e. title, author, stream path, encoding date, etc.) I can show the movies and detailed information with no problem.

Since the path for each movie (using the mms:// protocol which was set up by our network guys) is stored in SQL, I'm trying to figure out the BEST code that will allow users to view the windows media movies without fiddling with browser settings.

Any suggestions?

[Bullschmidt]

Seems like the same principle as regular links would work:

For Web site use make all your Web sites and e-mail addresses be pure text in the database.

And do the conversion to a link on the Web page itself.

Example for a Web site link:
<a href="<%= objRS("WebSiteField") %>">objRS("WebSiteField")</a>

Example for an e-mail link:
<a href="mailto:<%= objRS("EmailField") %>">objRS("EmailField")</a>