FYI, that code does work in BlueDragon 7.0, which can distinguish between nulls and empty strings, and supports the "null" keyword:
http://blog.newatlanta.com/index.cfm?mode=entry&entry=5C2377F1-534E-5920-D87611A2FB9BE5EC Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com > 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:290586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
