oi Dave!! any extra leverage from on side alone should do it :)
baahahahahahh it's friday. whatcha spect from me (i thought it was funny anyway) -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - <CF_ChannelOP Network="Efnet" Channel="ColdFusion"> ------------------------------------ Friday, May 10, 2002, 10:33:01 AM, you wrote: DB> Hi Guys! DB> How do I turn a CFQUERY record set that CFDUMPs like this: DB> <table border="1" cellspacing="0" cellpadding="1" bgcolor="#eeaaaa" bordercolor="Red">> DB> <tr bgcolor="#eeaaaa" > DB> <td valign="top">DIVISION</td> DB> <td valign="top">PROGRAM_NAME</td> DB> </tr> DB> <tr> <td valign="top" bgcolor="#ffffff"> Team </td> <td valign="top" bgcolor="#ffffff">> Bear Street DB> </td> </tr> <tr> <td valign="top" bgcolor="#ffffff"> Team </td> <td DB> valign="top" bgcolor="#ffffff"> DB> Clipboard Solutions </td> </tr> <tr> <td valign="top" bgcolor="#ffffff"> DB> Team </td> <td valign="top" bgcolor="#ffffff">> Emerson Associates </td> </tr> <tr> <td valign="top" bgcolor="#ffffff">> Team </td> DB> <td valign="top" bgcolor="#ffffff"> Lake Avenue </td> </tr> <tr> <td DB> valign="top" bgcolor="#ffffff"> DB> Team </td> <td valign="top" bgcolor="#ffffff"> Smithfield road </td> </tr> DB> <tr> <td valign="top" bgcolor="#ffffff"> DB> Cambridge Health Alliance </td> <td valign="top" bgcolor="#ffffff"> The Beck DB> Ward </td> </tr> <tr> <td DB> valign="top" bgcolor="#ffffff"> North East </td> <td valign="top" bgcolor="#ffffff">> The Oliver Street DB> House </td> </tr> DB> </table> DB> into something like this: DB> <TABLE BORDER="1" CELLSPACING="0" CELLPADDING="1" BGCOLOR="#EEAAAA" BORDERCOLOR="Red">> DB> <TR ALIGN="center"> DB> <TD COLSPAN="5">Team</TD> DB> <TD COLSPAN="1">Cambridge Health Alliance</TD> DB> <TD COLSPAN="1">North East</TD> DB> </TR> DB> <TR ALIGN="center" BGCOLOR="#FFFFFF"> DB> <TD COLSPAN="1">Bear Street</TD> DB> <TD COLSPAN="1">Clipboard Solutions</TD> DB> <TD COLSPAN="1">Emerson Associates</TD> DB> <TD COLSPAN="1">Lake Avenue</TD> DB> <TD COLSPAN="1">Smithfield road</TD> DB> <TD COLSPAN="1">The Beck Ward</TD> DB> <TD COLSPAN="1">The Oliver Street House</TD> DB> </TR> DB> </TABLE> DB> I left the COLSPANs in there as a possible help to solving the general DB> problem. I suspect there is a more eloquent solution than performing two or DB> three subqueries, though. :-) DB> Thanx DB> Dave DB> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
