My apologies to the list for this question. Turns out the error was
mine. mysql_error returns a truncated error message, which I incorrectly
interpreted as a truncated query string. Turns out my query string has
some other parsing error.
At least the subject line was appropriate. :-)
Joel Palenychka wrote:
>
> This is my first time using mysql with php3, and I've hit something that
> I want some confirmation on.
>
> I'm attempting to use the php3 function:
> $result = mysql_db_query("scene", $query);
>
> This works for small query strings, but when I get beyond 80 characters
> in the query it appears to get truncated, resulting in a parsing error
> of course.
>
> I've tried embedding '\n' characters in the hopes that perhaps mysql
> will interpret the query as a multi-line query, but no luck. I know this
> isn't a limitation of the $query variable in php3 as I am able to echo
> the whole query back to me. Is this a known limitation of mysql and is
> there some way to fix/get around it? Or am I doomed to limit my queries
> to 80 characters?
>
> Many thanks in advance,
> Joel Palenychka
>
> --
> ---
> ---
>
> "[We] are paralyzed by the fact that cruelty is often amusing."
> - Douglas Coupland
>
> --- (palenychka@stripped) (( http://members.home.net/palenychka )) ---
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread7183@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
--
---
---
"[We] are paralyzed by the fact that cruelty is often amusing."
- Douglas Coupland
--- (palenychka@stripped) (( http://members.home.net/palenychka )) ---