On Mon, 25 Feb 2002 10:13:06 -0500, Mark Riehl wrote:
>All - Running ActiveState under Win2k, database is MySQL.
>
>$sth_node = $dbh->prepare(qq{SELECT NODE_HOSTNAME, NODE_ADMIN_USERNAME, FROM
>NODE WHERE (NODE_ID = ?)
> VALUES (?)} ) ||
> warn "Error at prepare: $dbh->errstr";
Two placeholders.
>.... (following is inside a loop)
>
>$sth_node->execute($thisRouter) <<<- Line 141
> or warn "Can't execute SQL statement : $dbh->errstr";
>
>Uncaught exception from user code:
> execute called with 1 bind variables when 2 are needed at ... line
>141.
>
>Why does it say that I need 2 bind variables?
Because your statement contains 2 placeholders.
Still it doesn't look like valid SQL to me.
--
Bart.
