You can use <cfwddx action="cfml2wddx" input="#QueryObject#" output="MyVar">
.. then use <cfset QuerySize=Len(MyVar)> This way you can parse thru the WDDX if you are interested in specific thing in there... .. but I think Len() works on binary data as well: <cfset QuerySize=Len(QueryObject)> Jp On Friday, November 8, 2002, at 06:29 PM, Srimanta wrote: > Would be happy to get a CF solution to the problem. > Dont really want to work at db end for the solution. > What about other platforms-- ASP--PHP? > (Iam probably going off the track.....) > > Thanks > Srimanta > ----- Original Message ----- > From: "Srimanta" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, November 08, 2002 6:21 PM > Subject: Re: Query size > > >> 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
