again thanks, and since i'm on a roll,
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" >
<input type="hidden" name="pol_ID" value="#url.pol_ID#">
</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>
>From: "janey smith" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: <cfif> problem
>Date: Tue, 11 Jul 2000 11:36:11 GMT
>
>thanks a lot , that did the trick!
>
>
> >From: Nick Slay <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: <[EMAIL PROTECTED]>
> >Subject: Re: <cfif> problem
> >Date: Tue, 11 Jul 2000 21:23:25 +1000
> >
> >Hi,
> >
> >try this ....
> >
> >
> ><CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > <CFIF #trim(form.ans_answer1)# IS "">
> > VALUES ('�', #ans_pol_id#)
> > <CFELSE>
> > VALUES ('#form.ans_Answer1#', #ans_pol_id#)
> > </CFIF>
> ></CFQUERY>
> >
> ><CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > <CFIF #trim(form.ans_answer2)# IS "">
> > VALUES ('�', #ans_pol_id#)
> > <CFELSE>
> > VALUES ('#form.ans_Answer2#', #ans_pol_id#)
> > </CFIF>
> ></CFQUERY>
> >etc etc etc
> >
> >
> >alternately, you could try this..
> >
> ><CFPARAM NAME="ans_Answer1" DEFAULT="�">
> ><CFPARAM NAME="ans_Answer2" DEFAULT="�">
> ><CFPARAM NAME="ans_Answer3" DEFAULT="�">
> ><CFPARAM NAME="ans_Answer4" DEFAULT="�">
> ><CFPARAM NAME="ans_Answer5" DEFAULT="�">
> >
> ><CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > VALUES ('#ans_Answer1#', #ans_pol_id#)
> ></CFQUERY>
> >
> ><CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > VALUES ('#ans_Answer2#', #ans_pol_id#)
> ></CFQUERY>
> >etc etc etc
> >
> >and repeat either for your five answers. You could probably also do this
> >using loops and slightly different naming on the form, but this will work
> >for now!!
> >
> >Hope this helps
> >
> >Regards
> >
> >Nick
> >
> > > From: "janey liston" <[EMAIL PROTECTED]>
> > > Reply-To: [EMAIL PROTECTED]
> > > Date: Tue, 11 Jul 2000 11:08:50 GMT
> > > To: [EMAIL PROTECTED]
> > > Subject: <cfif> problem
> > >
> > > I'M WORKING ON A POLL. I HAVE A NEW POLL FORM, WITH 5 FIELDS FOR THE
> > > ANSWERS, 1-5. ON MY ACTION PAGE I WANT TO DO A CHECK TO SEE IF THE
>FORM
> > > FIELD FOR EACH ANSWER IS EMPTY, IF A VALUE HAS BEEN ENTERED I WANT TO
> >INSERT
> > > INTO THE DATABASE OTHERWISE INSERT "�" IF THE FORM FIELD IS BLANK.
> > >
> > > HERE'S MY CODE, AS IT STANDS THE ERROR I'M GETTING IS,
> > >
> > > Just in time compilation error
> > >
> > > An extraneous end tag </CFIF> has been encountered at document
>position
> > > (35:1) to (35:7). End tags cannot be present in CFML templates without
>a
> > > matching start tag.
> > >
> > >
> > >
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > <CFIF #trim(form.ans_answer1)# IS "">
> > > VALUES ('�', #ans_pol_id#)
> > > </CFQUERY>
> > > <CFELSE>
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > VALUES ('#form.ans_Answer1#', #ans_pol_id#)
> > > </CFQUERY>
> > >
> > >
> > >
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > <CFIF #trim(form.ans_answer2)# IS "">
> > > VALUES ('�', #ans_pol_id#)
> > > </CFQUERY>
> > > <CFELSE>
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > VALUES ('#form.ans_Answer2#', #ans_pol_id#)
> > > </CFQUERY>
> > >
> > >
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > <CFIF #trim(form.ans_answer3)# IS "">
> > > VALUES ('�', #ans_pol_id#)
> > > </CFQUERY>
> > > <CFELSE>
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > VALUES ('#form.ans_Answer3#', #ans_pol_id#)
> > > </CFQUERY>
> > >
> > >
> > >
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > <CFIF #trim(form.ans_answer4)# IS "">
> > > VALUES ('�', #ans_pol_id#)
> > > </CFQUERY>
> > > <CFELSE>
> > > <CFQUERY DATASOURCE ="quickpoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > VALUES ('#form.ans_Answer4#', #ans_pol_id#)
> > > </CFQUERY>
> > >
> > >
> > > <CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > <CFIF #trim(form.ans_answer5)# IS "">
> > > VALUES ('�', #ans_pol_id#)
> > > </CFQUERY>
> > > <CFELSE>
> > > <CFQUERY DATASOURCE ="quickpoll" NAME ="addanswer">
> > > INSERT INTO ans_answer (ans_ans, ans_pol_id)
> > > VALUES ('#form.ans_Answer5#', #ans_pol_id#)
> > > </CFQUERY>
> > >
> > >
> > > thanks a lot for any help
> > >
>________________________________________________________________________
> > > 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?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.
________________________________________________________________________
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.
