Thanks, Charlie! Rick
> -----Original Message----- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 09, 2008 3:32 PM > To: CF-Talk > Subject: Re: Why won't this insert work? > > On Wed, Apr 9, 2008 at 12:20 PM, Dominic Watson > <[EMAIL PROTECTED]> wrote: > > the following: > > <cfif Len(Trim(no_acres))> > <cfqueryparam cfsqltype="cf_sql_integer" value="#no_acres#"> > <cfelse> > NULL > </cfif> > > can be shortened into: > > <cfqueryparam value="#no_acres#" cfsqltype="cf_sql_integer" null="#not > len(trim(no_acres))#" /> > > -- > Evelyn the dog, having undergone further modification pondered the > significance of short-person behaviour in pedal depressed, > pan-chromatic resonance, and other highly ambient domains. "Arf," she > said. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
