Re: Compare records and update

[Jason Congerton]

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>&nbsp;</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>&nbsp;</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:328295
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4