Assuming that you are in a <cfoutput query="caseandnotes"> (or
an equiv <CFLOOP....>, then the <CFIF> statement will be evaluated
for each record returned with the query.
<cfoutput query="caseandnotes">
<cfif Len(assigned_to) >
You have some text in the column here
<cfelse>
you do not have any text in the column here
</cfif>
</cfoutput>
At 06:13 PM 7/4/2000 -0400, miles wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_000A_01BFE5E3.8A607F60
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hi. (happy 4th, if you celebrate that sort of thing)
>
>Am I right in thinking that the code snippett below
>will only be true once ?
>
>What Im thinking is that the If statement only gets=20
>evaluated for the 1st record it finds that its evaluating in
>the referenced query....if its NOT true for the first record
>it finds...then it proceeds to the rest of the code ?
>
><cfif "#caseandnotes.assigned_to#" neq "">
> <td align=3Dcenter valign=3Dtop colspan=3D3>
> name not listed. - #DateFormat(entered_date)#
> </td>
><cfelse>
> <td align=3Dcenter valign=3Dtop colspan=3D3>
> <font face=3D"arial, helvetica" size=3D"2">
> <cfoutput query=3D"caseandnotes" maxrows=3D"10">#assigned_to# on =
>#DateFormat(entered_date)#<BR></cfoutput>
> </font>
> </td>
></cfif>
>
>If what I said above is true...how do I get it to loop over
>the query so that WHEN its true it returns "name not listed" and the =
>#date#, but
>all other times it returns the two other fields in the rest of the=20
>code ? Is this making any sense ?
>
>A visual example perhaps ?
>
>assigned_to date
>irene cara 07/01/00
>julie numar 04/16/00
>no name listed 02/25/00
>doug henning 12/29/99
>katarina witt* 11/14/99
>no name listed 10/21/99
>etc.
>
>You get the gist I trust ?
>
>Any help anyone can render would be gratefully appreciated.
>
>Thanks.
>
>Miles.
>
>
>
>
>------=_NextPart_000_000A_01BFE5E3.8A607F60
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META content=3D"text/html; charset=3Diso-8859-1" =
>http-equiv=3DContent-Type>
><META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV><FONT face=3DArial size=3D2>Hi. (happy 4th, if you celebrate that =
>sort of=20
>thing)</FONT></DIV>
><DIV><FONT face=3DArial size=3D2></FONT> </DIV>
><DIV><FONT face=3DArial size=3D2>Am I right in thinking that the code =
>snippett=20
>below</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>will only be true once ?</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>What Im thinking is that the If =
>statement only gets=20
></FONT></DIV>
><DIV><FONT face=3DArial size=3D2>evaluated for the 1st record it finds =
>that its=20
>evaluating in</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>the referenced query....if its NOT true =
>for the=20
>first record</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>it finds...then it proceeds to the rest =
>of the code=20
>?</FONT></DIV>
><DIV><FONT face=3DArial size=3D2></FONT> </DIV>
><DIV><FONT face=3DArial size=3D2><cfif "#caseandnotes.assigned_to#" =
>neq=20
>""></FONT><FONT face=3DArial size=3D2><BR> <td =
>align=3Dcenter=20
>valign=3Dtop colspan=3D3></FONT><FONT face=3DArial =
>size=3D2></FONT></DIV>
><DIV><FONT face=3DArial size=3D2> name not =
>listed. -=20
>#DateFormat(entered_date)#</FONT><FONT face=3DArial =
>size=3D2><BR> =20
></td></FONT><FONT face=3DArial =
>size=3D2><BR><cfelse></FONT><FONT=20
>face=3DArial size=3D2><BR> <td align=3Dcenter =
>valign=3Dtop=20
>colspan=3D3><BR> <font =
>face=3D"arial, helvetica"=20
>size=3D"2"><BR> <cfoutput =
>query=3D"caseandnotes"=20
>maxrows=3D"10">#assigned_to# on=20
>#DateFormat(entered_date)#<BR></cfoutput><BR> &nbs=
>p; =20
></font><BR> </td></FONT></DIV>
><DIV><FONT face=3DArial size=3D2></cfif></FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>If what I said above is true...how do I =
>get it to=20
>loop over</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>the query so that WHEN its true it =
>returns "name=20
>not listed" and the #date#, but</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>all other times it returns the two =
>other fields in=20
>the rest of the </FONT></DIV>
><DIV><FONT face=3DArial size=3D2>code ? Is this making any sense=20
>?</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>A visual example perhaps ?</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial=20
>size=3D2>assigned_to =
>date</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>irene=20
>cara &nb=
>sp;07/01/00</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>julie=20
>numar =20
>04/16/00</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>no name=20
>listed 02/25/00</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>doug =
>henning =20
>12/29/99</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>katarina =
>witt* =20
>11/14/99</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>no name listed =20
>10/21/99</FONT></DIV>
><DIV><FONT face=3DArial size=3D2>etc.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>You get the gist I trust ?</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>Any help anyone can render would be =
>gratefully=20
>appreciated.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>Thanks.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>Miles.</FONT></DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV> </DIV></BODY></HTML>
>
>------=_NextPart_000_000A_01BFE5E3.8A607F60--
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.