Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re: Can't call method "bind_columns" on an undefined value

by jesuashok (Curate)
on Mar 28, 2007 at 02:01 UTC ( #606897=note: print w/replies, xml ) Need Help??

in reply to Can't call method "bind_columns" on an undefined value

my $data = qq(SELECT catname, path, root FROM categories WHERE root = +"1" ORDER BY catname ASC); my $sth = $dbh->prepare($data); $sth->execute() or die $dbh->errstr; my ($catname, $path, $root); $sth->bind_columns(\$catname, \$path, \$root); while($sth->fetch) { print qq~ <a href="$path">$catname</a><br> ~; }

Variable Scoping in Perl: the basics

hmmm ....let me think what did I said

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://606897]
[Discipulus]: choroba i made you Bishop !!
[choroba]: 9999 points until level 23 - Archbishop.
[LanX]: darn trying to downvote him again fails ... ;-P
[Discipulus]: congrats!
[LanX]: His Excelleny Choroba will now nbe clothed in his new robe ...
[Discipulus]: bishop ship sheeps in the shop..
[1nickt]: Discipulus too easy!
[1nickt]: "The sixth sheik's sixth sheep's sick" (if you are after 'sh' tongue twisters)
[Discipulus]: ok try it in Eatalian ;=)
[Eily]: Discipulus I don't suppose you can do the same for me can you ? :P

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (11)
As of 2017-09-26 12:00 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (294 votes). Check out past polls.