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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]