Michael,
Here is the log you asked for:
The value of region is Atlantic
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^A' ORDER BY dept, pay_list
LIMIT 0, 400
The value of region is Atlantic
The value of deptLtr is I
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^I' ORDER BY dept, pay_list
The value of region is Atlantic
The value of deptLtr is O
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^O' ORDER BY dept, pay_list
The value of region is Atlantic
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^A' ORDER BY dept, pay_list
LIMIT 0, 400
The value of region is Atlantic
The value of deptLtr is K
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^K' ORDER BY dept, pay_list
The value of region is Atlantic
The value of deptLtr is F
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^F' ORDER BY dept, pay_list
The value of region is Atlantic
The value of deptLtr is F <- ERROR I selected C
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^F' ORDER BY dept, pay_list
The value of region is Atlantic
The value of deptLtr is O <- ERROR I selected C
The value of set is 0
SELECT * FROM atlantic_rr WHERE dept REGEXP '^O' ORDER BY dept, pay_list
Thanks.
-----Original Message-----
From: Michael Peters [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 3:47 PM
To: Dondi Stroma
Cc: modperl@perl.apache.org
Subject: Re: CGI.pm param and mod_perl
Dondi Stroma wrote:
> I don't see what is so bad about this:
>
> use vars qw($q);
> $q = CGI->new();
>
> Even though it's a global variable, you are assigning it a new value,
> CGI->new, each time.
You're right. I don't normally think about registry scripts since I
almost never use them. I was thinking he was doing that at the top of a
module such that it was happening at compile time. But even then my
advice wasn't that helpful since the assignment would still only happen
at compile time.
> I suspect the problem is something else, possibly part of the script
> that we haven't seen.
Yeah, I'm starting to think the same thing. Brian, why don't you print
the value of the param to the log ("warn" is good for this) for the
request (along with the SQL that you're generating) so you/we can see
what the actual value being pulled it.
--
Michael Peters
Plus Three, LP
