Try displaying the records in the inverse order. This will tell you if ColdFusion encounters some strange characters in the query. Also you can try getting the length of the label field from SQL and comparing it with what ColdFusion has to say.
<mack /> ----- Original Message ----- From: "Gabriel Robichaud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 2:48 PM Subject: query output stops after 114 records > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4