DBD::Proxy::st execute failed: CallMethod: Can't bind unknown placeholder

murali_at_epiphany.com
Date: 12/15/03 

Date: Mon, 15 Dec 2003 14:12:22 -0800
To: <dbi-users@perl.org>

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

Relevant Pages

  • Re: Access Query - DateTime
    ... > I have a DateTime field in my Access table named AuditTime. ... > I'm having trouble creating a SQL query that will return all records ... > "No value given for one or more parameters" is the error message. ...
    (microsoft.public.access.gettingstarted)
  • Re: Lost data source
    ... If the "error message" that you mention concerns running an SQL query, ... I've had to choose the data source over again for more ... is there any way to find out which table these letters were previously ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Whats wrong with my SQL query ?
    ... I have a SQL query that perfectly works using *SQL Entreprise Manager*. ... But when i try to use the very same in a VBS script i got an error ... (error message here in french: ... I don't read french so I've only guessed at which of the field comes from ...
    (microsoft.public.scripting.vbscript)
  • Re: Headers already sent problem online, but not offline
    ... That's a side effect of your primary problem, namely that your SQL query is ... That results in an error message when you try to use the result ... means that you can't send out any futher headers. ... All three preceding statements need error checking; ...
    (comp.lang.php)
  • Re: INSERT statement falied: Column count doesnt match value count at row 1
    ... > I am getting this wierd error message when running the following ... > When I check the sql query in the mysql monitor it works fine. ... > value appears in a select * statement on the database. ...
    (php.general)