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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
