FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

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