Re: [cgiapp] dbh-quote error I can't see

2004-11-30 Thread Ron Savage
On Mon, 29 Nov 2004 14:08:27 -0500, Cees Hek wrote: Hi Cees, et al  Create a class for your table:  package MyDB::Authorize;  use base qw(Class::DBI::mysql);  __PACKAGE__-set_up_table('authorize');  1;  And now for the code to update the database:  unless ( $error ) {  my $authorize =

Re: [cgiapp] dbh-quote error I can't see

2004-11-29 Thread Jaclyn Whitehorn
Ed, I think it's not saying that $authcode is undefined, it's saying that $dbh is. Looking at: my $dbh = $q-param( 'mydbh' ); Usually I store my database handle in the CGI::App object ($self), not the CGI.pm query object ($q). Is it possible that you're doing the same? Of course if

Re: [cgiapp] dbh-quote error I can't see

2004-11-29 Thread Cees Hek
On Mon, 29 Nov 2004 12:08:25 -0600, Ed Pigg [EMAIL PROTECTED] wrote: Hi all, I've been knocking my head against an error I get from $dbh-quote and I'm sure that I'm missing something obvious. I've just been looking at the same thing too long. Here's the environment Michael has already

Re: [cgiapp] dbh-quote error I can't see

2004-11-29 Thread Ed Pigg
On Nov 29, 2004, at 12:19 PM, Michael Peters wrote: The error message doesn't mean that $authcode, $reqname, $created_ip don't have values but that your $dbh is undefined. Test what you're $dbh is before you call quote(). You're pulling it from the param() but not checking to see if it's