ColdFusion doesn't have the notion of null. null fields are returned as
empty strings
<cfif len(qQuery.field)>
not null
<cfelse>
null
</cfif>
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
----- Original Message -----
From: "Thomas Chiverton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:47 AM
Subject: Checking for NULL
> How do I compare a field for a NULL value ?
> <cfif qQuery.field is NULL> ?
>
> Regards,
>
> Thomas Chiverton
> Intranet Architect
> 01565 757 909
> The web is the borderless embodiment of every abstraction
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
