Actually I guess I should read more. Did not notice the stored procedure pat :-/
Doug B. ----- Original Message ----- From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, January 22, 2007 6:40 PM Subject: Re: Better way to send nulls to a Stored Proc? > My best friend made a custom tag for that a while back. Here is the link to > the file. Maybe a little work on it and you could speed things up with some > scripting or whatever. I would ask him, but he committed suicide a couple > years ago :( > > http://cfregex.com/cfcomet/utilities/CF_NULLVALIDATE.zip > > Doug B. > > > > ----- Original Message ----- > From: "David Gardner" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Monday, January 22, 2007 6:26 PM > Subject: Better way to send nulls to a Stored Proc? > > > > My code works. But I was wondering if there was a better solution? > > > > I didn't originally have the "null" attribute at all, but added it > > when I had an issue. I did an update from my web page form and even > > though empty strings were submitted to that date, what got put into > > the database was "1/1/00". So I added this logic to populate the null > > attrib. > > > > I think it's fairly elegant (though using the YesNoFormat() kinda bugs > > me), but I'm wondering if I'm missing a better way. > > > > I guess instead of using YesNoFormat(), I could do a REFind() to find > > any character, then that would return a true boolean. But I'll bet > > that's slower than YesNoFormat(). > > > > ....... > > var opposite = structNew(); > > opposite['yes'] = false; > > opposite['no'] = true; > > </cfscript> > > <cfstoredproc procedure="xxx" datasource="xxx"> > > <cfprocparam type="in" > > value="#dateIn#" > > null="#opposite[yesNoFormat(len(dateIn))]#" > > CFSQLType="CF_SQL_DATETIME" > > > > > </cfstoredproc> > > > > I think CF needs either .... > > 1. a function that returns true if a string has length, and false if > > it doesn't, or > > 2. for more general use, a function that will return true if a value > > evaluates to true (like a number, when using the len() function), and > > false otherwise. I could use that in place of the YesNoFormat() and > > keep formatting type functions out of my model layer. > > > > I'm in MX 7, on iis/Windows. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
