Below is my action page: Please help,
Code:
<cfquery datasource="digitalnewspapers1" name="digitalnewspapers1">
SELECT digitalnewspapers1.filename, digitalnewspapers1.dateofissue, digitalnewspapers1.county, digitalnewspapers1.title
From digitalnewspapers1
WHERE 0=0
<cfif #FORM.filename# is not "">
AND FILENAME LIKE '%#FORM.FILENAME#%'
</cfif>
<cfif #FORM.County# is not "">
AND COUNTY LIKE '%#FORM.COUNTY#%'
</cfif>
<cfif #FORM.Title# is not "">
AND TITLE LIKE'%#FORM.TitlE#%'
</cfif>
ORDER BY FILENAME
</cfquery>
<table width="100%" cellpading="0" border="1">
<tr>
<TH class="style9 style1">FILE</th>
<TH class="style9 style1">Dateofissue</th>
<TH class="style9 style1">COUNTY</th>
<TH class="style9 style1">Title</th>
</tr>
<cfoutput query="digitalnewspapers1">
<tr>
<td class="style9"><cfif #digitalnewspapers1.filename# is ""> <cfelse>
<span class="style1">#FILE#</span>
</cfif></td>
<td align="center" class="style9"><cfif #digitalnewspapers1.dateofissue# is ""> <cfelse>
<span class="style1">#DATEOFISSUE#</span>
</cfif></td>
<td align="center" class="style9"><cfif #digitalnewspapers1.county# is ""> <cfelse>
<span class="style1">#COUNTY#</span>
</cfif></td>
<td align="center" class="style9"><cfif #digitalnewspapers1.title# is ""> <cfelse>
<span class="style1">#TITLE#</span>
</cfif></td>
</tr>
</cfoutput>
</table>
<html>