It displays 34(or rather the equivalent on my result set) on my test. Ade
-----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 17:13 To: CF-Talk Subject: RE: question Because you reset it with your cfset ============================================ Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ============================================ -----Original Message----- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:11 AM To: CF-Talk 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
