|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
April 8th, 2003, 03:30 AM
|
|||
|
|||
|
Recordset containing hyperlink
Hi, I am trying to create a page that contains a recordset and one of the fields to be a hyperlink to a download.
I am using an Access database and don't seem to be able to make the hyperlinks 'active'. Any help would be greatly appreciated. Thanks Ozric
|
|
#2
April 8th, 2003, 03:51 AM
|
|||
|
|||
|
Code:
' ...
While Not lRS.EOF
' ...
Response.Write "<a href=""" & lRS.Fields("link").Value & """>" & lRS.Fields("link").Value & "</a>"
' ...
lRS.MoveNext
Wend
is this what you want?
|
|
#3
April 8th, 2003, 05:21 AM
|
|||
|
|||
|
Sorry Wingman, I'm a bit of a noob with ASP, here is the code I am dealing with:
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <tr> <td align="default" width="25%"> <%=(Recordset1.Fields.Item("Type").Value)%> </td> <td align="default" width="25%"><%=(Recordset1.Fields.Item("Location").Value)%></td> </tr> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend The "Location" variable is the one that is to be a hyperlink, I can't see how I can apply the code that you have sent, can you (or anyone else) advise further please. Thanks Ozric Last edited by ozric : April 8th, 2003 at 05:25 AM.
|
|
#4
April 8th, 2003, 05:50 AM
|
|||
|
|||
|
Code:
<% While (NOT Recordset1.EOF) %>
<tr>
<td align="default" width="25%">
<%=(Recordset1.Fields.Item("Type").Value)%> </td>
<td align="default" width="25%">
<a href="<%=Recordset1.Fields.Item("Location").Value%>"><%=(Recordset1.Fields.Item("Location").Value)%></a>
</td>
</tr>
<%
Recordset1.MoveNext
Wend
%>
This should do the trick
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Recordset containing hyperlink |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
