Skip to main content
A
Adomacro
Inspiring
May 30, 2008
Answered

End of query

  • May 30, 2008
  • 6 replies
  • 807 views
<cfoutput query="details_q">
Display of data.

{after all data is displayed...i want to display some info here} ..how to find data display is finished?.
</cfoutput>
This topic has been closed for replies.
Correct answer Newsgroup_User
queryname.recordcount is total number of rows returned by your query.
what you need to use is queryname.currentrow, which is the row number
curently procesed by cfoutput. comparing it to queryname.recordcount
will let you determine if currentrow is the last one or not.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

6 replies

A
AdomacroAuthor
Inspiring
June 10, 2008
Hello Azadi,

Can you please take a look at this?.
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=3&threadid=1369213

I am trying to find 2nd thursday of every month.

If current date is more than 2nd thursday of this month, it should show next month 2nd thursday.

i like a simple code or custom tag for this...
Any idea. Please help.
A
AdomacroAuthor
Inspiring
June 10, 2008
Azadi...perfect.

you are best person in this forum.
D
Dan_Bracuk
Inspiring
June 10, 2008
Change this
<cfif details_q.recordcount neq '0'>
<tr>
<td><hr id="bblack" size="0"></td>
</tr>
</cfif>
</cfoutput>
to this
</cfoutput>
<tr><td><hr id="bblack" size="0"></td></tr>
D
Dan_Bracuk
Inspiring
June 9, 2008
put the line and the closing table tag after your cfoutput.
A
AdomacroAuthor
Inspiring
June 9, 2008
Below code produce a extra black line at end of table.

How can i avoid extra line.

I added a condition, <cfif details_q.recordcount neq '0'> to supress black line. But this is not working.


A
AdomacroAuthor
Inspiring
June 9, 2008
Thanks Dan,

This is what i am trying... not working...

i want a line after every line....but not on last line...cuz i got table border for last line.

How to eliminate last line?.

<cfoutput query="details_q">
display all data..


<cfif details_q.recordcount neq '0'>
<tr>
<td><hr id="bblack" size="0"></td>
</tr>
</cfif>
</cfoutput>
D
Dan_Bracuk
Inspiring
May 31, 2008
<cfoutput query="ActivityDetails">
Display of data.

</cfoutput>
<cfoutput>
display other stuff here
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices