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: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • 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:25:05 +0100

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

=================================




Archive powered by MHonArc 2.6.24.

Top of Page