In the table that fails, and the one that works, I'm
using some products from a company called Interakt. I
mentioned this in my last reply, however didn't
mention one part.
With this suite of tools , I can replace a text area
with a mini html / cms tool. Basic formatting etc.
Now in the 2nd table where the insertion works. The
form works great, retains all the formatting of the
original document.
Stuart
--- Victor Pendleton <VPendleton@stripped> wrote:
> What is the application you are using to insert and
> retrieve the blob data?
> Is the data actually being inserted?
>
> -----Original Message-----
> From: Stuart Felenstein
> To: mysql@stripped
> Sent: 8/18/04 2:49 PM
> Subject: Strange Text Field
>
> Hoping I can figure this out. Using MySQl
> 4.0.20-Standard.
>
> I have a table (tried this both myISAM and Innodb)
> with 12 fields, 3 are ints, 7 are varchars and 1 is
> set to text.
> Form is using a textarea for input into the text
> field. Basically a copy and paste of rich text.
> (I'm
> not concerned with formatting right now)
>
> Anyway it won't take and returns a vague SQL syntax
> error. If I try to input it directly into the
> database
> I get an error about the grid being 12 columns and
> the
> clipboard being 1 column. Yet I had all the other
> fields filled in. And all but the ID is set to
> allow
> nulls.
>
> Frustrated to figure out why this is occuring I
> created a table with 2 fields, one for the recordID,
> the other for the text dump. Works like a charm.
>
> So has anyone seen this before ? It seems odd ,
> I've
> searched the manual and bug base and came up with
> nothing.
>
> Thank you ,
> Stuart
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
>
>
