If you do not pass in a value to the stored procedure and put a default value inside the stored procedure, the parameter becomes "not required" and thus you can set it equal to NULL in the stored procedure. You do not need to YesNoFormat the data. You can pass an empty string to the stored procedure with a cfparam just in case you have valid data.
Let TSQL manage NULLs unless you run BlueDragon which has a NULL data type. 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:267317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
