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