Thanks Charlie, it was a group of radio buttons. <cfparam name="form.name" default="" type="string" />
did the trick. >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: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:316270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
