<div>
Here's a start. <br />
<br />
Not sure what you mean by Include this employee in the list and such...<br />
<br />

<pre><code class="code-10 nolinks" id="code-120892"><span> &lt;cfquery name=&quot;getEmp&quot; datasource=&quot;#request.datasource#&quot;&gt;</span>
<span>   SELECT EMP_ID, SALARY, FIRST_NAME, LAST_NAME, YEARS_EMPLOYED, POSITON </span>
<span>   FROM EMP</span>
<span> &lt;/cfquery&gt;</span>
<span> </span>
<span> &lt;!--- loop the entire results of the query ---&gt;</span>
<span> &lt;cfloop query=&quot;getEmp&quot;&gt;</span>
<span> </span>
<span>    &lt;cfif getEmp.SALARY gt 35000&gt;  &lt;!--- gt is greater than, gte is greater than or equal to ----&gt;</span>
<span>       Include This Employee in the List</span>
<span>    &lt;cfelseif getEmp.YEARS_EMPLOYED gt 5&gt;</span>
<span>       Include This Employee In the List</span>
<span>    &lt;cfelseif listFindNoCase(&quot;AVP,DIRECTOR,MANAGER&quot;,POSITION)&gt; &lt;!--- is Position on of the items on the list ---&gt;</span>
<span>       Include This Employee In the List</span>
<span>    &lt;/cfif&gt;</span>
<span> </span>
<span> &lt;/cfloop&gt;</span>
</code></pre>
</div>


<div>
Let's say I have 10,000 employees in the database, but I only want to display the ones that meet a certain criteria. &nbsp;I could try to do it in the SELECT statement using a WHERE clause, but some of the criteria will get complex. &nbsp;In VB, I would just loop through each record and say &quot;if this is true, then add the record to this subset&quot; ... and then display the subset. &nbsp;How do I do that in CF?
</div>


<div>
Generally speaking, I think that should be done in the SQL statement, or as much as possible. &nbsp; For the remaining Items, I must ask what do you mean by &quot;subset&quot; ?<br />
<br />
We could make a list of these records using the primary key so you have a variable with a value of &nbsp; 1,2,3,12,19,25,30 &nbsp; which are the IDs of the records that match the criteria.<br />
<br />
Or perhaps we could flag each record of the query, then you can query the query to reduce the records to just those desired..<br />

</div>


<div>
Say you do a SELECT statement to bring back 10,000 rows. &nbsp;Then you want to loop through each one to check for conditions. &nbsp;Say one field is a Criticality (1,2,3,4,5) and another is status time. &nbsp;If the Priority equals 1 and the status time is between 8A-5P, we would want to include that row. &nbsp;Say another field is Location .. if the location is New York and the Criticality is 1, we want that included as well. &nbsp;However, if the location is Los Angeles and the Priority is 4 or 5, we dont care about that record. &nbsp;Stuff like that. &nbsp;There are about 30 inclusion tests with this data that I have to use to determine if the row should be included.<br />
<br />
It just doesn't seem like that would be feasible for a SQL Statement. &nbsp;So my plan is to select all the rows and have a way to loop through each record and test it for inclusion. &nbsp;That, and how do I &quot;tag&quot; the record for inclusion into a separate record set (or &quot;subset&quot;) is my question. &nbsp;Once I have created the subset of records, I would then display only THOSE records on the screen.
</div>


<div>
That is EXACTLY what I needed!!! &nbsp;Thanks SO much! &nbsp;Perfect, couldn't be better.
</div>


<div>
Thanks SO much for hanging in there through my explanations and for the great work.
</div>


<div>
excellant ! &nbsp;glad to hear it
</div>


<div>
<div class="content wysiwyg-content">
I'm a VB guy, but I have to do some Cold Fusion code. &nbsp;I can write the SQL Statement to get the data I need, but I'll need to loop through the result set to extract the records I need. &nbsp;I'm not asking anyone to code the request for me... I have at least four CF manuals that haven't been opened yet. &nbsp;All I need to know is the basic syntax for what I need to do so I can find it in the book, study it, and learn what I need to do for this specific task. &nbsp;This is basically what I need as an example:<br />
<br />
SELECT EMP_ID, SALARY, FIRST_NAME, LAST_NAME, YEARS_EMPLOYED, POSITON FROM EMP<br />
<br />
WHILE NOT EMP.BOF and NOT EMP.EOF<br />
<br />
IF SALARY &gt;&nbsp;35000 Then<br />
&nbsp; &nbsp;Include This Employee in the List<br />
ELSEIF YEARS_EMPLOYED &gt;&nbsp;5 Then<br />
&nbsp; &nbsp;Include This Employee In the List<br />
ELSEIF POSITION IN ('AVP','DIRECTOR','MANAGER<wbr />') Then<br />
&nbsp; &nbsp;Include This Employee In the List<br />
END IF<br />
<br />
Wend<br />
<br />
Thanks for whatever pointers you can give me!!<br />
<br />
&nbsp; &nbsp;<br />
<br />
&nbsp;
</div>
</div>


I'm a VB guy, but I have to do some Cold Fusion code.  I can write the SQL Statement to get the data I need, but I'll need to loop through the result set to extract the records I need.  I'm not asking anyone to code the request for me... I have at least four CF manuals that haven't been opened yet.  All I need to know is the basic syntax for what I need to do so I can find it in the book, study it, and learn what I need to do for this specific task.  This is basically what I need as an example:

SELECT EMP_ID, SALARY, FIRST_NAME, LAST_NAME, YEARS_EMPLOYED, POSITON FROM EMP

WHILE NOT EMP.BOF and NOT EMP.EOF

IF SALARY > 35000 Then
   Include This Employee in the List
ELSEIF YEARS_EMPLOYED > 5 Then
   Include This Employee In the List
ELSEIF POSITION IN ('AVP','DIRECTOR','MANAGER') Then
   Include This Employee In the List
END IF

Wend

Thanks for whatever pointers you can give me!!

   

 

Need Some Basic Cold Fusion Logic Help

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.