I am trying to provide a hyperlink to records that has a file which user can click on it to download.

My field is viewsupplier.Fields.Item("attachedfile".Value<>

I tried to provide hyperlink for this field by this statement;
<a href="downloadfile\<%viewsupplier.Fields.Item("attachedfile".Value<> %>download</a>

However, this does not work because the hyperlink will appear even for those records that do not have any file, e.g 127.0.0.1/sc/download. And when user click on this, the link is invalid because no file can be found.

How can I resolve this problem ? Please help. Thanks !

try using this extension www.udzone.com/showDetail.asp?TypeId=3&NewsId=628

it should do the trick

Joel Martinez

----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"