> erik tom wrote:
> > I do not get any errors It just does not output it correctly . First
> of it looping throug the users, then it get the completion. I do not
> know if I am doing it correctly . I am trying outputing row by row, so
> get employeeId loop throu the courses required and compare that
> courses to the array of the courses for completion.
>
> Step by step. Maybe you have done this, we don't know.
>
> <cfdump...> your queries. Do they contain the data you expect them to
>
> contain. Is it organized as you expect it to be organized.
>
I did some cfdump and it seems to be correct . However I noticed that the date
is not capturing correctly
<cfif isDate(QoQInline.completiondate)>
<td valign="top" class="tdctr"></td>
<cfelse>
<td valign="top" class="tdctr">X</td>
</cfif>
<!-- There was no record in the QofQ - so this is not a
required course for this EmpID -->
<cfelse>
<td valign="top" class="tdctr">N/A</td>
</cfif>
if the completion date is NULL then it returns N/a rather than being X. I do
not know how incount for that . Here is the sample output
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
