Ok Folks, here is a good one.
I have a query :
<cfquery datasource="cab" name="getlabels">
select *
from labels order by label_code
</cfquery>
this shows that my getlabels.recordcount is 118
BUT when i do
<cfoutput query="getLabels">
<cfset counter = counter + 1>
<tr><td>#counter#</td>
<td>#label_code#</td>
<TD>#lang_id#</TD>
<td>#label#</td>
</tr>
</cfoutput>
it only displays 114 records. And the content of #label# on the last
record is
truncated!
i checked in the db, there is 118 records, and the there is nothing
wrong with label 114. it looks like the processing stops for some
reason. becaue there is no more html code after this record in the page
source and the fotter is not displayed, even though my footer is called
by an include tag in the OnRequestEnd.cfm template.
Any ideas as to why this happens?
TIA!
Gabriel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
