RE: Placeholders and select

[Sterin, Ilya]

Mark, you are asking for two placeholders and only binding one.  The
expression values() also looks wrong to me.  It's used in the insert
statement.

insert into foo values (...);

Ilya 

-----Original Message-----
From: Mark Riehl
To: [EMAIL PROTECTED]
Sent: 2/25/02 8:13 AM
Subject: Placeholders and select

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.