<div>
If you do not want to include any negative numbers you first need to remove these numbers from the list, i.e. <br />
1. you loop over the list<br />
2. check if the value is negative<br />
3. if negative then remove the value from the list<br />
<br />
Let me know if you need a example for this?
</div>


If you do not want to include any negative numbers you first need to remove these numbers from the list, i.e.
1. you loop over the list
2. check if the value is negative
3. if negative then remove the value from the list

Let me know if you need a example for this?

<div>
<div class="content wysiwyg-content">
i have the following value list which gets data from a query:<br />
<br />
&lt;cfset userinvoices_list = ValueList(Query1.t_current<wbr />_amount)&gt;<br />
<br />
how do i write a query or some other statement that checks if any of the values in this list <br />
are NOT equal to '.00' AND also if the first character of any of the values are NOT equal to '-' ?<br />
<br />
(i put quotes around each value because they are text values not numbers) &nbsp; <br />
<br />
so a query that returns zero results would be if the valuelist contained something like:<br />
<br />
(.00, .00, .00, .00)<br />
<br />
but would return 2 results if the valuelist contained something like:<br />
<br />
(2.37, .00, -2.54, .00)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />

</div>
</div>


i have the following value list which gets data from a query:

<cfset userinvoices_list = ValueList(Query1.t_current_amount)>

how do i write a query or some other statement that checks if any of the values in this list 
are NOT equal to '.00' AND also if the first character of any of the values are NOT equal to '-' ?

(i put quotes around each value because they are text values not numbers)   

so a query that returns zero results would be if the valuelist contained something like:

(.00, .00, .00, .00)

but would return 2 results if the valuelist contained something like:

(2.37, .00, -2.54, .00)
	


performing a query or check on a valuelist

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.