Can't bind unknown placeholder '1' at ..site/lib/DBI/ProxyServer.pm line 329.

[Murali.Kanaga]

Hi Gurus,

Greetings!

My perl script is using the DBI 1.37 & DBD-ODBC 1.06 to connect from
Unix to our 
Windows SQL Server via Proxy. The SQL query that I am doing is very
simple. 

Here is the Query:

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);
 
while ( my $row = $sth->fetchrow_hashref) {
my $flag_no_row = 1;
$release_status = $row->{status}; 
$release_ID = $row->{version}; 

Any help/pointers to resolve this would be very much appreciated.

Thanks,
-Murali


Error Message from the dbi proxy server:

        Thu Apr  8 10:20:34 2004 debug, Accepting client
        Thu Apr  8 10:20:34 2004 debug, Client executes method
CallMethod
        Thu Apr  8 10:20:34 2004 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0x3a7e790),STORE,AutoCommit,1
        Thu Apr  8 10:20:34 2004 debug, CallMethod: <= 1
        Thu Apr  8 10:20:34 2004 debug, Client executes method
CallMethod
        Thu Apr  8 10:20:34 2004 debug, CallMethod: =>
DBI::ProxyServer::db=HASH(0x3a7e790),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  = 83481 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,,ARRAY(0x3a77934)

        Thu Apr  8 10:20:34 2004 debug, CallMethod died with: Can't bind
unknown placeholder '1' at
//eops1/netperl/site/lib/DBI/ProxyServer.pm line 329.

        Thu Apr  8 10:20:34 2004 debug, Client executes method
DestroyHandle
        Thu Apr  8 10:20:34 2004 debug, Child terminating.