Skip to Content.
Sympa Menu

freetds - RE: [freetds] big commit: language command variable support added

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] big commit: language command variable support added
  • Date: Fri, 7 Mar 2003 15:15:51 -0000

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 >>




Archive powered by MHonArc 2.6.24.

Top of Page