thanks a lot for your help, got that probelm sorted now
>From: "Chris Ivey" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Re: <cfif> problem
>Date: Wed, 12 Jul 2000 8:39:03 -0400
>
>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?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.
