Apache::DBI and CGI::Application with lots of modules.

2002-10-12 Thread Eric Frazier
Hi, I am glad to see the list traffic has been picking up lately. It makes me have higher hope about posting this. First some background info. I have a fairly large CGI::Application module about 30 run modes that pretty much follows the example mailform module. I am also using HTML::Template w

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-12 Thread Perrin Harkins
I'm just going to point out a few problems. These are not all related to your questions. >package Holds; > The case of "Holds" doesn't match the example sub you posted above. I'm assuming that was a typo. >use strict; >use Carp; >use warnings; >use QueryPrint; >use vars qw($dbh $processed_h

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-12 Thread Eric Frazier
Perrin, I am going to read over this closely, thanks for all of the advice! What frustrats me about the search getting cached/closure thing is that I just don't have any global variables that have anything to do at all with the search results. I have read over and over examples with closures, r

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-13 Thread Eric Frazier
Hi, Here is the kind of thing that is driving me nuts. Please see: http://perl.apache.org/docs/general/perl_reference/perl_reference.html#Remed ies_for_Inner_Subroutines If what this says is true, then either I don't have a closure type problem, or else what is says isn't true. It says that if

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-14 Thread Perrin Harkins
Eric Frazier wrote: > Here is the kind of thing that is driving me nuts. Please see: > http://perl.apache.org/docs/general/perl_reference/perl_reference.html#Remed > ies_for_Inner_Subroutines > > If what this says is true, then either I don't have a closure type problem, > or else what is says i

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-14 Thread Eric Frazier
At 11:58 AM 10/14/02 -0400, Perrin Harkins wrote: >Eric Frazier wrote: >> Here is the kind of thing that is driving me nuts. Please see: >> http://perl.apache.org/docs/general/perl_reference/perl_reference.html#Remed >> ies_for_Inner_Subroutines >> >> If what this says is true, then either I don

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-14 Thread Eric Frazier
Perrin, I am starting to feel guilty about bugging you so much, but you are the only person to have responded, and I watch the list enough to value your advice quite a bit. >>sub new { >>my $invocant = shift; >>my $class = ref($invocant) || $invocant; >> > >That

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-14 Thread Perrin Harkins
Eric Frazier wrote: > I wanted the DBH to be global since just about every sub in Holds does a > query of some sort. Three options: 1) Pass it to every sub 2) Make a utility sub that returns a dbh and call it from each sub. (Sounds like you already made one of these.) 3) Stuff it in $r->pnotes()

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-14 Thread Rafiq Ismail
On Mon, 14 Oct 2002, Eric Frazier wrote: > >That looks like voodoo code copied from a man page. If you call this as > >Holds->new(), you don't need that junk about ref. (And most people > >recommend against the "new Holds" syntax.) > > I wanted the DBH to be global since just about every sub in

RE: Apache::DBI and CGI::Application with lots of modules.

2002-10-14 Thread Jesse Erlbaum
Hey Eric -- > I wanted the DBH to be global since just about every sub in Holds does a > query of some sort. I guess it doesn't matter either way if I do > the connect > in the new() vs up top outside of a sub. CGI::Application has a facility which is intended to solve exactly this type of prob

Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-15 Thread Eric Frazier
Hi, I had to read that over a few times to get it. And now I see that I do indeed have that situation, there are a number of times when I call my $holdstatus = new Holds(); from within a module that also has a new method. What I don't understand is how does my code work at all? Thanks, Eric

Re: Apache::DBI and CGI::Application with lots of modules. (fwd)

2002-10-14 Thread Rafiq Ismail
On Mon, 14 Oct 2002, Eric Frazier wrote: > >That looks like voodoo code copied from a man page. If you call this as > >Holds->new(), you don't need that junk about ref. (And most people > >recommend against the "new Holds" syntax.) > > I wanted the DBH to be global since just about every sub in

Re: [cgiapp] Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-14 Thread William McKee
On 14 Oct 2002 at 9:12, Eric Frazier wrote: > That I am not so sure of. I will do some more investigation. It seems like > the only variables that could be causing this are the result set from the > query and the scalar which holds the html template. I feel like I know > absolutly nothing now :(

Re: [cgiapp] Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-15 Thread Eric Frazier
Hi, I am learning lots of new things, but still working on the problem itself. It seems to be the case that even when I am running under ./httpd -X I have trouble getting the search query to get stuck. If I do something from the mysql monitor like set an order on hold directly with a query, the

Re: [cgiapp] Re: Apache::DBI and CGI::Application with lots of modules.

2002-10-15 Thread William McKee
On 15 Oct 2002 at 7:12, Eric Frazier wrote: > I am learning lots of new things, but still working on the problem itself. > It seems to be the case that even when I am running under ./httpd -X I have > trouble getting the search query to get stuck. If I do something from the > mysql monitor like s