Hi Leonard, I just figured this out with lots of help from greg. You can see my last post to see the code that I used. I will just this out tonight, thanks so much for your help:)
John ----- Original Message ---- From: Leonard Boche <[EMAIL PROTECTED]> To: CF-Newbie <[email protected]> Sent: Saturday, July 12, 2008 8:53:11 PM Subject: Re: CF & MySQL Troubl Hi John, Following along the path of Greg, try using a <cfquery> insert instead of <cfinsert> and try the code below: <cfquery name="qname" datasource="YourDataSource"> Insert Into Newsletter ( name , email , emailType ) Values ( nullif('#form.name#','') , nullif('#form.email#','') , nullif('#form.emailType#','') ) </cfquery> This should insert a (Null) value into the database should the person not provide field information. For numeric or date fields remove the single quote(s) before and after the # symbols. I use this code method all the time for eforms I create. Plus you can use the (Null) value in your queries, to eliminate them during processes should the need arise. You can also add a required and message form element attribute to your form, which will require the field to be filled in before submission can occur. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3824 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
