Why would you want to do this? Why not set a separate variable that does not appear to be part of your query? Throughout your code, "recordcount" should probably usually (always) refer to the total number of rows returned by a query. Making it mean something else may not be wise.
-mark -----Original Message----- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 11:03 AM To: CF-Talk Subject: RE: question OK, it display 34 but how can I set it to 1. I was a bit screwed up and said it displays 1. Actually it is displaying 34 but I want it to display 1???? -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:01 To: CF-Talk Subject: RE: question 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
