that's got nothing to do with your database. you're referencing a form field (#form.name#) that doesn't exist. according to the error, you have no form field with the name "name". if there is one and it's a checkbox or radio group (and none are checked or selected), they don't get passed into the form scope. you'll need to param them in the form's action:
<cfparam name="form.name" default="" type="string" /> bear in mind that this is not a NULL value. it's an empty string. if you want to insert a true NULL into the database, you'll need to do: <cfqueryparam value="#form.name#" cfsqltype="cf_sql_char" null="#not len(trim(form.name))#" /> On Thu, Dec 4, 2008 at 8:17 AM, John P <[EMAIL PROTECTED]> wrote: > I have a form which is throwing the following error upon submit: > > "Element NAME is undefined in FORM" > > The field is set to allow nulls in the database. Is there something else I > should be doing to allow a null value to be passed? > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
