Using Frontpage, I am tying to create an asp page with a form for inputing data to a MySQL db. Things seem to be working except for one curious problem, records entered with a length greater than a record already established in the database are not stored.
For example I have a TEXT field (description)in a table called ticket. From MySQL command line I entered
INSERT INTO ticket(description)
VALUES("Hello World"
;
Using the form on the asp page if I enter "Hello" and then submit, the record is recorded in the table.
However if on the form I enter "Hello World 2" (or anything with a string length greater than that of Hello World) the record is not recorded in the table.
As a workaround for this I can enter from command line a string of thousands of characters for that field, but there must be an easier way.
Any help is appreciated.
Kevin M. Douglas
kevin@easternresearch.com
For example I have a TEXT field (description)in a table called ticket. From MySQL command line I entered
INSERT INTO ticket(description)
VALUES("Hello World"
;Using the form on the asp page if I enter "Hello" and then submit, the record is recorded in the table.
However if on the form I enter "Hello World 2" (or anything with a string length greater than that of Hello World) the record is not recorded in the table.
As a workaround for this I can enter from command line a string of thousands of characters for that field, but there must be an easier way.
Any help is appreciated.
Kevin M. Douglas
kevin@easternresearch.com