Because that is the first element in the list. cfoutput is like a loop. It starts at the first record, and loops through to the last. If you tell it to output a recordcount of 1, that it will only give you the first record. Make sense? ----- Original Message ----- From: "Shahzad.Butt" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 04, 2003 10:11 AM Subject: question
> <CFQuery name="Test" datasource="DSN"> > Select * > From tb_test > </cfquery> > > (this query gives 34 results) > > <CFSet Test.RecordCount = "1"> > > <CFOUTPUT>#Test.RecordCount#</CFOUTPUT> > > What should it display 34 or 1? > > It display 1. Any reason why? > > Shahzad Butt (Development Engineer) > > JJ FastFood Distribution Ltd. > Office: +44 (0) 1992 701 722 > Mobile: +44 (0) 7803 584 873 > Fax: +44 (0) 1992 701 604 > > 7 Solar Way, Innova Park, Enfield, London, EN3 7XY > > > !"[EMAIL PROTECTED]@APOLLO"! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
