SQL Server and Nulls

[hofar...@houseoffusion.com]

In an update query, to a tinyint field which allows nulls, I have the update

dbfield=#mydatefield#

If mydatefield has no value, sql is throwing an error. The field allows
nulls. I've never had to say if "" then NULL before. What the heck?


Robert Harrison
Full Stack Developer
AIMG
rhar...@aimg.com
Main Office: 704-321-1234  ext.118
Direct Line: 516-302-4345
www.aimg.com



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360469

[hofar...@houseoffusion.com]

Dbfield=<cfqueryparam value="#mydatefield#" cfsqltype="CF_SQL_TINYINT" null="#not len(mydatefield)#" />

Steve

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360470

[hofar...@houseoffusion.com]

dbfield = <cfqueryparam cfsqltype="cf_sql_tinyint" value="#mydatefield#"
null="#yesnoformat(mydatefield is '')#">

Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360471