Just loop through the query twice, once at the tope of the page to list the
GetCurrentLocalOffers.market_n
ame, and once at the bottom to create the anchors and list the detail
information.
-----Original Message-----
From: Rosa, Issac [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 7:02 PM
To: CF-Talk
Subject: Link within a page and Query Data
What would be the best way to accomplish this?
I have a display page that has links at the top that will take you to
another point on the same page. What I need to do is dynamically create the
links for the output in the document with data (some data) from a table. I
want to avoid creating a separate query for each market.
Here is the code I have to display the Markets.
<table>
<tr>
<cfloop query="GetCurrentLocalOffers">
<cfoutput>
<td class="header" align="center"><a
name="#GetCurrentLocalOffers.id_market#"></a>#GetCurrentLocalOffers.market_n
ame#</td><br>
</tr>
</table>
<table width="100%" valign="top" cellpadding="0" cellspacing="0" border="0"
align="center">
<tr>
<td class="smallboldblack">Current Offers:<br></td>
</tr>
Here is where I need to put the offer description for the market in the
anchor tag.
Ex.
Atlanta
Arizona
Boston
Atlanta
...some data
Arizona
...some data
Boston
...some data
Any help or suggestions would be greatly appreciated.
Thank you,
> Issac Rosa
>
> IT - National Sales & Marketing
> OLAP Specialist Team Leader
> Ofc: 407-514-5021
> Cell: 407-342-0644
> Fax: 407-514-5988
> [EMAIL PROTECTED]
>
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
