Rick, It may be time to make yourself acquainted with the wonderful world of code generators. Here is a partial list of the various offerings. I make heavy use of cfcgenerator and cfcblaster. I rarely create CRUD's by hand.
http://code.google.com/p/cfcgenerator/ http://completecodegen.riaforge.org/ http://beanmachine.riaforge.org/ http://mrmx.blogspot.com/2006/09/cfcblaster-simple-code-generator.html http://cfcstub.riaforge.org/ Happy coding. ~G~ On Tue, Oct 28, 2008 at 3:46 PM, Rick Sanders <[EMAIL PROTECTED]> wrote: > Is that the only way? > > It's a questionnaire form with 50 questions! You mean I have to do a <cfif> > for every question and assign it a blank value if there's no value!? > > -----Original Message----- > From: Rob Parkhill [mailto:[EMAIL PROTECTED] > Sent: October-28-08 4:42 PM > To: cf-talk > Subject: Re: Adding & Updating empty values > > wrap it in a <cfif> so.. > <cfif isundefined("form.q1")> > <cfset form.q1 = ""> > </cfif> > > Rob > > On Tue, Oct 28, 2008 at 3:33 PM, Rick Sanders <[EMAIL PROTECTED]> wrote: > > > Hey all, > > > > > > > > In my form some values may be left empty. For example a form field named > > q1. > > > > It's fine if it's empty because the user can go back and fill it in later > > if > > they wish. > > > > > > > > How do I get passed the "q1 is not defined in Form" CF error? All I want > to > > do is enter an empty value. How can I allow it to do that for insert and > > updates? > > > > > > > > Thanks! > > > > > > > > LogoSig > > > > Rick Sanders > > > > Webenergy > > > > Canada: 902-431-7279 > > > > USA: 919-799-9076 > > > > Canada: www.webenergy.ca > > > > USA: www.webenergyusa.com > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4