WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/build_status.asp



                           rsQry.Close()
                           Set rsQry = nothing
                           %>
                           <td width="9%" valign="top"></td>
                           <tr>
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Daemon Host</td>
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">GBE Machtype</td>
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Mode</td>
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Run Level</td>
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Current Package</td>
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Last Change<br>Delta (secs)</td>
                              <td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Switch State</td>
                           </tr>
                           <%
                           ' Get the number of release configurations for this RTAG_ID, and iterate through them
                           query_string = " select * from release_config rc, gbe_machtype gm, build_machine_config bm"&_
                                          "  where rc.rtag_id = "& parRtagId &_
                                          "    and gm.gbe_id = rc.gbe_id"&_
                                          "    and rc.daemon_hostname = bm.machine_hostname(+)" &_
                                          "  order by rc.daemon_hostname"
 
                           Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
 
                           Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)

                              %>
                              <tr>
                                 <td colspan="6" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
                              </tr>
                              <tr>
                                 <td nowrap class="body_rowg"><%=rsQry("display_name")%></td>
                                 <td nowrap class="body_rowg"><%=rsQry("gbe_value")%></td>
                                 <td nowrap class="body_rowg"><%=Get_Daemon_Mode(rsQry("daemon_mode"))%></td>
                                 <td nowrap class="body_rowg"><%=Get_Run_Level(currentRunLevel, indefinitelyPaused)%></td>
                                 <td nowrap class="body_rowg"><%=Get_Package_Name(pkgName)%></td>
                                 <td nowrap class="body_rowg"><%=rsQry2("delta")%></td>

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/build_status.asp @ 165 – Rev 157 → 163

Rev 157		Rev 163
Line 408...		Line 408...
408	`rsQry.Close()`	408	`rsQry.Close()`
409	`Set rsQry = nothing`	409	`Set rsQry = nothing`
410	`%>`	410	`%>`
411	`<td width="9%" valign="top"></td>`	411	`<td width="9%" valign="top"></td>`
412	`<tr>`	412	`<tr>`
413	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Hostname</td>`	413	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Daemon Host</td>`
414	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">GBE Machtype</td>`	414	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">GBE Machtype</td>`
415	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Mode</td>`	415	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Mode</td>`
416	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Run Level</td>`	416	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Run Level</td>`
417	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Current Package</td>`	417	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Current Package</td>`
418	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Last Change<br>Delta (secs)</td>`	418	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Last Change<br>Delta (secs)</td>`
419	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Switch State</td>`	419	`<td valign="top" nowrap background="images/bg_table_col.gif" class="body_col">Switch State</td>`
420	`</tr>`	420	`</tr>`
421	`<%`	421	`<%`
422	`' Get the number of release configurations for this RTAG_ID, and iterate through them`	422	`' Get the number of release configurations for this RTAG_ID, and iterate through them`
423	`query_string = " select * from release_config rc, gbe_machtype gm"&_`	423	`query_string = " select * from release_config rc, gbe_machtype gm, build_machine_config bm"&_`
424	`" where rc.rtag_id = "& parRtagId &_`	424	`" where rc.rtag_id = "& parRtagId &_`
425	`" and gm.gbe_id = rc.gbe_id"&_`	425	`" and gm.gbe_id = rc.gbe_id"&_`
-		426	`" and rc.daemon_hostname = bm.machine_hostname(+)" &_`
426	`" order by rc.daemon_hostname"`	427	`" order by rc.daemon_hostname"`
427		428
428	`Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )`	429	`Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )`
429		430
430	`Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)`	431	`Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)`
Line 470...		Line 471...
470	`%>`	471	`%>`
471	`<tr>`	472	`<tr>`
472	`<td colspan="6" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>`	473	`<td colspan="6" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>`
473	`</tr>`	474	`</tr>`
474	`<tr>`	475	`<tr>`
475	`<td nowrap class="body_rowg"><%=rsQry("daemon_hostname")%></td>`	476	`<td nowrap class="body_rowg"><%=rsQry("display_name")%></td>`
476	`<td nowrap class="body_rowg"><%=rsQry("gbe_value")%></td>`	477	`<td nowrap class="body_rowg"><%=rsQry("gbe_value")%></td>`
477	`<td nowrap class="body_rowg"><%=Get_Daemon_Mode(rsQry("daemon_mode"))%></td>`	478	`<td nowrap class="body_rowg"><%=Get_Daemon_Mode(rsQry("daemon_mode"))%></td>`
478	`<td nowrap class="body_rowg"><%=Get_Run_Level(currentRunLevel, indefinitelyPaused)%></td>`	479	`<td nowrap class="body_rowg"><%=Get_Run_Level(currentRunLevel, indefinitelyPaused)%></td>`
479	`<td nowrap class="body_rowg"><%=Get_Package_Name(pkgName)%></td>`	480	`<td nowrap class="body_rowg"><%=Get_Package_Name(pkgName)%></td>`
480	`<td nowrap class="body_rowg"><%=rsQry2("delta")%></td>`	481	`<td nowrap class="body_rowg"><%=rsQry2("delta")%></td>`