At 08:44 AM 5/11/00 -0700, you wrote:
> Hello,
> I've created a blob in MYSQL and when I pull up the data in the
>edit or display pages, it gets chopped off after the 39th character. I
>have no size limitations in my input or display fields.
>
> Since we are using MYSQL and not access (no memo field), I
>have to use "blob." Any ideas how to use blob to display large
>bodies of text and/or images?
There is a 4k literal text string limit in SQL insert and update
statements. There are procedures to get around this limit, involving stored
procedures (or <cfqueryparam > in 4.5). Perhaps this problem is due to
another SQL insert/update limit and the same solution will fix it.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
