Subversion Repositories DevTools

Rev

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

Rev 125 Rev 5382
Line 33... Line 33...
33 
' The function relies upon the user of this ASP file having setup the Interval parameter as needed (see RequestReleasePackages.asp)
 33 
' The function relies upon the user of this ASP file having setup the Interval parameter as needed (see RequestReleasePackages.asp)
34 
Function formQueryString2
 34 
Function formQueryString2
35 
 
 35 
 
36 
   Dim qs
 36 
   Dim qs
37 
 
 37 
 
38 
   qs  = " SELECT pv_id, last_pv_id, pkg_id, pkg_version, v_ext, created_stamp, modified_stamp FROM package_versions " _
 38 
   qs  = " SELECT pv_id, last_pv_id, pkg_id, pkg_version, v_ext, created_stamp, TO_CHAR( modified_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS modified_stamp FROM package_versions " _
39 
       & " CONNECT BY NOCYCLE PRIOR last_pv_id = pv_id            " _
 39 
       & " CONNECT BY NOCYCLE PRIOR last_pv_id = pv_id            " _
40 
       & " START WITH pv_id = :PV_ID                              " _
 40 
       & " START WITH pv_id = :PV_ID                              " _
41 
       & " ORDER BY pv_id DESC                                    "
 41 
       & " ORDER BY pv_id DESC                                    "
42 
 
 42 
 
43 
   formQueryString2 = qs
 43 
   formQueryString2 = qs
Line 107... Line 107...
107 
                        </td>
 107 
                        </td>
108 
                        <td nowrap class="body_txt" background="images/bg_form_lightgray.gif">
 108 
                        <td nowrap class="body_txt" background="images/bg_form_lightgray.gif">
109 
                           <%If rsMetrics("autotested") = "Y" Then%>Yes<%Else%>No<%End If%>
 109 
                           <%If rsMetrics("autotested") = "Y" Then%>Yes<%Else%>No<%End If%>
110 
                        </td>
 110 
                        </td>
111 
                        <td nowrap class="body_txt" background="images/bg_form_lightgray.gif"><%=rsMetrics("branches")%></td>
 111 
                        <td nowrap class="body_txt" background="images/bg_form_lightgray.gif"><%=rsMetrics("branches")%></td>
112 
                        <td nowrap class="body_txt" background="images/bg_form_lightgray.gif"><%=EuroDate(rsTemp("modified_stamp"))%></td>
 112 
                        <td nowrap class="body_txt" background="images/bg_form_lightgray.gif"><%=rsTemp("modified_stamp")%></td>
113 
                     </tr>
 113 
                     </tr>
114 
                  <%
 114 
                  <%
115 
                  End If
 115 
                  End If
116 
                  rsTemp.MoveNext
 116 
                  rsTemp.MoveNext
117 
                  rsMetrics.Close
 117 
                  rsMetrics.Close