Title: Message
queryName.columnName[queryName.recordCount]
 
or
 
<cfif queryName.currentRow EQ queryName.recordCount>
 
Hope thats what your after.
 
Taco Fleur
 
 
 
----- Original Message -----
Sent: Friday, February 14, 2003 6:45 PM
Subject: [cfaussie] RE: Last row in query

What do you want to do?
 
Fill in the rest of the table if the query is short?
 

Regards

Steve Onnis
Domain Concept Designs
+61 422 337 685
+61 3 9431 4249

http://www.domainconceptdesigns.com
[EMAIL PROTECTED]
http://www.cfcentral.com.au
[EMAIL PROTECTED]

("If you think it can't be done, you haven't asked me!") - Steve Onnis

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Blake Foss
Sent: Friday, February 14, 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
 
---
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/
---
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