<!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
    </SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM IC_T_Notification_Occurrences WHERE NAME LIKE '%" & Replace(request.form("store"),"'","''")&"%'"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=8 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=100
fp_iCommandType=1
fp_iPageSize=50
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes=""
fp_iDisplayCols=8
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<%=FP_FieldVal(fp_rs,"NAME")%>
<%=FP_FieldVal(fp_rs,"CLASS")%>
<%=FP_FieldVal(fp_rs,"NOTIFIEDAT")%><p></p><!--#include file="_fpclass/fpdbrgn2.inc"-->

If trim(request.form("store"))&"" <> "" Then 
varString = trim(replace(request.form("store"), "'","''")) 
arrString = Split(varString, " ") 
mySQL = "SELECT * FROM IC_T_Notification_Occurrences WHERE NAME LIKE '%"&arrString(0)&"%' order by NOTIFIEDAT DESC" 
If Ubound(arrString)> 0 Then 
For i = 1 to Ubound(arrString) 
mySQL = mySQL & " AND [store] LIKE '%"&arrString(i)&"%' " 
Next 
End If 
Else
mySQL = "SELECT * FROM IC_T_Notification_Occurrences" 
End If 
fp_sQry = mySQL