End of query

[Adomacro]

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

[Dan_Bracuk]

<cfoutput query="ActivityDetails">
Display of data.

</cfoutput>
<cfoutput>
display other stuff here

[Adomacro]

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>

[Dan_Bracuk]

put the line and the closing table tag after your cfoutput.

[Adomacro]

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.

[Newsgroup_User · Accepted solution]

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/

[Dan_Bracuk]

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>

[Adomacro]

Azadi...perfect.

you are best person in this forum.

[Adomacro]

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.