Undefined subroutine &main::prepare ??

Eagle_f91 has asked for the wisdom of the Perl Monks concerning the following question:

I have been folowing the Reading form a database guide at Reading from a database and have ran into a problem that I can not find an answer for. I have checked the FAQs and did a search but nothing really came up that helped. Like the guide shows I am tryign to use the prepare statement to prepare and SQL command but when I run the script I get the error: Undefined subroutine &main::prepare called at D:\crystalreverie.com\www\members\signup.pl line 28. Line 28 contains this code: $sth = prepare (qq~execute new_registrations $uid $pass $charactername $realname $email~) or die "Could not prepare statement: $DBI::errstr; stopped"; What would be causing this?

Edited by Chady -- fixed URL.

Comment on Undefined subroutine &main::prepare ?? Select or Download Code

Replies are listed 'Best First'.
Re: Undefined subroutine &main::prepare ?? by marto (Cardinal) on Jul 25, 2005 at 16:13 UTC
Hi, I think you want something like: `my $sth = $dbh->prepare($sql);` [download] Perhaps reading Before asking a database related question ... would be a good idea, it lists good documents to read, and is good advice in general. Hope this helps Martin	[reply] [d/l]
Re^2: Undefined subroutine &main::prepare ?? by Eagle_f91 (Acolyte) on Jul 25, 2005 at 16:18 UTC
Yes, that fixed it. Thank you.	[reply]