Thanks, I am using MS SQL. Srimanta ----- Original Message ----- From: "Jeff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 9:13 PM Subject: RE: Query size
> What database are you using? Does this have to be a ColdFusion > solution? Or can you work it on the Database end? > > Jeff > > -----Original Message----- > From: Srimanta [mailto:mail@;designshop.co.nz] > Sent: Friday, November 08, 2002 6:34 PM > To: CF-Talk > Subject: Re: Query size > > > 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 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