null="#Len(Trim(ARGUMENTS.SourceRef1))#"
that will evaluate to null="true" when ARGUMENTS.SourceRef1 IS an empty string.
as Leigh said, you should have used null="#NOT Len(Trim(ARGUMENTS.SourceRef1))#"
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 13/11/2009 01:58, Brett Davis wrote:
> Handy little trick being
> able to drop the NOT in there like that.
though if you forget it, cfqueryparam does NOT work as expected ;)
~|
Want to reach the ColdFusion community with something they want? Let the
I do a similar check with #not isDate(arguments.startDate)# with
cf_sql_date types as well. Handy little trick being able to drop the
NOT in there like that.
~|
Want to reach the ColdFusion community with something they want?
> cfsqltype="cf_sql_integer"
> value="#ARGUMENTS.FieldFmtTypeID#"
> null="#Len(Trim(ARGUMENTS.FieldFmtTypeID))#"/>,
Do you not mean:
null="#NOT Len(Trim(ARGUMENTS.FieldFmtTypeID))#"/>
ie Insert null when the value IS an empty string
-Leigh
~~~
4 matches
Mail list logo