SQL Server and Nulls

2015-04-17 Thread Robert Harrison
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

Re: SQL Server and Nulls

2015-04-17 Thread John M Bliss
dbfield = cfqueryparam cfsqltype=cf_sql_tinyint value=#mydatefield# null=#yesnoformat(mydatefield is '')# On Fri, Apr 17, 2015 at 3:58 PM, Robert Harrison rharri...@aimg.com wrote: In an update query, to a tinyint field which allows nulls, I have the update dbfield=#mydatefield# If

RE: SQL Server and Nulls

2015-04-17 Thread DURETTE, STEVEN J
Dbfield=cfqueryparam value=#mydatefield# cfsqltype=CF_SQL_TINYINT null=#not len(mydatefield)# / Steve -Original Message- From: Robert Harrison [mailto:rharri...@aimg.com] Sent: Friday, April 17, 2015 3:58 PM To: cf-talk Subject: SQL Server and Nulls In an update query, to a tinyint