Murali, You are calling 'execute' with the parameter $bfn, which instructs DBI/SQL Server to replace the first placeholder in the SQL statement with the value of $bfn. However there are no placeholders in the SQL statement to replace!
(Your use of $bfn in the SQL Statement is not a placeholder - the value in simply substituted by perl prior to the 'prepare' being performed - as would be the case with any other string). Either call 'execute' with no parameters for a one-off prepare and execute, or if you want to use the placeholder replace $bfn in the SQL statement with a single question mark ( ? ). Hope this helps, David. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 December 2003 22:12 To: [EMAIL PROTECTED] Subject: DBD::Proxy::st execute failed: CallMethod: Can't bind unknown placeholder Greetings!! We are using ActivePerl 5.6.1 (Build 635) & DBI (1.27) Proxy running on MS Windows to connect to SQL Server from Solaris. Even though the following SQL query succeeds in MS SQL Query Analyzer, Via DBI Proxy the following query returns an error: my $sth = $dbh->prepare( "select lkpver.text_string as version,lkpst.text_string as status from release_target rt, lookup lkpst, lookup lkpver where rt.product_issue_id = $bfn and lkpst.lookup_category_name = 'm2_release_target_status' and lkpst.code_int = rt.status_lkp and lkpver.lookup_category_name = 'm2_fix_in' and lkpver.code_int = rt.fix_in_version_lkp"); $sth->execute($bfn); The Error Message: DBD::Proxy::st execute failed: Server returned error: Failed to execute method CallMethod: Can't bind unknown placeholder '1' at E:/netperl/site/lib/DBI/ProxyServer.pm line 313. exec: DBI::st=HASH(0x41f870) Any Pointers, Help to resolve this issue would be very much appreciated. Thanks, -Murali _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. It must not be used by, or its contents copied or disclosed to, persons other than the intended recipient. However, the contents of this e-mail may be intercepted, monitored or recorded by Insurance Technology Solutions Limited for the purposes of ensuring compliance with its policies and procedures. Any liability (in negligence or otherwise) arising from any third party acting, or refraining from acting, on any information contained in this e-mail is excluded. Any views expressed in this message are those of the individual sender and do not necessarily represent the views of Insurance Technology Solutions Limited. If you have received this e-mail in error please notify the originator of the message. Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software.
