last message was sent html by accident....

Mon, 16 Oct 2000 09:52:03 -0700 

This is a multi-part message in MIME format.

------=_NextPart_000_00A2_01C03770.D14BE250
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


I think this is a rather simple question....

How do I find the row # of a certain row of data in my database?  Such =
=3D
that I can say "this is record 3 of 10".

I know the query.recordcount function to get the 10 as a seperate query=20
for all records in that database.

but I am stuck on the first part, as I am not checking for the row # of=20
the query that I am using to get my info, as that will always be 1.



<CFQUERY name=3D "TotalRecord" dataSource=3D "flashback">
 SELECT Survey.ID
 FROM Survey
</CFQUERY>

<HTML><HEAD>
 <TITLE>Survey Results</TITLE>
</HEAD><BODY bgcolor=3D "ffffff">

<FONT size=3D "+1">Survey Results</FONT> <BR>

<cfoutput query=3D "TotalRecord">
#Currentrow# of #TotalRecord.RecordCount#
</cfoutput>

thanks,

ethan


------=_NextPart_000_00A2_01C03770.D14BE250
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 http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>I think this is=20
a rather simple question....<BR><BR>How do I find the row # of a certain =
row of=20
data in my database?&nbsp; Such =3D<BR>that I can say "this is record 3 =
of=20
10".<BR><BR>I know the query.recordcount function to get the 10 as a =
seperate=20
query <BR>for all records in that database.<BR><BR>but I am stuck on the =
first=20
part, as I am not checking for the row # of <BR>the query that I am =
using to get=20
my info, as that will always be 1.<BR><BR><BR><BR>&lt;CFQUERY name=3D=20
"TotalRecord" dataSource=3D "flashback"&gt;<BR>&nbsp;SELECT=20
Survey.ID<BR>&nbsp;FROM=20
Survey<BR>&lt;/CFQUERY&gt;<BR><BR>&lt;HTML&gt;&lt;HEAD&gt;<BR>&nbsp;&lt;T=
ITLE&gt;Survey=20
Results&lt;/TITLE&gt;<BR>&lt;/HEAD&gt;&lt;BODY bgcolor=3D=20
"ffffff"&gt;<BR><BR>&lt;FONT size=3D "+1"&gt;Survey Results&lt;/FONT&gt; =

&lt;BR&gt;<BR><BR>&lt;cfoutput query=3D =
"TotalRecord"&gt;<BR>#Currentrow# of=20
#TotalRecord.RecordCount#<BR>&lt;/cfoutput&gt;<BR><BR>thanks,<BR><BR>etha=
n</FONT><BR></FONT></DIV></BODY></HTML>

------=_NextPart_000_00A2_01C03770.D14BE250--

------------------------------------------------------------------------------
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.

Reply via email to