No problem, any time, glad it helped. Niall. -----Original Message----- From: David Gardner [mailto:[EMAIL PROTECTED] Sent: 23 January 2007 17:11 To: CF-Talk Subject: Re: Better way to send nulls to a Stored Proc?
Yep, I used... nullif(@DateIn,'') and it worked just fine. I suspected that T-SQL could do it cleanly, but my skills at T-SQL null-handling are very weak. Thanks Niall, and Teddy On 1/23/07, Niall O'Doherty <[EMAIL PROTECTED]> wrote: > Just thinking out of the box here, and not sure if this is exactly what you're after but wouldn't you be better letting SQL decide what to insert. > > By using the NULLIF() SQL Function you can still pass your date as 01/01/00 if no date is specified and use the NULLIF() function to evaluate what to insert...either the date or NULL. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
