Gentlemen, I'm not new with DBI by any means, but I am having the most terrible time finding what is wrong with this code.
These are the declarations of the queries. It goes to a MySQL database.
sub recursive_print_traversal {
$parent = shift; # the parent
$addr = "select * from address_tbl where Subnet='$parent'";
$subs = "select * from subnet_tbl where VLAN='$parent'";
$addr_str = $dbh->prepare($addr); # prepare address sele
+ct
$subs_str = $dbh->prepare($subs); # prepare subnet selec
+t
$addr_rst = $addr_str->execute(); # execute address sele
+ct
$subs_rst = $subs_str->execute(); # execute subnet selec
+t
Later I attempt to use the MySQL queries, like so.
if ( $subs_rst == 0){
print "<tr><td colspan=2 align=center>None.</td></tr>"
+;
print "</table></td></tr>";
} else {
while ( @row = $subs_rst->fetchrow_array ) {
>> recursive_print_traversal($row[0]);
}
}
However, it yields the following error.
Can't call method "fetchrow_array" without a package or object referen
+ce at /var/www/cgi-bin/report.cgi line 127.
The line is question is mark with ">>" above.
amt
====
This problem has been solved. Curse PHP for what it has done to my Perl over the past month...
====
Janitored by davido: Restored deleted content. Please don't delete the contents of your nodes once the question has been resolved.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.