RE: How to know when you have the last record?

2004-02-27 Thread Tim Blair
>    > > 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 want a comma added afte rthe last one, so:

RE: How to know when you have the last record?

2004-02-26 Thread Kola Oyedeji
Are you looping over the recordset? If so you could do last image 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 record? Hey, I'm outputting a query as a list. Visually

RE: How to know when you have the last record?

2004-02-26 Thread Greg Luce
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 Greg -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

RE: How to know when you have the last record?

2004-02-26 Thread DURETTE, STEVEN J (AIT)
Try:     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 a list. Visually, I'm inserting an image between each record.

RE: How to know when you have the last record?

2004-02-26 Thread Paul Vernon
        Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: How to know when you have the last record?

2004-02-26 Thread Charlie Griefer
- 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, I'm inserting an image between each recor

RE: How to know when you have the last record?

2004-02-26 Thread Barney Boisvert
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 > Subj

RE: How to know when you have the last record?

2004-02-26 Thread Shawn Grover
    (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 have the last record? Hey, I'm outputting a query as a list

Re: How to know when you have the last record?

2004-02-26 Thread Jeff Fongemie
Thanks everyone,    Worked perfectly. _jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: How to know when you have the last record?

2004-02-26 Thread Mike Townend
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 an image between each record. It looks great un