On Wed, Aug 11, 2010 at 4:55 PM, Carl Von Stetten <cmvon...@hotmail.com> wrote: > > Matthew, > > SQL should have no problem with a null being passed for a list, even with > integers (I just tested this against MS SQL Server 2005, although I use > BlueDragon JX 7.1 instead of ACF).
Except, since Coldfusion is declaring the bind variables and passing them in, and there is no "null" in coldfusion, just "empty string", I can see where that might be a problem. Because CF tries to pass an empty string into a bind variable that's expecting an int. I've never come across such an issue myself though. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
