Lovely stuff that's all I wanted. Thanks
-----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 18:11 To: CF-Talk Subject: RE: question If you want to maintain the recordset, you can't. If you don't care about the recordset, then do this: <cfset test = structNew() /> <cfset test.recordcount = 1 /> the 'recordcount' attribute of a recordset is immutable. --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Shahzad.Butt [mailto:[EMAIL PROTECTED] > Sent: Friday, April 04, 2003 9: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 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