Re: POSTing to XML...

rf escribió:
"transpar3nt" <casperghosty@xxxxxxxxx> wrote in message news:1859d338-1b56-4f2b-96de-593ac3c6dd40@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello, I am building a small app for the electronics store I work for
that allows employees to enter product information and it outputs a
printable sales estimate for the customer. I have it working
flawlessly, except that since I am using a MySQL database to store the
input info, I am limited by the number of rows in the db table (20
sets of each field type = 20 item rows on the printout).

Never heard of such a limit.

The OP is probably using a estimates table with this columns: estID, taxRate, date, description1, description2, description3... description20

.... and he's hitting the DB engine's max column size limit:

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

The obvious suggestion:

estimates: estID, taxRate, date
items: itemID, estID, taxed, description, model...

And them some _basic_ SQL abilities you car earn in a few minutes.


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--
.

Relevant Pages

  • Re: POSTing to XML...
    ... that allows employees to enter product information and it outputs a ... printable sales estimate for the customer. ...
    (comp.lang.php)
  • Re: POSTing to XML...
    ... printable sales estimate for the customer. ... except that since I am using a MySQL database to store the ...
    (comp.lang.php)
  • Re: POSTing to XML...
    ... printable sales estimate for the customer. ... except that since I am using a MySQL database to store the ...
    (comp.lang.php)