On 10/15/07, pauld <[EMAIL PROTECTED]> wrote: > thank you . > this is why it cant execute > > Can't execute: called with 1 bind variables when 0 are needed > > my $sql="SELECT value,text FROM res_prior"; > > has no bound variables - or has it ?
It has no bound variables. They look like this my $sql = "SELECT value, text FROM res_prior WHERE value BETWEEN ? AND ?"; my $sth = $dbh->prepare($sql); $sth->execute(0, 10); -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
