View Single Post
 
Old November 12th, 2008, 12:44 PM
gene4455 gene4455 is offline
Authorized User
 
Join Date: Oct 2008
Location: , , Canada.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

First, Thank you for your help

I tried what you showed me above and it sort of works. But below is what i did and I am not sure where i am going wrong


<TABLE BORDER=1 COLS=<% = oRs.Fields.Count %>>
   <TR>
    <%Dim oField
    For Each oField In oRs.Fields %>
      <TH> <% = oField.Name %></TH>
      <% Next %>
      </TR>

<%Do While Not oRs.EOF %>
   <TR>
   <%For Each oField In oRs.Fields%>
       <TD ALIGN=RIGHT>
This is where you may need to look
       <A HREF= "<%= oRs.Fields("Link")%>">Click </A>
       <%If IsNull(oField) Then
           Response.Write "&nbsp;"
          Else
           Response.Write oField.Value
         End If
       %>

       </TD>
       <% Next
       oRS.MoveNext%>
       </TR>
    <% Loop %>
</TABLE>



 <A HREF= "<%= oRs.Fields("Link")%>">Click </A>

The output is i would say almost close to what i am trying to accomplish.

Let me define a few things for you:
 "Link" is the name of the Field/Column I am trying to turn into links such that when a user clicks on any text in this field it would open a document.

"Click" was just a test I put in there to see what would happen when i run my ASP page

Finally,
The output is like this

In the field named "Link" there are text values there but now when i run my code "Click" appears beside this text values in this Field(Link)

"What i am trying to do is make those text values in the field (Link) become links to documents on my local drive."

 "Click" does not link to anything it just appears as a text with an underline.

The most tricky part is I dont want to supply the texts to this Field (link) in code i want to be able to suppy it in an HTML form and post it to my database as a link that opens up documents on my local or network drive.

Thank you very much for your help.

Any suggestions you have are welcomed.
Thank you.