Subversion Repositories DevTools

Rev

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

Rev 5957 Rev 7291
Line 112... Line 112...
112 
'   Filter by search string
 112 
'   Filter by search string
113 
'   Filter by state
 113 
'   Filter by state
114 
Dim searchJoin : searchJoin = " WHERE "
 114 
Dim searchJoin : searchJoin = " WHERE "
115 
Dim searchString : searchString = ""
 115 
Dim searchString : searchString = ""
116 
If Request.QueryString("search[value]") <> "" Then
 116 
If Request.QueryString("search[value]") <> "" Then
117 
    searchString = searchJoin & "upper(pkg_name) || '_' || UPPER(pkg_version) LIKE upper('%" & Request.QueryString("search[value]") & "%')"
117 
    searchString = searchJoin & "upper(pkg_name) || '_' || UPPER(pkg_version) LIKE upper('" & Request.QueryString("search[value]") & "')"
118 
    searchJoin = " AND "
 118 
    searchJoin = " AND "
119 
End If
 119 
End If
120 
 
 120 
 
121 
If sdk_statefilter Then
 121 
If sdk_statefilter Then
122 
    searchString = searchString & searchJoin & "sdkpkg_state in ('E') OR REF_SDKPKG_STATE in ('E')"
 122 
    searchString = searchString & searchJoin & "sdkpkg_state in ('E') OR REF_SDKPKG_STATE in ('E')"