Re^5: Perl and Mysql Queries

I haven't a clue as to what the 'Can't call method "prepare' error means by 'undefined value'.

It's telling you that you have done effectively this:

$ perl -E '$x->prepare("foo");'
Can't call method "prepare" on an undefined value at -e line 1.
[download]

Your connection statement failed and therefore you don't have a defined database handle. So when you try to call the prepare method you are doing it on something which is undefined as $x is in the snippet above.

All of this is because the connection failed. Fix the first problem first, as always.

Which version of DBD::mysql are you running?

🦛

Comment on Re^5: Perl and Mysql Queries Select or Download Code

Replies are listed 'Best First'.
Re^6: Perl and Mysql Queries by Milti (Beadle) on Jun 11, 2024 at 15:08 UTC
New Error message Tue Jun 11 08:05:16 2024 error client 73.21.226.229 Undefined subroutine &main::param called at E:\\Pinnacle\\DiversityLink\\cgi-bin\\job_post_test.pl line 13., Why? Never had this before?	[reply]
Re^7: Perl and Mysql Queries by marto (Cardinal) on Jun 11, 2024 at 15:49 UTC
"Why? Never had this before?" You've posted inconsistencies in the code throughout this thread, and you've introduced another problem. Tutorials->Debugging and Optimization->Basic debugging checklist/CGI Programming->Troubleshooting Perl CGI scripts.	[reply]
Re^7: Perl and Mysql Queries by Danny (Hermit) on Jun 11, 2024 at 15:23 UTC
Undefined subroutine &main::param called That means CGI::param wasn't imported into main::param. It looks for main::param but can't find it. Make sure you import CGI::param with 'use CGI qw/:standard/;' or however you want. You might also consider using the object oriented style like. `use CGI: my $q = CGI->new; my $var = $q->param('param_key');` [download]	[reply] [d/l]
Re^7: Perl and Mysql Queries by hippo (Archbishop) on Jun 11, 2024 at 15:35 UTC
That's a regression. See etj's advice. 🦛	[reply]
Re^7: Perl and Mysql Queries by Milti (Beadle) on Jun 11, 2024 at 15:56 UTC
<error message Tue Jun 11 08:41:15 2024 error client 73.21.226.229 Undefined subroutine &main::param called at E:\\Pinnacle\\DiversityLink\\cgi-bin\\job_post_test.pl line 13., <Per a previous answer it appears that the following 'connect' statement has an error my $dbh = DBI->connect('dbi:mysql:jobs_db','Poster','Posterpasswd'); What could it be when GRANT ALL have been given to the user 'Poster' Identified by 'Posterpasswd' ?	[reply]
Re^8: Perl and Mysql Queries by marto (Cardinal) on Jun 11, 2024 at 16:03 UTC
Take the time to read and understand the responses to Re^6: Perl and Mysql Queries. Also: How do I post a question effectively?.	[reply]


Syntactic Confectionery Delight
	PerlMonks