FreeTDS Development Group

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

Hi James,

>From the thread it looks very much like DBD:Sybase is using the
ct_dynamic() method in ct-library, which supports placeholders as you
say.
It seems to be segmenting on ct_send(CS_DESCRIBE_INPUT).

ct_dynamic() and friends are now implemented in the latest snapshot,
with one significant exception.
Unfortunately, this is the CS_DESCRIBE_INPUT parameter to ct_send(),
when using SQL server.

Sybase supports this functionality by a bespoke TDS message which
describes the number, type etc of your placeholders.
SQL Server has no means that I could discover of providing this
information to a client.

Bill

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Lowden, James K
Sent: 11 November 2005 14:47
To: FreeTDS Development Group
Subject: Re: [freetds] segfault in Perl's Email::Store when using
freetds


> From: Razvan Cosma
> Sent: Friday, November 11, 2005 5:18 AM
> 
>  If you'll be so kind as to check out this thread -
> http://perlmonks.org/?node_id=507375 - looks like the Perl gurus
> are not able to help with my problem, and also I shamefully admit
> I don't know what "The problem is that Email::Store tries to use
> placeholders when preparing the SQL query, and FreeTDS doesn't
> support that feature in it's implementation of Sybase's Client
> Library yet." means, my SQL knowledge being limited to select,
> insert and some updates :)

It's not an SQL question; it's an issue with the ct-lib implementation
in FreeTDS.  Placeholders allow the ct-lib programmer to issue a query
like "select * from systypes where name = '?' ", where the '?' is
replaced by a user-provided string before the query is sent to the
server.  It is basically what Microsoft calls "dynamic SQL".  

FreeTDS has been on the cusp of supporting placeholders for more than a
year.  I think the problem  is that no one wants to scratch the itch
because what placeholders offer can be done other ways.  

Placeholders have gotten more attention in the FreeTDS ODBC driver.  You
might want to give that a whirl.  If you do, use the latest snapshot.  

HTH.  

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential 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.  If you, as the
intended recipient
of this message, the purpose of which is to inform and update our
clients, prospects
and consultants of developments relating to our services and products,
would not
like to receive further e-mail correspondence from the sender, please
"reply" to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the
Americas, New York,
NY 10105.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------