We have a web app that were selling and have run into a technical
problem. I thought some of the gurus out there may be able save us some
time chasing down the solution.
We're noticing a problem when large sales orders are submitted over the
web.
We build the part, quantity and unit of measure list on the client (using
JavaScript variables), then submit them to a database server when the
client clicks to submit the order.
It appears that the somewhere down the line the string of data we send to
the database server is getting truncated. The problem only occurs on very
large orders (about 100 line items). We submit the content of the
variables using a cgi call created through JavaScript. I can also send
submissions using a Java Applet if I need to, but in this case we're
using CGI.
I'm wondering if anyone knows what the size limit is for a JavaScript
variable and/or if there is a limt on how long the data string can be
when making a CGI script submission.
We're trapping the data that does get through to the database server and
it appears that these records (which are truncated because of the
problem) are about 2.2K bytes long.
Any one know what the limitations are? The database server is only
limited by the size of the hard disk, so the problem isn't with the
database server.
Thanks in advance.