On Oct 15, 5:13 am, [EMAIL PROTECTED] (Pauld) 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 ?
Exactly. It doesn't. But you're passing an argument to execute(). Why? What part of the documentation that Gunnar told you to read shows you that execute() takes the SQL to execute as an argument? It doesn't. prepare() takes the SQL, and returns a statement handler. execute() only takes the bind parameters. If there are no bind parameters, it takes no arguments at all. Paul Lalli -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
