I understand about supplying the code and will. I'm
actually rebuilding it again.
Language is Php and Adodb and not to get to estoteric,
I'm using a RAD called Impakt which fits into
Anyway, while I can supply the code, the weirdness is
that it won't work in one table but will in another.
THe code is the same for both.
After I rebuid the form I'll go ahead and post it.
--- Rhino <rhino1@stripped> wrote:
> ----- Original Message -----
> From: "Stuart Felenstein" <stuart4m@stripped>
> To: <mysql@stripped>
> Sent: Wednesday, August 18, 2004 3: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
> > set to text.
> > Form is using a textarea for input into the text
> > field. Basically a copy and paste of rich text.
> > not concerned with formatting right now)
> > Anyway it won't take and returns a vague SQL
> > error. If I try to input it directly into the
> > I get an error about the grid being 12 columns and
> > clipboard being 1 column. Yet I had all the other
> > fields filled in. And all but the ID is set to
> > nulls.
> > Frustrated to figure out why this is occuring I
> > created a table with 2 fields, one for the
> > the other for the text dump. Works like a charm.
> > So has anyone seen this before ? It seems odd ,
> > searched the manual and bug base and came up with
> > nothing.
> Unless someone can quickly identify it is as a
> well-known issue, I suggest
> that you supply some code fragments that show what
> you're doing, as well as
> any error messages you are getting. Right now, we
> don't even know what
> language you're using, let alone what might be wrong
> in your code.
> I have successfully copied regular text from a form
> text field to a MySQL
> table but I've never tried rich text; I'm not even
> sure how to get rich text
> *into* a text field on a form. I might use a
> clipboard that is sensitive to
> rich text to get the rich text onto the form field
> but I wouldn't have
> thought of using it to transfer data between the
> form and MySQL. Therefore,
> I can't even visualize roughly how you're doing what
> you're doing let alone
> what sort of coding error you might have made. I
> suspect I speak for others
> on this list, too.
> Does your program store the data correctly if you
> just put regular text in
> the form field, rather than rich text? That might
> help determine if this is
> some kind of encoding/codepage problem.