| Line 57... |
Line 57... |
| 57 |
" cq_devi.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
57 |
" cq_devi.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
| 58 |
" cq_devi.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
58 |
" cq_devi.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
| 59 |
" cq_devi.admin.users ap ON si.approver = ap.dbid"&_
|
59 |
" cq_devi.admin.users ap ON si.approver = ap.dbid"&_
|
| 60 |
" WHERE si.dbid = "& NNiss_id
|
60 |
" WHERE si.dbid = "& NNiss_id
|
| 61 |
|
61 |
|
| 62 |
ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
|
- |
|
| 63 |
SQLstr = _
|
- |
|
| 64 |
" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
|
- |
|
| 65 |
" si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
|
- |
|
| 66 |
" ap.fullname AS approver, si.description"&_
|
- |
|
| 67 |
" FROM CQ_VT5DM.admin.software_issue si INNER JOIN"&_
|
- |
|
| 68 |
" CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
|
- |
|
| 69 |
" CQ_VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
- |
|
| 70 |
" CQ_VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
- |
|
| 71 |
" CQ_VT5DM.admin.users ap ON si.approver = ap.dbid"&_
|
- |
|
| 72 |
" WHERE si.dbid = "& NNiss_id
|
- |
|
| 73 |
|
- |
|
| 74 |
End If
|
- |
|
| 75 |
|
- |
|
| 76 |
OOrsCQ.ActiveConnection = CQ_conn
|
62 |
OOrsCQ.ActiveConnection = CQ_conn
|
| 77 |
OOrsCQ.Source = SQLstr
|
63 |
OOrsCQ.Source = SQLstr
|
| 78 |
OOrsCQ.CursorType = 0
|
64 |
OOrsCQ.CursorType = 0
|
| 79 |
OOrsCQ.CursorLocation = 2
|
65 |
OOrsCQ.CursorLocation = 2
|
| 80 |
OOrsCQ.LockType = 3
|
66 |
OOrsCQ.LockType = 3
|
| Line 113... |
Line 99... |
| 113 |
End If
|
99 |
End If
|
| 114 |
|
100 |
|
| 115 |
|
101 |
|
| 116 |
End Sub
|
102 |
End Sub
|
| 117 |
%>
|
103 |
%>
|
| 118 |
<%If parIss_db <> enumCLEARQUEST_DEVI_ID AND parIss_db <> enumCLEARQUEST_VT5DM_ID Then Call RaiseMsg ( enum_WMSG_ERROR, "This option is not available for this issue's database!" )%>
|
104 |
<%If parIss_db <> enumCLEARQUEST_DEVI_ID Then Call RaiseMsg ( enum_WMSG_ERROR, "This option is not available for this issue's database!" )%>
|
| 119 |
<%Call Get_Issue_Details ( parIss_db, parIss_id, rsCQ )%>
|
105 |
<%Call Get_Issue_Details ( parIss_db, parIss_id, rsCQ )%>
|
| 120 |
<!--#include file="_menu_def.asp"-->
|
106 |
<!--#include file="_menu_def.asp"-->
|
| 121 |
<html>
|
107 |
<html>
|
| 122 |
<head>
|
108 |
<head>
|
| 123 |
<title><%=rsCQ("iss_num")%> - <%=rsCQ("summary")%></title>
|
109 |
<title><%=rsCQ("iss_num")%> - <%=rsCQ("summary")%></title>
|