List:General Discussion« Previous MessageNext Message »
From:Stuart Felenstein Date:August 18 2004 8:11pm
Subject:Re: Strange Text Field
View as plain text  
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
Dreamweaver. 
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.

Thank you,
Stuart
--- 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
> 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.
> >
> 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.
> 
> Rhino
> 
> 

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