CF doesn't recognize the concept of a "null value". it converts null values into empty strings.
<cfif questionTextVariables.minTextLimit is ""> from a database perspective, there's absolutely a difference between NULL (no value exists) and empty string (a string of zero length exists). However, CF does not make that distinction :( On 10/8/07, Richard White <[EMAIL PROTECTED]> wrote: > Hi, i am getting data out of a database. i need to be able to check if a > value returned in a query is null. > > i am trying to use the following code but it is not working > > <cfif questionTextVariables.minTextLimit is null> > > it seems a bit strange that the word null is not going blue to indicate that > it is a recognised word. > > thanks for the help > > richard > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
