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
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
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
3 matches
Mail list logo