I think your logic is a little backwards, for example in a preceding CFIF you state:
<CFIF NOT ISDEFINED("form.frmsearch")>
in the spot where form.frmsearch is though, you have form.question. Wouldn't it be
logical for form.frmsearch to be there so form.question can be there?
In short you need form.frmsearch to be defined for form.question to be defined,
reroute so the CFIF looks like this:
<CFIF ISDEFINED("form.frmsearch")>
Then retool your other logic appropriately.
Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 07/11 8:38 AM >>>
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/[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.
________________________________________________________________________
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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
