<div>
give this a try...<br />
<br />
&lt;cfif len(trim(CUMULATIVE_OM))&gt; &nbsp; &nbsp;<br />
<br />
basically this is saying if this variable has anything other than &quot;&quot;&nbsp;then do something...
</div>


give this a try...

<cfif len(trim(CUMULATIVE_OM))>    

basically this is saying if this variable has anything other than "" then do something...

<div>
I should say the statement means that if there's any value to &quot;CUMULATIVE_OM&quot; then it will do something, basically it checks to make sure there's a value..
</div>


I should say the statement means that if there's any value to "CUMULATIVE_OM" then it will do something, basically it checks to make sure there's a value..

<div>
Exactly what I needed...thanks alot!!!!
</div>


<div>
<div class="content wysiwyg-content">
I have a question regarding null values. I have a data table, and that table has a few fields, some have data, some don't. What I'm trying to do is a cfif statement in a cfm page that if the databae query returns nothing for this specific field, then I want the web page to look a certain way, but if the query returned a value of 0 or greater, than I want the web page to look like something else. I thought I could do &lt;cfif #CUMULATIVE_OM# IS NULL&gt; but that doesn't work.....and if I put 0 in there instead of NULL, that doesn't work either, because there is nothing in the specific field. Any help would be greatly appreciated!!!
</div>
</div>


I have a question regarding null values. I have a data table, and that table has a few fields, some have data, some don't. What I'm trying to do is a cfif statement in a cfm page that if the databae query returns nothing for this specific field, then I want the web page to look a certain way, but if the query returned a value of 0 or greater, than I want the web page to look like something else. I thought I could do <cfif #CUMULATIVE_OM# IS NULL> but that doesn't work.....and if I put 0 in there instead of NULL, that doesn't work either, because there is nothing in the specific field. Any help would be greatly appreciated!!!

Working with null values and CFIF

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.