query size error

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

Re: Query size

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

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... each character

Re: Query size

: 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

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

Re: Query size

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. Unusual requirement. Had a quick look through the list of Cf functions

Re: Query size

- 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 miss

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

Re: QUERY SIZE.

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 a way

Re: Query size

- 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 miss

RE: Query size

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

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^) Or ... #len(#valuelist(myquery.textcolumn)##valuelist(myquery.anothertextco lumn)#)#

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

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^) I would think that simplest way would be to squirt the data out to a file with

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

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

Re: Query size

: 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

RE: Query size

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, I am using MS SQL. Srimanta - Original Message - From: Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

Re: Query size

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 /

RE: Query size

. 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't that be SELECT foo, bar, hum