Placeholders and select

[Mark Riehl]

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";
  
.... (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?  I know that there is an
issues with selects, placeholders, and NULLs, but I don't think that this is
the issue here.

Any suggestions?

Thanks for the help,
Mark

-
Mark Riehl
Agile Communications, Inc.