Linking to a Page URL from a dynamic page

[Caldew]

Hello I have an Access db table which contains a field called URL. I have
previously <cfset display_url = #rsListHistory.URL#>. When I display the list
of records I am successfully showing the correct URL to click in order to call
the required .cfm page. The code that I am using is listed below. The URL of
the page is [url]http://www.dalston.org.uk/History/index.cfm[/url]. I have 2 dynamically
displayed items and the each show the correct URL link to the required page.
However, when you click on the second link it displays the page from the first
link. Obviously something is missing in the CF code in relation to the
display_url variable. I would appreciate some pointers to solve this. Also,
and very much related, how do I avoid showing the URL? I would prefer to show
a bit of text like 'Click for Item', but the underlying link would go to the
correct URL which is held in the History.URL (the URL field in the Access
database). Your help will be appreciated. Ronnie

<cfoutput query="rsListHistory" startRow="#StartRow_rsListHistory#"
maxRows="#MaxRows_rsListHistory#">
<tr>
<td><cfif rsListHistory.RecordCount GT 0>
<font size="2" face="Arial, Helvetica,
sans-serif">#rsListHistory.Topic#</font> </cfif></td>
</tr>
<tr>
<td><font size="1" face="Arial, Helvetica,
sans-serif"><a href=#display_url#>#rsListHistory.URL#</a></font></td>
</tr>
<tr>
<td><hr></td>
</tr>
</cfoutput>

[philh]

Hi Ronnie, When you set display_URL outside of the CFOUTPUT query loop, you
set it equal to the value of the field in the first record of the query
results. That won't change in your output. Just use the straight value from
the record. HTH,