Appologies, i left out some important info - the CF code. Below is the query
output. i'm using cf's group by for the first time. so perhaps it's a lack
of understanding of it's use that is causing the trouble. i'm grouping on
the sales person's name because my query pulls back the total sales for each
sales category by person which means since i have 6 sales categories, i get
six instances of that sales person's name. perhaps another troubling point.
Anyway, below is my CF code. Again, thank you in advance for any help you
can give.
d
CF code:
<cfoutput query="getData" group="last_nm">
#first_nm# #last_nm# <br>
Category Name | Current Total | Goal
<cfoutput>
#TRIM(category_nm)# | #totalForMonth# | #goal_nb#
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
