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.
