I have with 3 search fields, pol_question, pol_category, pol_status, i am
posting the results to the same page, i get this error
An error occurred while evaluating the expression:
#trim(form.pol_question)# IS NOT ""
Error near line 66, column 32.
--------------------------------------------------------------------------------
Error resolving parameter FORM.POL_QUESTION
The specified form field cannot be found. This problem is very likely due to
the fact that you have misspelled the form field name.
i have checked the formfield names and they are correct, here's the code,
any help would be greatly appreciated.
<STRONG><a href="pollnew2.cfm">New Poll</a></STRONG>
<FORM name="frmSearch" action="polladmin2.cfm" method="post">
<tr>
<td width=117><font face=Verdana size=2><strong>Poll</strong></font>
</td>
<td width="119"><font face=Verdana size=2><strong>Poll Category
</strong></font></td>
<td width="127"><font face=Verdana size=2><strong>Poll
Status</strong></font></td>
<td width="187"> </td>
</tr>
<tr>
<td width=117>
<input maxlength="50" name="pol_question" type="TEXT" >
</td>
<td width="119">
<select name="pol_category" size=1>
<CFQUERY NAME="CategoryList" DATASOURCE="quickpoll">
Select DISTINCT pol_Category from pol_Poll
</CFQUERY>
<option value="All">All</option>
<option value="Sports">Sports</option>
<option value="Current Affairs">Current Affairs</option>
<option value="General">General</option>
</select>
</td>
<td width="127">
<select name="pol_status" size=1>
<option value="All">All</option>
<option value="New">New</option>
<option value="Active">Active</option>
<option value="Archive">Archive</option>
<option value="Hidden">Hidden</option>
</select>
</td>
<td width="187">
<input type="submit" value="search" name="submit">
</td>
</tr>
</tbody>
</table>
</FORM>
<P><BR>
</P>
<P><BR>
</P>
<!--Logic to display search results-->
<CFIF NOT ISDEFINED("form.frmsearch")>
<CFQUERY NAME="PollSearch" DATASOURCE="quickpoll">
Select * from pol_Poll
Where 0=0
<CFIF #trim(form.pol_question)# IS NOT "">
And pol_question like '%#pol_question#%'
</CFIF>
<CFIF #trim(form.pol_category)# IS NOT "">
And pol_Category = '#form.pol_category#'
</CFIF>
<CFIF #trim(form.pol_status)# IS NOT "">
And pol_Status = '#form.pol_status#'
</CFIF>
</CFQUERY>
<form NAME="frmSearchResults" ACTION="pollUpAll.cfm" METHOD="POST">
<tr>
<td width=8> </td>
<td><font face=Verdana size=3><b>Polls</b></font><br> </td>
</tr>
<CFLOOP QUERY="PollSearch">
<CFOUTPUT>
<table border=0>
<tr>
<td width=8> </td>
<td><font face=Verdana size=2>
<strong>
<a href="Pollupdate.cfm?PollID=#pol_ID#">#pol_Question#</a>
</strong>
<br>#pol_Category#|#pol_CreateDateTime#|#pol_status#</font>
</td>
</tr></tr>
</table>
</CFOUTPUT>
</CFLOOP>
</form>
<CFELSE>
<input type="submit" value="Update" name="update">
<!---Search not hit Display Nothing --->
</CFIF>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
