Probably because nothing is returned. Try running the same query directly
in db, then see. Make sure you use the same where values, might want to
print them out to make sure they are what you expect.
No bind_params and execute(@params) is the same thing. execute calls
bind_params behind the scenes.
Ilya
-----Original Message-----
From: Rozengurtel, Daniel
To: Sterin, Ilya
Sent: 2/20/02 10:32 AM
Subject: RE: Bind Param and PlaceHolders
Well , i just dont get any values from the print statement. :( As if
nothing
happens. No error messages generated.
Ilya, If i use bind_params, should it make diff?
> -----Original Message-----
> From: Sterin, Ilya [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 20, 2002 12:30 PM
> To: 'Rozengurtel, Daniel '
> Subject: RE: Bind Param and PlaceHolders
>
> Nothing looks wrong. What's the error message you are getting. It's
hard
> to help without knowing what's actually wrong:-)
>
> Ilya
>
>
>
> -----Original Message-----
> From: Rozengurtel, Daniel
> To: '[EMAIL PROTECTED]'
> Sent: 2/20/02 10:21 AM
> Subject: Bind Param and PlaceHolders
>
> Hello to all,
>
> I am struggling with creating the prepared statement, passing to it a
> placeholder param, and then executing in "execute " statement.
> It seems not to be working. Can you please give me a suggestion/fix to
> my
> problem.
>
> Thanx a lot,
> Daniel
>
> PS: What am I doing wrong???
> Oh. I use DBI version 1.15 .
>
> my $sth_incl = $dbh->prepare(q{SELECT CL_DESC from FT_T_INCL WHERE
> INDUS_CL_SET_ID=? AND CL_VALUE=?} ) || die $dbh->errstr;
> ......
> ......
> $temp='BBINDGRP';
> $x='0014';
> .........
> .........
> $sth_incl->execute($temp, $x);
> @indgrp = $sth_incl->fetchrow_array;
> print "@indgrp\n";
>
>
>
>
>
> _____________________________________________________________________
> IMPORTANT NOTICES:
> This message is intended only for the addressee. Please
notify
> the
> sender by e-mail if you are not the intended recipient. If you are not
> the
> intended recipient, you may not copy, disclose, or distribute this
> message
> or its contents to any other person and any such actions may be
> unlawful.
>
> Banc of America Securities LLC("BAS") does not accept time
> sensitive, action-oriented messages or transaction orders, including
> orders
> to purchase or sell securities, via e-mail.
>
> BAS reserves the right to monitor and review the content of
all
> messages sent to or from this e-mail address. Messages sent to or from
> this
> e-mail address may be stored on the BAS e-mail system.
>
>
_____________________________________________________________________
IMPORTANT NOTICES:
This message is intended only for the addressee. Please notify
the
sender by e-mail if you are not the intended recipient. If you are not
the
intended recipient, you may not copy, disclose, or distribute this
message
or its contents to any other person and any such actions may be
unlawful.
Banc of America Securities LLC("BAS") does not accept time
sensitive, action-oriented messages or transaction orders, including
orders
to purchase or sell securities, via e-mail.
BAS reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from
this
e-mail address may be stored on the BAS e-mail system.
