Output

[Jason Congerton]

Hi

I need to output two tables in an unconventional manner,

table structure:

table: productPart
uid: productPartID
fields: lamNo, partNo

table: measurement
uid: mID
relationship id: partProdID (link to above table)
fields: mTitle, measOne

mTitle is used to cross reference the measurement with an image i.e A = 0.23 etc

I need to output the table as a matrix, i know how to get the the table to add columns, however the new <tr> could be unknow as each part number could display a different amount, please see below the outoput i am trying to achieve,

Lam No: Part No: A     B      C      D      E      F
23AN    A234     2.0   3.3    3.4    3.5    3.6    3.5
24AN    A235     3.0   4.3           4.5    4.6    5.5
25AN    A236     4.0   5.3    2.3    5.5    5.6    6.5

As you can see 24AN only needs 5 measurements whilst the rest are using 6, may not be unreasonable to fill the missing measurement with 0.00 and not display it, that way i would know where my row is finishing.

Could i use cfgrid? i had a quick look, but i could not find away of grouping the output and was getting repeat part numbers.

Any ideas??

Thanks

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