I'm not real sure if this is what your asking, but here's a quick try at an answer...
***Form Page*** <form name="testForm" method="Post"> <input type="text" name="foo"> <input type="submit" value="Submit"> </form> ***Processing Page*** <cfparam name="form.foo" default="0"> This will create form.foo ONLY if it does not exists. If it does exists, the value of "foo" will be what was submitted from the original form page, EVEN if it is null. To change the value, use <cfif form.foo eq ""> <cfset form.foo = 0> </cfif> However it may be easier to change it in the SQL with (guessing MSSQL Server?) Insert into .... IsNull(#form.foo#,0), .... <cfoutput> #form.foo# </cfoutput> -----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Friday, June 24, 2005 2:22 PM To: CF-Newbie Subject: Re: Need help - deadline 5pm Yes, did that and it still doesn't work Get an error >what I do it use <cfparams on the processing page.. >one for each form field. Set a default to "" if need be, and then if >further checking is needed use <cfif> statements.. Here's an example.. > ><cfparam name="form.accessorysales" default="0" type="numeric"/> ><cfparam name="form.additionalcomments" default="" type="string" /> ><cfparam name="form.bsrleadinfo_id" default="0" type="numeric"/> ><cfparam name="form.bsr_posnbr" default="" type="string" /> <cfparam >name="form.businessSolutionsIntroduce" default="" type="string" /> > >Then I can check based off of the default values.. ><cfif form.accessorysales neq 0> > ... ><cfelse> >... ></cfif> >Make sense? > > > > > >On 6/24/05, Torrent Girl <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Save $10 Download ZoneAlarm Security Suite http://www.houseoffusion.com/banners/view.cfm?bannerid=66 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1220 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
