FreeTDS Development Group

["Darren Smith" <data AT barrysworld.com>]

Hi

I just noticed my version of ct.c has:

CS_RETCODE ct_param(CS_COMMAND *cmd, CS_DATAFMT *datafmt, CS_VOID *data,
CS_INT datalen, CS_SMALLINT indicator)
{
TDSSOCKET *tds;
TDSDYNAMIC *dyn;
TDSINPUTPARAM *param;
int elem;
    tdsdump_log(TDS_DBG_FUNC, "%L inside ct_param()\n");
    tdsdump_log(TDS_DBG_INFO1, "%L ct_param() data addr = %d data length =
%d\n", data, datalen);
    tds = cmd->con->tds_socket;
    elem = tds_lookup_dynamic(tds, cmd->dyn_id);
    dyn = tds->dyns[elem];
    param = tds_add_input_param(dyn);
    param->column_type = _ct_get_server_type(datafmt->datatype);
    param->varaddr = data;
    if (datalen==CS_NULLTERM) {
        param->column_bindlen = 0;
    } else {
        param->column_bindlen = datalen;
    }
    param->is_null = indicator;
    return CS_SUCCEED;
}

I'm using freetds-0.60.

Does this mean it should work?

Regards

Darren.

----- Original Message -----
From: "Lowden, James K" <LowdenJK AT bernstein.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Wednesday, November 13, 2002 6:56 PM
Subject: [freetds] Re: Stored Procedures & MSSQL & CTLIB


> > From: Darren Smith [mailto:data AT barrysworld.com]
> > Sent: November 13, 2002 1:33 PM
> >
> > Are Stored Procedures working in CTLIB? Or have I got
> > completely the wrong
> > end of the stick on using ct_param?
>
> Darren,
>
> Stored procedures, yes.  Output parameters for stored procedures, no, not
in
> ct-lib.  :(
>
> See src/ctlib/ct.c:
>
> CS_RETCODE ct_param(CS_COMMAND *cmd, CS_DATAFMT *datafmt, CS_VOID *data,
> CS_INT
> datalen, CS_SMALLINT indicator)
> {
> TDSSOCKET *tds;
> /* TDSDYNAMIC *dyn; */
> /* TDSINPUTPARAM *param; */
> int elem;
>
>         tdsdump_log(TDS_DBG_FUNC, "%L inside ct_param()\n");
>         tdsdump_log(TDS_DBG_INFO1, "%L ct_param() data addr = %d data
length
> = %
> d\n", data, datalen);
>
>         tds = cmd->con->tds_socket;
>
>         elem = tds_lookup_dynamic(tds, cmd->dyn_id);
>
>         /* TODO */
>         return CS_FAIL;
>
> Also see doc/api_status.txt.
>
> HTH.
>
> --jkl
>
>
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or
agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication
is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
>
>
>
> ---
> You are currently subscribed to freetds as: [data AT barrysworld.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>