Subversion Repositories DevTools

Rev

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

Rev 159 Rev 161
Line 152... Line 152...
152
   Set rsProjId = OraDatabase.DbCreateDynaset("SELECT PROJ_ID FROM RELEASE_TAGS WHERE RTAG_ID ="& Request("rtag_id") &"", cint(0))
152
   Set rsProjId = OraDatabase.DbCreateDynaset("SELECT PROJ_ID FROM RELEASE_TAGS WHERE RTAG_ID ="& Request("rtag_id") &"", cint(0))
153
   If rsProjId("proj_id") = 202 Then
153
   If rsProjId("proj_id") = 202 Then
154
      pkey = "SLSIP"
154
      pkey = "SLSIP"
155
   Elseif rsProjId("proj_id") = 42 Then
155
   Elseif rsProjId("proj_id") = 42 Then
156
      pkey = "SFRM"
156
      pkey = "SFRM"
-
 
157
   Elseif rsProjId("proj_id") = 621 Then
-
 
158
      pkey = "COCT"
157
   End If
159
   End If
158
 
160
 
159
      SQLstr = _
161
      SQLstr = _
160
      "SELECT project.pkey as project, I.pkey AS iss_num, I.summary, ISS.pname AS state "&_
162
      "SELECT project.pkey as project, I.pkey AS iss_num, I.summary, ISS.pname AS state "&_
161
      "FROM jiraissue I, project, issuestatus ISS "&_
163
      "FROM jiraissue I, project, issuestatus ISS "&_