FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Freddy

Just realised you've figured this out already....

Bill

> -----Original Message-----
> From: Thompson, Bill D (London) [SMTP:ThompBil AT exchange.uk.ml.com]
> Sent: 07 March 2003 15:09
> To:   'FreeTDS Development Group'
> Subject:      RE: [freetds] big commit: language command variable support
> added
> 
> Freddy,
> 
> I think I've figured out (almost) sp_prepare, sp_unprepare and sp_execute
> from the first link that you provided.
> 
> Try this in query analyzer:
> 
>  <<preptest.txt>> 
> I think we ought to able to combine this knowledge with the TDS 7 RPC
> protocol to give us a solution...
> 
> Bill
> 
> 
> 
> > -----Original Message-----
> > From:       ZIGLIO Frediano [SMTP:Frediano.Ziglio AT vodafoneomnitel.it]
> > Sent:       07 March 2003 14:25
> > To: 'FreeTDS Development Group'
> > Subject:    RE: [freetds] big commit: language command variable support
> > added
> > 
> > > 
> > > At 7:59 AM +0100 3/7/2003, Frediano Ziglio wrote:
> > > >Why BITN are treated like numeric? Does ct_convert ignore destination
> > > >length for fixed types?
> > > 
> > > Yes. Pretty much every ctlib function is suppose to ignore 
> > > destination lengths for fixed types.
> > > 
> > 
> > Yes, I didn't read early your ct_bind mail...
> > 
> > > >Also, to support the same on TDS7/8: use mix prepare and execute code
> > > >and call sp_prepexec RPC (it do something like sp_prepare, 
> > > sp_execute,
> > > >sp_unprepare), see code in query.c.
> > > 
> > > The links you sent on sp_executesql seem like the best solution. I 
> > > was looking at changing the sql to include declare and sets for each 
> > > variable, but that is a much better solution. More of a pain than 
> > > what Sybase offers, but it should be workable.
> > > 
> > 
> > I started coding (in CVS)
> > I don't know if my implementation is correct...
> > For example this call should work?
> > 
> > query: "SELECT * FROM xxx WHERE name = @myname"
> > param[0]: name:"@myname" data:"test"
> > 
> > Perhaps I supposed query like:
> > 
> > query: "SELECT * FROM xxx WHERE name = ?"
> > param[0]: no-name data:"test"
> > 
> > Have I mixed params and placeholder code?
> > 
> > freddy77
> > 
> > =================================
> > "STRICTLY PERSONAL AND CONFIDENTIAL
> > 
> > This message may contain confidential and proprietary material for the
> > sole
> > use of the intended recipient. Any review or distribution by others is
> > strictly prohibited. If you are not the intended recipient please
> contact
> > the sender and delete all copies.
> > The contents of this message that do not relate to the official business
> > of
> > our company shall be understood as neither given nor endorsed by it."
> > 
> > =================================
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds << File: preptest.txt
> >>  << File: ATT1935580.txt >>