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.
