Is the maximum POST/GET differnet for mod_perl vs standard html? What is the maximum? I'm using CGI my($query) = CGI->new() (version 3.0)
I'm sure there are workarounds but I'm more concerned why it doesn't work as is.
-Tom
----Original Message Follows---- From: Thomas Schindl <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Tom Conway <[EMAIL PROTECTED]> CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Subject: Re: Data lost when browser refreshed Date: Mon, 15 Dec 2003 18:29:24 +0100
What submit-method are you using? GET/POST maybe you are exceeding the GET-Maximum?
What are you using CGI.pm or Apache::Request? You could retrieve params using @names = $cgi->param().
OT: You could also use placeholders, prepare the query once and execute it with your data within the loop.
Tom
On Mon, 2003-12-15 at 18:11, Tom Conway wrote:
> My initial browser-refresh problem was variable scoping and I've worked that
> out.
>
> I now have another odd problem.
>
> I have a function that reads params and creates update statements.
> Up to 18 lines of 5 elements each posted from a form.
>
> The Code is like...
>
> MyUpdate($dbc,$query)
> ....
> for ($cnt=0; $cnt<18; $cnt++) {
>
> $id = $query->param('id'.$cnt);
> $fname = '"'.$query->param('first_name'.$cnt).'"';
> $lname = '"'.$query->param('last_name'.$cnt).'"';
>
> $sql = qq{UPDATE table
> SET first_name = $fname, last_name = $lname
> WHERE id = $id};
>
> After about 7 times thru, param() returns NULL for last_name, first_name but
> the ID has a value.
> I use the same logic to retrieve data and it works fine.
>
> The same code works without mod_perl enabled.
>
> _________________________________________________________________
> Dont worry if your Inbox will max out while you are enjoying the holidays.
> Get MSN Extra Storage! http://join.msn.com/?PAGE=features/es
--
\\\||///
\\ - - //
( @ @ )
-oOo--( )--oOo----------------------------------------------------------
___ ___ tom schindl
o __ / / / innovative medientechnik planung AG
/ /\/\/ / / /__/ / __ mailto:[EMAIL PROTECTED]
/ / / / /_/ / / /___/ http://www.impire.de
/ voice:+43(512)34193431,fax:+43(512)34193420
Eduard-Bodem-Gasse 6, A-6020 Innsbruck, Austria, Software Engineering
------------------------------------------------------------------------
_________________________________________________________________
Browse styles for all ages, from the latest looks to cozy weekend wear at MSN Shopping. And check out the beauty products! http://shopping.msn.com
-- Reporting bugs: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html
