Re: Query size

2002-11-08 Thread Jon Gorrono
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&

Re: Query size

2002-11-08 Thread S . Isaac Dealey
> 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

Re: Query size

2002-11-08 Thread Jochem van Dieten
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 ~~

RE: Query size

2002-11-07 Thread Jeff
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&#x

Re: Query size

2002-11-07 Thread Paul Hastings
> 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

RE: Query size

2002-11-07 Thread Jeff
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

Re: Query size

2002-11-07 Thread Srimanta
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

Re: Query size

2002-11-07 Thread Srimanta
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

RE: Query size

2002-11-07 Thread Jeff
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

RE: Query size

2002-11-07 Thread Jim Davis
> > 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

Re: Query size

2002-11-07 Thread Srimanta
- 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

RE: Query size

2002-11-07 Thread S . Isaac Dealey
> 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

RE: Query size

2002-11-07 Thread Mosh Teitelbaum
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

Re: Query size

2002-11-07 Thread S . Isaac Dealey
> - 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

Re: QUERY SIZE.

2002-11-07 Thread Frank Mamone
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

Re: Query size

2002-11-07 Thread Gyrus
- 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

Re: Query size

2002-11-07 Thread Jeff Garza
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