Subversion Repositories DevTools

Rev

Rev 4170 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4170 Rev 4293
Line 526... Line 526...
526 
                           <%
 526 
                           <%
527 
                           ' Get the number of release configurations for this RTAG_ID, and iterate through them
 527 
                           ' Get the number of release configurations for this RTAG_ID, and iterate through them
528 
                           query_string = " select * from release_config rc, gbe_machtype gm, build_machine_config bm"&_
 528 
                           query_string = " select * from release_config rc, gbe_machtype gm, build_machine_config bm"&_
529 
                                          "  where rc.rtag_id = "& parRtagId &_
 529 
                                          "  where rc.rtag_id = "& parRtagId &_
530 
                                          "    and gm.gbe_id = rc.gbe_id"&_
 530 
                                          "    and gm.gbe_id = rc.gbe_id"&_
531 
                                          "    and rc.daemon_hostname = bm.machine_hostname(+)" &_
 531 
                                          "    and rc.bmcon_id=bm.bmcon_id(+)" &_
532 
                                          "  order by rc.daemon_hostname,rc.rcon_id"
 532 
                                          "  order by bm.display_name, rc.rcon_id"
533 
 
 533 
 
534 
                           Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
 534 
                           Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
535 
 
 535 
 
536 
                           Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 536 
                           Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
537 
                              rcon_id = rsQry("rcon_id")
 537 
                              rcon_id = rsQry("rcon_id")