List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:August 18 2004 8:21pm
Subject:RE: Strange Text Field
View as plain text  
Are both of these fields defined as blob datatypes? Since one table works
and the other does not work this leads me to question whether the
application is performing consistently. Have you verified if data is entered
into that does not display as expected?

-----Original Message-----
From: Stuart Felenstein
To: Victor Pendleton; 'mysql@stripped '
Sent: 8/18/04 3:14 PM
Subject: RE: Strange Text Field

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
> 
> 
Thread
Strange Text FieldStuart Felenstein18 Aug
  • Re: Strange Text FieldRhino18 Aug
    • Re: Strange Text FieldStuart Felenstein18 Aug
    • Re: Strange Text FieldStuart Felenstein18 Aug
RE: Strange Text FieldVictor Pendleton18 Aug
  • RE: Strange Text FieldStuart Felenstein18 Aug
  • RE: Strange Text FieldStuart Felenstein18 Aug
    • Re: Strange Text FieldDan Nelson18 Aug
      • Re: Strange Text FieldStuart Felenstein18 Aug
    • RE: Strange Text Field(Terry Riley)19 Aug
RE: Strange Text FieldVictor Pendleton18 Aug
  • RE: Strange Text FieldStuart Felenstein18 Aug