CFIF myquery.CurrentRow NEQ myquery.RecordCount
Worked perfectly.
Just out of interest, you could use one of the methods of the underlying
coldfusion.sql.QueryTable java object of the query: isLast()
For example, to output a list of names from a query with a comma between
each, you don't
CFIF myquery.CurrentRow NEQ myquery.RecordCount
hth
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 15:26
To: CF-Talk
Subject: How to know when you have the last record?
Hey,
I'm outputting a query as a list. Visually, I'm inserting
Thanks everyone,
CFIF myquery.CurrentRow NEQ myquery.RecordCount
Worked perfectly.
_jeff
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
cfif myquery.currentrow lt myquery.recordcount
img src="">
/cfif
(going from memory, so can't be 100% certain I got that right)
Shawn
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 8:26 AM
To: CF-Talk
Subject: How to know when you
Compare myquery.currentrow (the current row) to myquery.recordcount (the
total number of rows.If they're equal, you're on the last row.
Cheers,
barneyb
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 7:26 AM
To: CF-Talk
Subject:
cfif queryname.currentRow NEQ queryname.recordCount
- Original Message -
From: Jeff Fongemie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 8:25 AM
Subject: How to know when you have the last record?
Hey,
I'm outputting a query as a list. Visually,
cfoutput query=blah
cfif currentrow lte recordcount
/cfif
/cfoutput
Paul
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Try:
cfif myQuery.currentRow neq myQuery.recordcount
img src="">
/cfif
Steve
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 10:26 AM
To: CF-Talk
Subject: How to know when you have the last record?
Hey,
I'm outputting a query as
It's hard to say without seeing your code. If you're looping over the
query to produce the list, then in the loop you could
cfif currentrow NEQ recordcount
Greg
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 10:26 AM
To: CF-Talk
Are you looping over the recordset? If so you could do
cfif myquery.currentrow eq myquery.recordcount
last image
/cfif
HTH
Kola
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: 26 February 2004 15:26
To: CF-Talk
Subject: How to know when you have the last
10 matches
Mail list logo