troubleshooting Question

Match query dates with week dates on a report

Avatar of Ru1995
Ru1995Flag for United States of America asked on
ColdFusion Language
12 Comments1 Solution267 ViewsLast Modified:
I am creating a report that displays whether or not the user submitted a survey during a certain period.  

The header of the report shows all 52 weeks in a year and its displayed like this

<tr><td colspan="2">&nbsp;</td>
            <cfloop from="1" to="52" index="wk"><td class="dspWeek"><a class="date">#wk#<span>Date</span></a></td></cfloop>
      </tr>

However, know the user wants a rollover date functionality that displays the date of when the user submitted the form.  

If I pull distinct dates from a query how would I match it with the title headers on the report?

Also if there aren't any dates to match with the period it should display something like "no surveys submitted"

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros