Can you give us more details on what you want to do? Do you want to stuff all 25,000 words into one field?
If you need to insert a large amount of data into one database field, I would suggest that you consider doing a file upload (via POST) in your CGI script. You can upload an arbitrarily large amount of data (and it's much more convenient for the end user to specify a file to upload than open it and paste it into a text field in a HTML form. Doing file uploads is very easy if you use the CGI Perl module. See <http://www.wiley.com/legacy/compbooks/stein/source.html> for an example (do a search on the page for 'upload' to find the demo cgi & source code). To store the data into a mysql database, you'll need to get familiar with the DBI Perl module. The DBI module enables perl scripts to query databases (including mysql). You can read the CGI and DBI docs at <http://www.perldoc.com>, CGI: <http://www.perldoc.com/cpan/CGI.html> and DBI: <http://www.perldoc.com/cpan/DBI.html>. On Fri, 19 Oct 2001, Bill Platt wrote: > Hello Everyone, > > I am curious of something. I am not even remotely knowledgable > of PHP but have some base knowledge of Perl, so Perl is my > language of choice. > > I am writing a set of scripts to send data pertinent to my > needs to a mysql database. > > I am deeply concerned about running into limitations not > precisely with the Perl itself, but with the post statement > in the forms I am using. > > Best I can tell in learning Mysql, I have to send all data > for the row at the same time and cannot post the data to the > mysql table incrementally. Due to the outline of what I am > working towards doing, I am breaking the data input into a > series of baby steps and passing the data from one form to > the next in the Post statements. My concern is that once all > data is implemented into the table row, I am in effect loading > nearly 25,000 words of text into the table! > > I sort of remember reading somewhere that the Post command in > the HTML Form has a limitation to the amount of data it can > pass between one form and another. I am certain that the > 25,000 words will exceed the top limits of the Post commands? > > Given my situation, is there something I am missing that you > could enlighten me about concerning passing chunks of this > much data to the Mysql database? I have wondered if I need > to send all of the text box data to temporary files for > later filing in the mysql database? Is this a viable solution? > Or am I just imagining a problem that does not exist? > > > Thanks, > > Bill Platt > _______________________________________________ > Perl-Unix-Users mailing list. To unsubscribe go to >http://listserv.ActiveState.com/mailman/subscribe/perl-unix-users > _______________________________________________ Perl-Unix-Users mailing list. To unsubscribe go to http://listserv.ActiveState.com/mailman/subscribe/perl-unix-users
