re: Output

[Jason Fisher-3]

Set your query up with the simple join, which will give you duplicate
productPart entries for each measurement, but that's OK:

<cfquery name="stuff">
    SELECT p.lamNo,
        p.partNo,
        m.measOne,
        m.mTitle
    FROM productPart p INNER JOIN
        measurement m ON p.productPartID = m.partProdID
    ORDER BY p.lamNo, m.measOne
</cfquery>

Then use the group attribute of CFOUTPUT to get only one TR per product and
then subgroup on each measurement to output the addition TDs.  In the
example below, I assume 5 measurement columns and output blank TDs for any
that fall short of 5.  Should work, although I've made assumptions about
the data in the measurement columns.  Adjust as necessary.

<table>
    <cfoutput query="stuff" group="lamNo">
        <tr>
            <td>#lamNo#</td>
            <td>#partNo#</td>
            <cfset ctr = 0 />
            <cfoutput group="measOne">
                <td>#mTitle#</td>
                <cfset ctr = ctr++ />
            </cfoutput>
            <cfif ctr lt 5>
                <cfloop from="#ctr#" to="5" index="c">
                    <td> </td>
                </cfloop>
            </cfif>
        </tr>
    </cfoutput>
</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:328067
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Jason Congerton]

Hi Jason

Thanks for your response, works great, just need to tidy up the output and im done - thank you

Jason

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328081
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Jason Congerton]

> Hi Jason
>
> Thanks for your response, works great, just need to tidy up the output
> and im done - thank you
>
> Jason


Hi

If anyones interested heres the output link will be avaialable for a short time

http://tvpressings.jasoncongerton.co.uk/transteel-products/test.cfm?productid=2

Jason

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328084
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4