Thank you Raymond, I was able to fix the problem by removing startrow and MaxRows. It works great now! Thank you so much for the fast response! Mathy
At 8/14/2002 08:24 AM, you wrote: >Your cfoutput tag has a maxrows="#maxcols#" - did you want that? > >======================================================================= >Raymond Camden, ColdFusion Jedi Master for Hire > >Email : [EMAIL PROTECTED] >Yahoo IM : cfjedimaster > >"My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: Mathy V Arumugam [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 14, 2002 11:20 AM > > To: CF-Talk > > Subject: MX broke the table! > > > > > > Hello, > > I am new to this list and hope someone could help me... > > > > I have some code that dumps the contents of several queries > > into tables > > that are set at 21 columns wide maximum. Everything worked > > fine thru 5.0 > > but when we upgraded to MX it would list the <th> tags OK but > > then on the > > rows of data it would only list the first seven columns of > > the first row > > and then nothing. > > Any help would be really appreciated! > > Thank you > > Mathy > > > > > > Here is the code: > > <cfset RowNow = #nextstart#> > > <table border="1" cellspacing="0" cellpadding="0" align="center" > > bgcolor="Tan"> > > <tr> > > <cfoutput> > > <th rowspan=2>#get_table_info.row_heading#</th> > > <th colspan="#Evaluate(MaxCols)#">#get_table_info.column_heading#</th> > > </cfoutput> > > </tr> > > <tr> > > <cfoutput query="select_data" startrow="#RowNow#" MaxRows="#MaxCols#"> > > <TH>#C#</TH> > > </cfoutput> > > </tr> > > <cfoutput query="select_data" group="R" startrow="#RowNow#" > > MaxRows="#MaxRows#"> > > <tr> > > <cfset altcolor = "bgcolor='###Iif(((RowNow MOD 2) is > > 0),de('cccccc'),de('ffffff'))#'"> > > <td align=center><b>#R#</a></b></td> > > <cfoutput> > > <cfif ColNow GTE #MaxCols#> > > <td align=center #altcolor#>#select_data.V#</td> > > <cfelseif ColNow LTE #MaxCols# AND RowNow EQ #nextstart#> > > <td align=center #altcolor#>#select_data.V#</td> > > </cfif> > > <cfset ColNow = IncrementValue(ColNow)> > > </cfoutput> > > <cfset ColNow = 1> > > <cfset RowNow = IncrementValue(RowNow)> > > </tr> > > </cfoutput> > > </table> > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
