Skip to Content.
Sympa Menu

freetds - RE: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS (CVS) , bind_param_ino ut

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chris McDaniel" <Chris.McDaniel AT telus.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS (CVS) , bind_param_ino ut
  • Date: Mon, 6 Jan 2003 08:33:33 -0700

Does anyone know why I'm not getting any data out of the @params marked
OUTPUT in the proc?

Code snippet:
---------------------------
$sth = $dbh->prepare('execute p_ccs_MakeBooking @ClientAccount="xxxxxx",
@PaymentNumber="xxxxxx", @ConferenceName="Scripts: 06:47 Booked",
@ConferenceComments="Created by Chris McDaniel", @ConferenceType=1,
@LanguageType=1, @PriorityType=2, @StartDateTime="2003-02-01 12:30:00",
@Duration=10, @Conferees=3, @SubConferees=0, @TollFreeInd=1,
@RecordingInd=1, @EnterToneInd=1, @LeavingToneInd=1, @QandAInd=1,
@PollingInd=1, @RollCallInd=1, @BroadcastInd=1, @DemandInd=0,
@ModeratorInd=1, @AutoPINInd=1, @DDI=?, @CPIN=?, @MPIN=?,
@RecordingPIN="555", @Information=?, @ReservationRef=?, @ConferenceRef=?,
@ActualDuration=?, @AvailableInd=?');

$sth->bind_param_inout(1, \$DDI, 32, DBI::SQL_VARCHAR);
$sth->bind_param_inout(2, \$CPIN, 12, DBI::SQL_VARCHAR);
$sth->bind_param_inout(3, \$MPIN, 12, DBI::SQL_VARCHAR);
$sth->bind_param_inout(4, \$Info, 255, DBI::SQL_VARCHAR);
$sth->bind_param_inout(5, \$ResRef, 10, DBI::SQL_INTEGER);
$sth->bind_param_inout(6, \$ConfRef, 10, DBI::SQL_INTEGER);
$sth->bind_param_inout(7, \$ActDuration, 10, DBI::SQL_INTEGER);
$sth->bind_param_inout(8, \$AvailInd, 1, DBI::SQL_BIT);
$sth->execute();
---------------------------

So, basically, the referenced variables do not get changed. Any thoughts?


-----Original Message-----
From: Chris McDaniel
Sent: January 5, 2003 11:59 PM
To: 'freetds AT lists.ibiblio.org'
Subject: RE: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS
(CVS), bind_param_ino ut



Thank you very much for your efforts! I have tried to check using my
scripts and isql, and I do not see any additional messages where I think
they should be, however, I am not the admin of the MS SQL server and I did
tell the group that takes care of it that I could not see the data from
print statements, so they may have changed the procedures without telling
me. Sorry I can't confirm...

Thanks again,

Chris McDaniel

-----Original Message-----
From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
Sent: January 5, 2003 6:42 AM
To: FreeTDS
Subject: RE: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS
(CVS), bind_param_ino ut


Il gio, 2003-01-02 alle 23:34, Chris McDaniel ha scritto:
> Hello,
>
> I've gotten around the print statements, they were only used in test
> procedures, and as I mentioned I get results back when the stored
procedures
> just call SELECTs. I am now trying to get returns from @params declared
> OUTPUT, with no luck... Can anyone point me in the right direction?
>

I rewrote ODBC error support. Now print should work.

If you want to rewrite with current CVS (or tomorrow snapshot)...

bye
freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page