RE: Access question

[Sean Daniels]

> If a field in access has never had anything in it at all does it appear as
> NULL or as "".

It appears as null.

> So would you check it with <CFIF FieldName IS ""> or would you use <CFIF
> FieldName IS NULL>

Well, ColdFusion does not support the word "NULL", so you would use the
<cfif FieldName is "">. Or, many people prefer: <cfif not
len(trim(fieldname))>

The latter is boolean and therefore evaluates slightly faster.

- Sean
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists