can anyone help, i am uploading a file to a server using ASP Pure upload, thats all working fine, my problems is when i view a detail record from my databse, the file name is there, but i am trying to make it into a hyperlink so that you can click on and open the file, in this instance a .xls file. have tried a few suggestions but as yet no luck. Does anyone know if there is an dramweaver extension for this of a line to code that could do it. I have tried the line below but the file names isnt visable when viewed in my browser, take the a href away and its back again


<a href="<%=(rstender.Fields.Item("doclocated".Value)%>"><%=(rstender.Fields.Item("doclocated".Value)%></a>

many thnaks

Derran

Derran,

have you looked at the source of the generated page? I am interested to see if you are getting anything at all.

What is the actual contents of the field after the upload?

I have never done this exact thing, but this works for me:

<a href="<%= RTrim((rsNoPic.Fields.Item("charURL".Value)) %>" target="_blank"><%= RTrim((rsNoPic.Fields.Item("charBandName".Value)) %></a>

thanks for your replay but last night i managed to sort it. What i had done is the access database field was set to OLE Objects, not sure why i did that, but changed it to text and is working fine now. Has a little broblem with the upload folder using Purse ASP 2.13, not sure if it was a bug or what but hard coses the folder into the code and away i go. Thanks for your reply. much appriciated

derran