[KCFusion] cfmail

[Adaryl Wakefield]

I am struggling with a work around for the cfmail tag. Im yanking some info that needs to be grouped properly the problem is I can't seem to do it right in a cfmail tag. ive got this   SELECT   table1.Category, table2.question, table3.answer, table4.url, table4.urlText, table2.question_ID FROM      table1, table2, table3, table4 WHERE  table1.cat_num = table2.cat_num AND table2.question_ID = table3.question_ID AND table2.question_ID *= table4.question_ID and table2.question_ID = #url.id#   the information from table1 and table2 only needs to come out once. the information from table3 and table4 need to come out grouped on table2.question_ID   I can't group in a loop and I can't leave the query attribute out of the mail tag and just use cfoutput cause it tosses and error. Im using CFMX on Win2k   Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will