Subversion Repositories DevTools

Rev

Rev 5513 | Rev 5958 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5513 Rev 5955
Line 270... Line 270...
270 
		  OraDatabase.Parameters.Add "enumAUTOPRODUCTS_BASE_VIEW_ID", 	enumAUTOPRODUCTS_BASE_VIEW_ID,				ORAPARM_INPUT, ORATYPE_NUMBER
270 
		  OraDatabase.Parameters.Add "enumAUTOPRODUCTS_BASE_VIEW_ID", 	enumAUTOPRODUCTS_BASE_VIEW_ID,				ORAPARM_INPUT, ORATYPE_NUMBER
271 
		  OraDatabase.Parameters.Add "OS_ID", 						parOs_id,								ORAPARM_INPUT, ORATYPE_NUMBER
271 
		  OraDatabase.Parameters.Add "OS_ID", 						parOs_id,								ORAPARM_INPUT, ORATYPE_NUMBER
272
272
273 
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseManagerProductsView.sql"), ORADYN_DEFAULT )
 273 
		  Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("ReleaseManagerProductsView.sql"), ORADYN_DEFAULT )
274
274
- 
 
 275 
		  OraDatabase.Parameters.Remove "RTAG_ID_FK"
- 
 
 276 
		  OraDatabase.Parameters.Remove "enumPRODUCTS_BASE_VIEW_ID"
- 
 
 277 
		  OraDatabase.Parameters.Remove "enumAUTOPRODUCTS_BASE_VIEW_ID"
- 
 
 278 
		  OraDatabase.Parameters.Remove "OS_ID"
- 
 
 279 
 
275 
		  If rsQry.RecordCount < 1 Then
 280 
		  If rsQry.RecordCount < 1 Then
276 
		  	Response.write "No Products Found."
 281 
		  	Response.write "No Products Found."
277 
		  End If
 282 
		  End If
278
283
279 
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 284 
		  While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
Line 308... Line 313...
308 
              <td nowrap class="body_txt"><%=LIMG_PRODUCT_PATCH%><%=rsQry("pkg_name") &" "& rsQry("pkg_version")%></td>
 313 
              <td nowrap class="body_txt"><%=LIMG_PRODUCT_PATCH%><%=rsQry("pkg_name") &" "& rsQry("pkg_version")%></td>
309 
            </tr>
 314 
            </tr>
310 
            <%rsQry.MoveNext%>
 315 
            <%rsQry.MoveNext%>
311 
            <%
 316 
            <%
312 
		  WEnd
 317 
		  WEnd
313
- 
 
314
- 
 
315
- 
 
316 
		  OraDatabase.Parameters.Remove "RM_BRANCH_ID"
 - 
 
317 
		  OraDatabase.Parameters.Remove "enumPRODUCTS_BASE_VIEW_ID"
 - 
 
318 
		  OraDatabase.Parameters.Remove "enumAUTOPRODUCTS_BASE_VIEW_ID"
- 
 
319 
		  OraDatabase.Parameters.Remove "OS_ID"
 - 
 
320
- 
 
321 
	  End If
 318 
	  End If
322 
	  %>
 319 
	  %>
323 
          </table></td>
 320 
          </table></td>
324 
        <td width="1" valign="top" class="body_txt"><img src="images/spacer.gif" width="1" height="320"></td>
 321 
        <td width="1" valign="top" class="body_txt"><img src="images/spacer.gif" width="1" height="320"></td>
325 
      </tr>
 322 
      </tr>