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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
