Your calling your execute with a variable of some kind but your sql has no place holders for your bind variable i.e. you would have '?' in your sql i.e. select value,test from res_prior where res_prior_id=? -> execute(12);
-----Original Message----- From: pauld [mailto:[EMAIL PROTECTED] Sent: 15 October 2007 10:13 To: beginners@perl.org Subject: Re: why "cant execute " error ? 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 ? -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/ This e-mail is from the PA Group. For more information, see www.thepagroup.com. This e-mail may contain confidential information. Only the addressee is permitted to read, copy, distribute or otherwise use this email or any attachments. If you have received it in error, please contact the sender immediately. Any opinion expressed in this e-mail is personal to the sender and may not reflect the opinion of the PA Group. Any e-mail reply to this address may be subject to interception or monitoring for operational reasons or for lawful business practices. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
