Are your DB table columns set to accept null values? If they are not you can't insert one. But if they are set to accept them it will accept the form data even if it is blank(null). Then you shouldn't need to use cfparam or anything in you action page. And if your <cfinput> tag is catching all the required feilds before it's passed to the action template or insert statement then you should have no problems.
Thanks, Clint >Thats a SQL error you're getting there TG not something to do with your >HTML/CFML. > >Any chance of a bit more expanded code for the SQL and possibly the form >that the SQL gets its info from? > >Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1175 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
