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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
