ASP - displaying a doc or pdf file from a database

[lin45]

I am trying to read the path of a file (which will be either a pdf file or a doc file)from a database in order that the contents of the file can be displayed in a new window showing .

Presently on the first page I show brief details and on the OnClick this takes me to a second page, taking the full information to be displayed from the database. However this is making the database extremely big and I would like to have the field in the database contain the path to the file it relates to somehow be able to display this on the next page on the onclick event.

I presently use the undernoted javascript function to call the information from the database, but wonder if it is possible to replace this with the path to the file and if so what would be the code.

thanks in advance

Linda
function InfoPage(Select)

{
document.menu.Selection.value=Select;
document.menu.target = "_blank";
menu.submit();
}
and the onclick reading
onClick=&quot;InfoPage('<%=safejsqtStr(strEntryID(i))%>')