RE: limit to the number of characters allowed in a query?

2001-01-11 Thread Mark Dale
I've tried "mysql --set-variable=max_allowed_packet=8M" with no luck. I'm not getting the error message. The query has multiple selects. When I copy and paste the query with 4 selects in it, everything's fine. If I try with 5, it dies half way thru the 5th select as its pastes. Any more clues

RE: limit to the number of characters allowed in a query?

2001-01-11 Thread Quentin Bennett
There is a limit to the size of a packet sent to mysqld, which is configurable. Check the manual for it, and see if you are hitting that. Regards Quentin > -Original Message- > From: Mark Dale [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 12, 2001 12:39 PM > To: [EMAIL PROTECTED] >