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.
<cfloop query="GetCurrentLocalOffers">
<cfoutput>
<a
name="#GetCurrentLocalOffers.id_market#"></a>#GetCurrentLocalOffers.market_n
ame#</td><br>
Current Offers: {offers for market in above link}
Q4 Reminders: {same for all markets}
Promo Details {promos for market in above link}
Contact Info: {contact info for offer}
Store Opening Info: {store info for market in above link}
Local Event Info: {event info for market in above link}
Here is where I need to put information for the market in the anchor tag.
Ex.
Atlanta
Arizona
Boston
Atlanta
...offer details (based on market in DB - tblOfferDetails)
...q4 reminders (will be the same for all markets)
...promo detail info (based on market in DB - tblPromoDetails)
...contact info (based on contact in DB - tblOfferDetails)
...store opening info (based on market in DB - tblStoreOpenings)
...local event info (based on market in DB - tblLocalEvents)
Arizona
...offer details (based on market in DB - tblOfferDetails)
...q4 reminders (will be the same for all markets)
...promo detail info (based on market in DB - tblPromoDetails)
...contact info (based on contact in DB - tblOfferDetails)
...store opening info (based on market in DB - tblStoreOpenings)
...local event info (based on market in DB - tblLocalEvents)
Boston
...offer details (based on market in DB - tblOfferDetails)
...q4 reminders (will be the same for all markets)
...promo detail info (based on market in DB - tblPromoDetails)
...contact info (based on contact in DB - tblOfferDetails)
...store opening info (based on market in DB - tblStoreOpenings)
...local event info (based on market in DB - tblLocalEvents)
Any help or suggestions would be greatly appreciated.
If you have any questions or concerns, please feel free to call me at
407-514-5021.
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]
