CurrentRow As in #queryname.CurrentRow# (very poorly documented - don't blame you for not finding it! > -----Original Message----- > From: Ethan Rosch [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 16, 2000 9:59 AM > To: CF-Talk > Subject: last message was sent html by accident.... > > 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> </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? 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><CFQUERY name=3D=20 > "TotalRecord" dataSource=3D "flashback"><BR> SELECT=20 > Survey.ID<BR> FROM=20 > Survey<BR></CFQUERY><BR><BR><HTML><HEAD><BR> <T= > ITLE>Survey=20 > Results</TITLE><BR></HEAD><BODY bgcolor=3D=20 > "ffffff"><BR><BR><FONT size=3D "+1">Survey Results</FONT> = > > <BR><BR><BR><cfoutput query=3D = > "TotalRecord"><BR>#Currentrow# of=20 > #TotalRecord.RecordCount#<BR></cfoutput><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. ------------------------------------------------------------------------------ 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.
