I am getting this error
Error during query: Unexpected Exception:
java.lang.IllegalArgumentException message given: Packet is larger
than max_allowed_packet from server configuration of 1048576 bytes
Is there any way to change the max packet size? I can't seem to find
anyting in the admin.
I don
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
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
> 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
1
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
> - 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
>> thr
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:
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
- 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 ... did
From: "Srimanta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 12:55 PM
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. Unu
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
20 matches
Mail list logo