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

2004-02-27 Thread Tim Blair
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

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

2004-02-26 Thread Mike Townend
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

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

2004-02-26 Thread Jeff Fongemie
Thanks everyone, CFIF myquery.CurrentRow NEQ myquery.RecordCount 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 Shawn Grover
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

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 Subject:

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

2004-02-26 Thread Charlie Griefer
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,

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

2004-02-26 Thread Paul Vernon
cfoutput query=blah cfif currentrow lte recordcount /cfif /cfoutput Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

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

2004-02-26 Thread DURETTE, STEVEN J (AIT)
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

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 cfif currentrow NEQ recordcount Greg -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 10:26 AM To: CF-Talk

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 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