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:3822
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
