[cfaussie] RE: Last row in query

Fri, 14 Feb 2003 00:57:43 -0800

Title: Message
Hello again,
 
I just figured it out,
 
<cfif GetCat.CurrentRow EQ GetCat.RecordCount>stuff here</cfif>
 
What I was doing is listing a query results in a table. It was 3 columns by however many rows.
 
In some queries there would not be exactly 3,6,9.12 results and the last column would only have 1 or 2 records. I wanted to find the last row within the query and place a line to the left of it to match the formatting in the rest of the table.
The above cfif statment did that for me.
Thanks to those that replied.
 
Blake
 
 
 
 
-----------------------------------------------------------------------------------
Blake Foss
Web Foot Forward
p: 61 2 9340 4401
f: 61 2 8080 8190
m: 0410 747 620
e: [EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Blake Foss
Sent: Friday, 14 February 2003 7:40 PM
To: CFAussie Mailing List
Subject: [cfaussie] Last row in query

Hi all,
 
How do I find the value for the last row returned in a query output.
 
I have a query set that lists items into a table and am using the <cfif GetCat.CurrentRow MOD 3 IS 0> to list 3 x 3 tables.
 
In some results there results are not exactly 3 x 3 x 3. What do I place in a cfif statement to find the last record returned? I want to place a solid line next to it to retain the page formatting.
 
Hope this makes sense?
 
Thanks in advance for any help.
 
Blake
 
-----------------------------------------------------------------------------------
Blake Foss
Web Foot Forward
p: 61 2 9340 4401
f: 61 2 8080 8190
m: 0410 747 620
e: [EMAIL PROTECTED]
 
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

Reply via email to