any ideas on where i'm going wrong, thanks
>From: "janey smith" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: post results to same page
>Date: Tue, 11 Jul 2000 13:52:13 GMT
>
>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/cf-talk@houseoffusion.com/
>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.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
