This is a multi-part message in MIME format.
------=_NextPart_000_0375_01BFFE2E.E66FA390
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Previous Recordsomequery.somecolumn[currentrow-1] to refer to the prior =
row (assuming you aren't at the first row. You may have to calculate =
the value into a loop variable in your loop, in case the arithmetic =
doesn't work in the reference, directly.
DC
----- Original Message -----=20
From: Miriam Hirschman=20
To: CF Forum=20
Sent: Friday, August 04, 2000 16:05
Subject: Previous Record
Is there a way that I can hold the previous record when looping =
through a=20
query so that I can compare it to the current record??=20
Thanks,=20
=20
---miriam=20
=
-------------------------------------------------------------------------=
-----=20
Archives: http://www.mail-archive.com/[email protected]/=20
To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.
------=_NextPart_000_0375_01BFFE2E.E66FA390
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Previous Record</TITLE>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial =
size=3D2>somequery.somecolumn[currentrow-1] to refer=20
to the prior row (assuming you aren't at the first row. You may =
have to=20
calculate the value into a loop variable in your loop, in case the =
arithmetic=20
doesn't work in the reference, directly.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>DC</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]>Miriam=20
Hirschman</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
href=3D"mailto:[EMAIL PROTECTED]" =
[EMAIL PROTECTED]>CF=20
Forum</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, August 04, 2000 =
16:05</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Previous Record</DIV>
<DIV><BR></DIV><BR>
<P><FONT size=3D2>Is there a way that I can hold the previous record =
when=20
looping through a</FONT> <BR><FONT size=3D2>query so that I can =
compare it to=20
the current record??</FONT> <BR><FONT size=3D2>Thanks,</FONT> =
<BR><FONT=20
size=3D2> </FONT> <BR><FONT size=3D2> =20
---miriam</FONT> </P>
<P><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/[email protected]/"=20
=
target=3D_blank>http://www.mail-archive.com/[email protected]/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0375_01BFFE2E.E66FA390--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
