Dbfield=
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 field which allows nulls, I have the update
dbfield=#mydatefield#
If mydatefield has
dbfield =
On Fri, Apr 17, 2015 at 3:58 PM, Robert Harrison wrote:
>
> 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 N
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
rharri...@ai
3 matches
Mail list logo