Grouped cfoutput
I have a query whose result set looks like this: phaseId | phaseName | milestoneId | milestoneName -- 1phase11 name1 1phase12 name2 1phase13 name3 2phase24 name4 2phase25 name5 2phase26 name6 3phase37 name7 3phase38 name8 3phase39 name9 I am trying to output the query so that in a table I can get the output to look like: Phase1 ---name1 ---name2 ---name3 Phase2 ---name4 ---name5 ---name6 Phase3 ---name7 ---name8 ---name9 The query I am using is as follows: SELECT P.phaseId, P.phaseName, M.milestoneId, M.nilestoneName FROM milestone M INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId) ORDER BY P.phaseName How do I setup the cfoutput tags with the query and group attributes set to obtain the output I described above.. Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Grouped cfoutput (SOLVED)
Sorry... left an extra cfoutput in my code which was throwing my output off! -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:25 AM To: CF-Talk Subject: Grouped cfoutput I have a query whose result set looks like this: phaseId | phaseName | milestoneId | milestoneName -- 1phase11 name1 1phase12 name2 1phase13 name3 2phase24 name4 2phase25 name5 2phase26 name6 3phase37 name7 3phase38 name8 3phase39 name9 I am trying to output the query so that in a table I can get the output to look like: Phase1 ---name1 ---name2 ---name3 Phase2 ---name4 ---name5 ---name6 Phase3 ---name7 ---name8 ---name9 The query I am using is as follows: SELECT P.phaseId, P.phaseName, M.milestoneId, M.nilestoneName FROM milestone M INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId) ORDER BY P.phaseName How do I setup the cfoutput tags with the query and group attributes set to obtain the output I described above.. Thanks! Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Grouped cfoutput
cfoutput query=qTest group=phaseName #qTest.phaseName#br cfoutput ---#qTest.milestoneName#br /cfoutput br /cfoutput Pascal -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: maandag 20 oktober 2003 15:25 To: CF-Talk Subject: Grouped cfoutput I have a query whose result set looks like this: phaseId | phaseName | milestoneId | milestoneName -- 1phase11 name1 1phase12 name2 1phase13 name3 2phase24 name4 2phase25 name5 2phase26 name6 3phase37 name7 3phase38 name8 3phase39 name9 I am trying to output the query so that in a table I can get the output to look like: Phase1 ---name1 ---name2 ---name3 Phase2 ---name4 ---name5 ---name6 Phase3 ---name7 ---name8 ---name9 The query I am using is as follows: SELECT P.phaseId, P.phaseName, M.milestoneId, M.nilestoneName FROM milestone M INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId) ORDER BY P.phaseName How do I setup the cfoutput tags with the query and group attributes set to obtain the output I described above.. Thanks! Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Grouped cfoutput
cfoutput query=yourqueryname group=phaseName br#phasename#br cfoutput - #milestoneName#br /cfoutput /cfoutput should be close enough - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Monday, October 20, 2003 3:25 PM Subject: Grouped cfoutput I have a query whose result set looks like this: phaseId | phaseName | milestoneId | milestoneName -- 1phase11 name1 1phase12 name2 1phase13 name3 2phase24 name4 2phase25 name5 2phase26 name6 3phase37 name7 3phase38 name8 3phase39 name9 I am trying to output the query so that in a table I can get the output to look like: Phase1 ---name1 ---name2 ---name3 Phase2 ---name4 ---name5 ---name6 Phase3 ---name7 ---name8 ---name9 The query I am using is as follows: SELECT P.phaseId, P.phaseName, M.milestoneId, M.nilestoneName FROM milestone M INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId) ORDER BY P.phaseName How do I setup the cfoutput tags with the query and group attributes set to obtain the output I described above.. Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Grouped cfoutput
cfoutput query=myquery group=phasename #phasename#br cfoutput ---#milestonename#br /cfoutput /cfoutput - Original Message - From: Tangorre, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 20, 2003 8:25 AM Subject: Grouped cfoutput I have a query whose result set looks like this: phaseId | phaseName | milestoneId | milestoneName -- 1phase11 name1 1phase12 name2 1phase13 name3 2phase24 name4 2phase25 name5 2phase26 name6 3phase37 name7 3phase38 name8 3phase39 name9 I am trying to output the query so that in a table I can get the output to look like: Phase1 ---name1 ---name2 ---name3 Phase2 ---name4 ---name5 ---name6 Phase3 ---name7 ---name8 ---name9 The query I am using is as follows: SELECT P.phaseId, P.phaseName, M.milestoneId, M.nilestoneName FROM milestone M INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId) ORDER BY P.phaseName How do I setup the cfoutput tags with the query and group attributes set to obtain the output I described above.. Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]