Len(Trim(value)) EQ 0 If the value doesn't exist, simply use IsDefined()
> -----Original Message----- > From: "Luce>,Greg" <[EMAIL PROTECTED] [mailto:"Luce>,Greg" > <[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 10:41 AM > To: CF-Talk > Subject: RE: CFQUERYPARAM > > > OK, one more question. If I want it to insert NULL when there > is NOT a value > passed, how can I get the YesNoFormat thing to work. It's > ignoring the value > passed now if the len(trim)) IS gt 0, I want the opposite. > > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 10:14 AM > To: CF-Talk > Subject: Re: CFQUERYPARAM > > > ,Greg wrote: > > OK, I'm trying to use cfqueryparam on a varchar field > insert and it's > > inserting a "?" even though I'm entering a value in the > form field that's > > posting to this query. Anyone know what's wrong here? > > > > VALUES ('<cfqueryparam value="#Trim(Attributes.firstname)#" > > cfsqltype="CF_SQL_CHAR" > > null="#YesNoFormat(Len(Trim(Attributes.firstname)))#">',... > > No quotes around cfqueryparam. Never. > > Jochem > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
