Hi Just wondered if anyone had any ideas?
Jason > Thank you again for your response, sorry for time its taking for me to > get my head around this!! > > Have a look at this > > http://tvpressings.jasoncongerton.co.uk/transteel-products/test. > cfm?productid=2 > > all looks good, however no NA in boxes with no measurements. however > this is only becauase the top two rows contains the top most amount of > measurements, all the way to T > > now look at this, i have placed the letters above the measurment to > show they are out of align with the top headers. > > http://tvpressings.jasoncongerton.co.uk/transteel-products/test. > cfm?productid=29 > > I need the ooutput to align with the top headers ABC. > > code below > > Jason > > > <!---get the measurements and parts no's---> > > <cfquery name="get_parts" datasource="#application.dsn#"> > SELECT p.lamNo, > p.coreNo, > p.pattern, > p.productPartID, > p.partNo, > m.measOne, > m.measTwo, > m.mTitle > FROM productPart p INNER JOIN > measurement m ON p.productPartID = m.mPartID > WHERE p.partProdID = <cfqueryparam value="#productID#" > cfsqltype="cf_sql_integer"> > ORDER BY p.order, p.lamNo, p.coreNo, p.pattern, m.mtitle > </cfquery> > > <!---//get the letters for the top most row---> > > <cfquery name="get_alpha" datasource="#application.dsn#"> > SELECT tableLetter > FROM tableSort > WHERE tableLetter IN (SELECT mTitle > FROM measurement WHERE mPartID IN (SELECT productPartID > FROM productPart WHERE partProdID = <cfqueryparam value="#productID#" > cfsqltype="cf_sql_integer">)) > ORDER BY tableLetter ASC > </cfquery> > > > > <table> > <tr> > <td> > <cfif get_parts.lamNo NEQ "">LAM NO:</cfif><cfif get_parts.coreNo NEQ > "">CORE NO:</cfif> > <cfif get_parts.pattern NEQ "">Pattern:</cfif></td> > <td><strong>PART NO:</strong></td> > <cfoutput query="get_alpha"> > <td style="width:70px; font-family:Verdana, Geneva, sans-serif; > font-size:10px; > text-align:center;"><strong>#tableLetter#</strong></td> > </cfoutput> > </tr> > <cfoutput query="get_parts" group="lamNo"> > <td>#lamNo#</td> > <td><strong>#partNo#</strong></td> > <cfset ctr = 0 /> > <cfoutput group="mTitle"> > <td>#mTitle#<br />#decimalFormat(measOne)#<cfif measTwo GT 0> X > #decimalFormat(measTwo)#</cfif></td> > <cfset ctr = ctr+1 /> > </cfoutput> > <cfif ctr lt get_alpha.recordcount> > <cfloop from="#ctr#" to="#get_alpha.recordcount#" index="c"> > <td> </td> > </cfloop> > </cfif> > </tr> > </cfoutput> > > </cfif> > > > </table> > > > > </tr> > > > > > > <cfoutput query="get_parts" group="lamNo"> > > <td style="width:80px; font-family:Verdana, Geneva, sans-serif; > font-size:10px;"><strong>#lamNo#</strong></td> > <td style="width:80px; font-family:Verdana, Geneva, sans-serif; > font-size:10px;"><strong>#partNo#</strong></td> > <cfset ctr = 0 /> > <cfoutput group="mTitle"> > <td style="width:70px; font-family:Verdana, Geneva, sans-serif; > font-size:10px; text-align:center;">#mTitle#<br > />#decimalFormat(measOne)#<cfif measTwo GT 0> X > #decimalFormat(measTwo)#</cfif></td> > <cfset ctr = ctr+1 /> > </cfoutput> > <cfif ctr lt get_alpha.recordcount> > <cfloop from="#ctr#" to="#get_alpha.recordcount#" index="c"> > <td> </td> > </cfloop> > </cfif> > </tr> > </cfoutput> > > </cfif> > > > </table> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328386 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
