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&
> S. Isaac Dealey wrote:
>> Or ...
>> #len("#valuelist(myquery.textcolumn)##valuelist(myquery.a
>> nothertextco
>> lumn)#")# ...
> That will measure the length in characters, not in bytes.
>> each character is a byte
> Not necessarily.
Ah yes -- I forget about double-byte character sets...
ea
S. Isaac Dealey wrote:
> Or ...
> #len("#valuelist(myquery.textcolumn)##valuelist(myquery.anothertextco
> lumn)#")# ...
That will measure the length in characters, not in bytes.
> each character is a byte
Not necessarily.
Jochem
~~
data.
Thanks for Catching that!
Jeff
-Original Message-
From: Paul Hastings [mailto:paul@;tei.or.th]
Sent: Thursday, November 07, 2002 10:56 PM
To: CF-Talk
Subject: Re: Query size
> SELECT foo, bar, hum, DATALENGTH(foo + '' + bar + '' + hum) AS bytes
shouldn
> SELECT foo, bar, hum, DATALENGTH(foo + '' + bar + '' + hum) AS bytes
shouldn't that be
SELECT foo, bar, hum, DATALENGTH(foo) + DATALENGTH(bar)+DATALENGTH(hum) AS
bytes
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Viru
setting up a series of Stored
Procs to handle this... You could even insert the running tally into a
billing table as you go.
HTH,
Jeff
-Original Message-
From: Srimanta [mailto:mail@;designshop.co.nz]
Sent: Friday, November 08, 2002 7:22 PM
To: CF-Talk
Subject: Re: Query size
Thanks
lk" <[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]&g
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 ColdFu
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
> > 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^)
I would think that simplest way would be to squirt the data out to
-
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 th
> 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^)
Or ... #len("#valuelist(myquery.textcolumn)##valuelist(myquery.anothertextco
l
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 PROTEC
> - Original Message -
> From: "Srimanta" <[EMAIL PROTECTED]>
>> 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
Not sure what you mean by query size? Is it the amount of rows?
If so use #queryname.recordcount#.
HTH,
Frank
- Original Message -
From: "Srimanta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 1:10 PM
Subject: QUERY SIZE.
> Hi Forum,
>
> I need
- Original Message -
From: "Srimanta" <[EMAIL PROTECTED]>
> 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 mi
You might want to try adding a calculated column to each row that you return
SELECT foo, bar, hum, DATALENGTH(foo + '' + bar + '' + hum) AS bytes
The DATALENGTH function works with SQL Server (don't know about Oracle...).
HTH,
Jeff Garza
- Original Message -
From: "Srimanta" <[EMAIL PR
17 matches
Mail list logo