Subversion Repositories DevTools

Rev

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

Rev 4230 Rev 4237
Line 158... Line 158...
158 
   retVal = rsTemp.RecordCount
 158 
   retVal = rsTemp.RecordCount
159 
 
 159 
 
160 
   While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
 160 
   While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
161 
      dim bits
 161 
      dim bits
162 
      bits = Split( rsTemp("iss_key"), "-" ,2)
 162 
      bits = Split( rsTemp("iss_key"), "-" ,2)
- 
 
 163 
      If UBound(bits) > 0 Then
163 
      JIRAIss = JIRAIss & joiner & "(P.pkey = '" & bits(0) & "' AND I.issuenum = " & bits(1) & ")"
 164 
        JIRAIss = JIRAIss & joiner & "(P.pkey = '" & bits(0) & "' AND I.issuenum = " & bits(1) & ")"
164 
      joiner = " OR "
 165 
        joiner = " OR "
- 
 
 166 
      End If
165 
      rsTemp.MoveNext
 167 
      rsTemp.MoveNext
166 
   WEnd
 168 
   WEnd
167 
 
 169 
 
168 
   SSsql = "SELECT P.pkey AS project, I.issuenum AS iss_num, I.summary, ISS.pname AS state,  IT.pname as IssueType, PR.pname as Priority, I.RESOLUTION "&_
 170 
   SSsql = "SELECT P.pkey AS project, I.issuenum AS iss_num, I.summary, ISS.pname AS state,  IT.pname as IssueType, PR.pname as Priority, I.RESOLUTION "&_
169 
           " FROM jiraissue I, issuestatus ISS, issuetype IT, priority PR, project P "&_
 171 
           " FROM jiraissue I, issuestatus ISS, issuetype IT, priority PR, project P "&_