Thanks, The best solution would have been to get the exact query size. Unfortunately average values will not do the job in this case. Dont think writing it to a file and then using CF directory to get the file size will work either as more than one user can run multiple queries simultaneously. Locking is an option. Will have to experiment and see how it works. Would be happy to see Macromedia provide a function to get query size in the future versions of CF. I think I am in trouble as I promsed my client that it can be easily done...
Kind Regards, Srimanta ----- Original Message ----- From: "Mosh Teitelbaum" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 3:26 PM Subject: RE: Query size > Well, it's not in KBs or MBs, but you can use queryName.RecordCount to > determine the number of results in the record. Multiply that by some > multiple and you have an "average" (perhaps?) size. Sort of. 8^) > > -- > Mosh Teitelbaum > evoch, LLC > Tel: (301) 625-9191 > Fax: (301) 933-3651 > Email: [EMAIL PROTECTED] > WWW: http://www.evoch.com/ > > > > -----Original Message----- > > From: Srimanta [mailto:mail@;designshop.co.nz] > > Sent: Friday, November 08, 2002 2:56 PM > > To: CF-Talk > > Subject: Query size > > > > > > Hi Forum, > > > > I need a way to display the query size (in Kb or Mb) in a Cold Fusion > > application and then use it to > > bill a client. Unusual requirement. Had a quick look through the > > list of Cf > > functions ... didnt seem to find one or did I miss ? > > Is there a cold fusion function to get the size of query resultsets? I > > need to be able to display / output the size and then use it for billing > > purposes. > > I know one can know the query size and time in the debugging environment, > > but this is for the client to view. > > > > any Help would be much appreciated. > > > > Thanks > > Srimanta > > ----- Original Message ----- > > From: "Michael Dinowitz" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, November 07, 2002 2:22 PM > > Subject: Re: sorry if repost > > > > > > > Someone said that the HoF server was hitting them with what > > looked like a > > > DoS attack. I couldn't find the problem and took the server down to look > > > more. I havn't heard back from the guy to know if the problem > > was fixed or > > > not (I think it was a change in his anti-spam routing, but....) > > > > > > As for the question, look at these functions: > > > > > > From bin to dec (converts a string to a decimal integer using > > the radix - > > > second attribute) > > > #InputBaseN(1010, 2)# > > > > > > from dec to bin (converts a decimal integer to a string using > > the radix - > > > second attribute) > > > #formatbaseN(10, 2)# > > > > > > > > > > > > > sorry if this is a repost for some of you, however I didn't > > > > get my post....really, I hardly ever get my post, I get it like > > > > an hour later or so....but never on time? mike? > > > > > > > > > > > > does anyone know of an easy method of transforming > > > > a binary number to a decimal number? > > > > > > > > <cfset newNumber = binaryToDecimal(1110)> > > > > > > > > something that would look like that :) > > > > > > > > ..tony > > > > > > > > Tony Weeg > > > > Senior Web Developer > > > > Information System Design > > > > Navtrak, Inc. > > > > Fleet Management Solutions > > > > www.navtrak.net > > > > 410.548.2337 > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.