Janey,
This is a response to the CF-Talk question you posted
There is a couple of things I notice about your code. First, is that I do not see any
</CFIF> statements in that code. That may be part of the problem. Second, it seems
like you are doing a lot of extra coding in that statement. Maybe try to rewrite it
something like 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>
<CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
INSERT INTO ans_answer (ans_ans, ans_pol_id)
<CFIF #trim(form.ans_answer3)# IS "">
VALUES ('�', #ans_pol_id#)
<CFELSE>
VALUES ('#form.ans_Answer3#', #ans_pol_id#)
</CFIF>
</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#)
<CFELSE>
VALUES ('#form.ans_Answer4#', #ans_pol_id#)
</CFIF>
</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#)
<CFELSE>
VALUES ('#form.ans_Answer5#', #ans_pol_id#)
</CFIF>
</CFQUERY>
If you do not want to write the code in that method, and wish to stay with your
original formatting, try this (only answer1 is included):
<CFIF #trim(form.ans_answer1)# IS "">
<CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
INSERT INTO ans_answer (ans_ans, ans_pol_id)
VALUES ('�', #ans_pol_id#)
</CFQUERY>
<CFELSEIF #trim(form.ans_answer1)# IS NOT "">
<CFQUERY DATASOURCE ="quickPoll" NAME ="addanswer">
INSERT INTO ans_answer (ans_ans, ans_pol_id)
VALUES ('#form.ans_Answer1#', #ans_pol_id#)
</CFQUERY>
...
Hope this helps!
Chris Ivey
MTS Systems Engineer
GTE Data Services: Temple Terrace, Florida
TSS Distributed - WAN Tools Group
Office: (813) 978-4844
Pager: (813) 303-1177
AIM: IveyAtGTEDS
------------------------------------------------------------------------------
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.
