You want to use the cfparam tag then to set default paramters. <cfparam name="form.asking1" default=""> <cfparam name="form.asking2" default="">
<!--- sql insert ---> Now when you do the insert it will either enter the default which in this case is an empty string (it can be anything) or if form.asking1 or 2 isdefined on submit it will grab those values. Dan On 12/21/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > No, it is not the syntax that is the problem. What happens when the user > does not enter any information into one of the two fields, then I need to > be > able to add a default value to the database. If a user enters an amount, > then I need to place that info in the database. I hope this makes sense. > > Doug B. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4