MachForm Community Forums » MachForm 2

1. hiremdm
   Member

   I have a very long form with about 100 fields. I'd prefer to break it into sections, but have already read posts here indicating this is not possible at the present time. Anyway, the form loads fine but I cannot enter data or modify it without receiving SQL errors.

   When trying to edit the form, I receive an error that a ")" is missing in the statement. You can look at the form here:

   http://jetstream.s20161.gridserver.com

   Is there a maximum number of fields in MachForm? Also, I've notice that the field bombing out seems to be an address group.

   Posted 15 years ago #

2. hiremdm
   Member

   I figured out the problem. I was using a large number of address and name fields, all of which create a multiple varchar columns with lengths of 255 characters. MySQL has a limit of 65k bytes per record, and the large number of fields combined with the large columns exceeded this. I simply modified the code to give these columns a width of 100 characters.

   Posted 15 years ago #
3. 

   yuniar

   Wow.. you have an amazing debugging skill.
   Do you have any URL regarding this 65kb record limit?

   ---

   MachForm Founder

   Posted 15 years ago #

4. hiremdm
   Member

   Thanks, but YOU have an amazing product. Here are the links for MySQL 4.x and 5.x ...

   http://dev.mysql.com/doc/refman/4.1/en/column-count-limit.html
   http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html

   Posted 15 years ago #
5. 

   yuniar

   Thanks for the links! I didn't know about this limit before.

   ---

   MachForm Founder

   Posted 15 years ago #

RSS feed for this topic

Reply

You must log in to post.