Re: [cgiapp] Re: utf8 form processing

2008-10-22 Thread Silent
the CGI::charset() is useful when I use escapeHTML() to escape form values, in CGI.pm : sub escapeHTML { ... ... my $latin = uc $self-{'.charset'} eq 'ISO-8859-1' || uc $self-{'.charset'} eq 'WINDOWS-1252'; if ($latin) { # bug in some

Re: [cgiapp] Re: Unexpected variable persistence with CAD / CADS

2008-10-22 Thread George Hartzell
Richard Jones writes: Mark Stosberg wrote: It doesn't seem to happen in an identical setup running under mod_perl, so I presume it's a 'feature' of the CAD::Server / HTTP::Server. Is this a known issue, and one of the caveats alluded to in the CAD::Server docs? Never been a

Re: [cgiapp] Model design in C::A/Titanium

2008-10-22 Thread Ron Savage
Hi Mark On Tue, 2008-10-21 at 15:20 -0400, Mark Rajcok wrote: I would appreciate some feedback on a possible MVC structure for a Titanium/CGI::App that I am currently building. I'm using CA::Dispatch to I too use CGI::Application::Dispatch - a fine module indeed. allow multiple apps

Re: [cgiapp] Re: Unexpected variable persistence with CAD / CADS

2008-10-22 Thread George Hartzell
Mark Stosberg writes: On Tue, 21 Oct 2008 14:02:37 +0100 Richard Jones [EMAIL PROTECTED] wrote: Richard Jones wrote: That value of 'id' (2 in this case) persisted from the previous action, and will continue to live indefinitely across multiple requests until it is

[cgiapp] cached DBI connections with cgiapp/fastcgi

2008-10-22 Thread Benjamin Hitz
We are modifying our CGI::App to run under fastcgi/DBI/Oracle10g. CGI::Application::Plugin::FastCGI seems to work not at all, We use the help from this page: http://cgiapp.erlbaum.net/?FastCGI to pass the query params (uses CGI::Fast). And in the cgiapp_init method we call:

Re: [cgiapp] cached DBI connections with cgiapp/fastcgi

2008-10-22 Thread Michael Peters
Benjamin Hitz wrote: So - I hope this is a useful summary for people who are still trying this - and also I am hoping that someone has some insight on why my $dbh goes stale. It was my understanding that $self-dbh_config would reconnect if the handle went bad but probably I am

Re: [cgiapp] cached DBI connections with cgiapp/fastcgi

2008-10-22 Thread Perrin Harkins
On Wed, Oct 22, 2008 at 1:33 PM, Benjamin Hitz [EMAIL PROTECTED] wrote: It basically calls DBI-connect_cached(dbi:Oracle:sdev2, $user, $pass, { RaiseError=1, AutoCommit=0, private_cachekey = $0 }); That ought to work. The connect_cached call should ping the connection and reconnect if it's

Re: [cgiapp] cached DBI connections with cgiapp/fastcgi

2008-10-22 Thread Benjamin Hitz
On Oct 22, 2008, at 10:48 AM, Perrin Harkins wrote: On Wed, Oct 22, 2008 at 1:33 PM, Benjamin Hitz [EMAIL PROTECTED] wrote: It basically calls DBI-connect_cached(dbi:Oracle:sdev2, $user, $pass, { RaiseError=1, AutoCommit=0, private_cachekey = $0 }); That ought to work. The

Re: [cgiapp] Model design in C::A/Titanium

2008-10-22 Thread Mark Rajcok
On Tue, Oct 21, 2008 at 7:45 PM, Ron Savage [EMAIL PROTECTED] wrote: Hi Mark Just the Model aspect is proving a little challenging. I'm trying to ensure that all database calls are handled outside the controllers, and to this end am using a module called WebApp::Model This seems to

Re: [cgiapp] Model design in C::A/Titanium

2008-10-22 Thread Ron Savage
Hi Mark On Wed, 2008-10-22 at 22:35 -0400, Mark Rajcok wrote: On Tue, Oct 21, 2008 at 7:45 PM, Ron Savage [EMAIL PROTECTED] wrote: [snip] But why /exactly/ is it growing? Ron, I wasn't too clear about who I was quoting. Richard Jones had the growing Model class, so he would need to