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/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.
