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 "&_