<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|	           RequestReleaseCombo.asp     	 |
'|                                                   |
'=====================================================
%>
<%
Option explicit
' Good idea to set when using redirect
Response.Expires = 0	' always load the page, dont store
%>
<!--#include file="common/config.asp"-->
<!--#include file="common/globals.asp"-->
<!--#include file="common/formating.asp"-->

<!--#include file="common/common_subs.asp"-->
<!--#include file="common/_rtree_common.asp"-->
<%
'------------ Variable Definition -------------
Dim rsQry
Dim OutString
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
'----------------------------------------------
%>
<%
'------------------------------------------------------------------------------------------------------------------------
'------------------------------------------------------------------------------------------------------------------------
%>
<%
'------------------------ MAIN LINE ---------------------------------
If (Request("branch_id")="") Then
	Response.write "ERROR: Missing Parameters at "& SCRIPT_NAME
End If
'--------------------------------------------------------------------
%>

	<%

	OraDatabase.Parameters.Add "BRANCH_ID", Request("branch_id"),	ORAPARM_INPUT, ORATYPE_NUMBER 
	OraDatabase.Parameters.Add "BOM_ID", NULL,	ORAPARM_INPUT, ORATYPE_NUMBER 	
	
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("SBOMCombo.sql"), cint(0))
	
	
	OraDatabase.Parameters.Remove "BRANCH_ID"
	OraDatabase.Parameters.Remove "BOM_ID"	
	
	
	OutString = NULL
	
	
	While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
		OutString = OutString & rsQry("version") &"|-|"& rsQry("bom_id") &"|-|"& rsQry("selected") &"|+|"
		rsQry.MoveNext
	WEnd
	
	
	If NOT IsNull( OutString ) Then
		' Remove last ;
		OutString = Left( OutString, Len(OutString) - 3 )
	End If
	
	rsQry.Close
	Set rsQry = Nothing
	
	' Render output
	Response.write OutString
	%>
          
<%
Call Destroy_All_Objects
%>