| Line 40... |
Line 40... |
| 40 |
%>
|
40 |
%>
|
| 41 |
<%
|
41 |
<%
|
| 42 |
'------------------------ MAIN LINE ---------------------------------
|
42 |
'------------------------ MAIN LINE ---------------------------------
|
| 43 |
'--------------------------------------------------------------------
|
43 |
'--------------------------------------------------------------------
|
| 44 |
%>
|
44 |
%>
|
| 45 |
<table width="100%" border="0" cellspacing="1" cellpadding="4">
|
45 |
<table width="100%" border="0" cellspacing="1" cellpadding="4" class='stdGrey'>
|
| - |
|
46 |
<thead>
|
| 46 |
<tr>
|
47 |
<tr>
|
| 47 |
<td width="1%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col"></td>
|
48 |
<th width="1%"></th>
|
| 48 |
<td width="100%" background="images/bg_form_lightbluedark.gif" nowrap class="body_col">Project</td>
|
49 |
<th width="100%">Project</th>
|
| 49 |
</tr>
|
50 |
</tr>
|
| - |
|
51 |
</thead>
|
| 50 |
<%
|
52 |
<%
|
| 51 |
OraDatabase.Parameters.Add "MATCH", parMode, ORAPARM_INPUT, ORATYPE_NUMBER
|
53 |
OraDatabase.Parameters.Add "MATCH", parMode, ORAPARM_INPUT, ORATYPE_NUMBER
|
| 52 |
OraDatabase.Parameters.Add "PV_ID", parPvId, ORAPARM_INPUT, ORATYPE_NUMBER
|
54 |
OraDatabase.Parameters.Add "PV_ID", parPvId, ORAPARM_INPUT, ORATYPE_NUMBER
|
| 53 |
|
55 |
|
| 54 |
Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("UsedByProjects.sql"), cint(0) )
|
56 |
Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("UsedByProjects.sql"), cint(0) )
|
| Line 56... |
Line 58... |
| 56 |
OraDatabase.Parameters.Remove "MATCH"
|
58 |
OraDatabase.Parameters.Remove "MATCH"
|
| 57 |
OraDatabase.Parameters.Remove "PV_ID"
|
59 |
OraDatabase.Parameters.Remove "PV_ID"
|
| 58 |
%>
|
60 |
%>
|
| 59 |
<%If rsTemp.RecordCount < 1 Then%>
|
61 |
<%If rsTemp.RecordCount < 1 Then%>
|
| 60 |
<tr>
|
62 |
<tr>
|
| 61 |
<td background="images/bg_form_lightgray.gif" nowrap class="form_item"> </td>
|
63 |
<td> </td>
|
| 62 |
<td background="images/bg_form_lightgray.gif" nowrap class="form_item">None Found</td>
|
64 |
<td>None Found</td>
|
| 63 |
</tr>
|
65 |
</tr>
|
| 64 |
<%End If%>
|
66 |
<%End If%>
|
| 65 |
<%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
|
67 |
<%While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
|
| 66 |
projId = rsTemp("proj_id")
|
68 |
projId = rsTemp("proj_id")
|
| 67 |
projName = rsTemp("proj_name")
|
69 |
projName = rsTemp("proj_name")
|
| 68 |
projCount = rsTemp("used_count")
|
70 |
projCount = rsTemp("used_count")
|
| 69 |
divId = "PROJID_" & parMode & "_" & projId
|
71 |
divId = "PROJID_" & parMode & "_" & projId
|
| 70 |
%>
|
72 |
%>
|
| 71 |
<tr>
|
73 |
<tr>
|
| 72 |
<td background="images/bg_form_lightgray.gif" class="form_item"></td>
|
74 |
<td></td>
|
| 73 |
<td nowrap background="images/bg_form_lightgray.gif" class="form_item">
|
75 |
<td nowrap>
|
| 74 |
<a href="javascript:;" class="txt_linked" onClick="ToggleLoadControl('<%=divId%>','RequestUsedByThisProject.asp?pv_id=<%=parPvId%>&proj_id=<%=projId%>&mode=<%=parMode%>');">
|
76 |
<a href="javascript:;" class="txt_linked" onClick="ToggleLoadControl('<%=divId%>','RequestUsedByThisProject.asp?pv_id=<%=parPvId%>&proj_id=<%=projId%>&mode=<%=parMode%>');">
|
| 75 |
<img id=IMG_<%=divId%> src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3">
|
77 |
<img id=IMG_<%=divId%> src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3">
|
| 76 |
<%= projName &" ("& projCount &")"%>
|
78 |
<%= projName &" ("& projCount &")"%>
|
| 77 |
</a>
|
79 |
</a>
|
| 78 |
<DIV class="form_item" id="<%=divId%>" style="display:none;"><%=enumLOADING%></DIV>
|
80 |
<DIV id="<%=divId%>" style="display:none;"><%=enumLOADING%></DIV>
|
| 79 |
</td>
|
81 |
</td>
|
| 80 |
</tr>
|
82 |
</tr>
|
| 81 |
|
83 |
|
| 82 |
<%rsTemp.MoveNext
|
84 |
<%rsTemp.MoveNext
|
| 83 |
WEnd
|
85 |
WEnd
|