a href problem

[infernofiasco]

Iam trying to link a record from database and making it into a link:

<a href="<%=(rs_images.Fields.Item("filename"))%>"><%=(rs_images.Fields.Item("filename").Value)%></a>

when i run the page the file name wont come up?

why is that and how do i create a proper link.

[BlobFisk]

Does the database record have the file extension (eg .html)?

If not you will need to add that....

[infernofiasco]

No its actually a file.

Like
file name
text.txt (link)
new document.doc (link)

[davegerard]

If you can capture the filename with the FileSystemObject you can create a variable for the name and perhaps use that in your link.

MyFile = File.Name
<a href="<%=MyFile%>">MyFile</a>