Skip to Content.
Sympa Menu

freetds - Re: Prepared statements w/ the tds protocol

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "G." Sumner Hayes <SumnerH AT fool.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Cc: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Prepared statements w/ the tds protocol
  • Date: 14 Mar 2001 17:42:27 -0500


On 14 Mar 2001 17:11:55 -0500, G. Sumner Hayes wrote:
> So I'm guessing that doing this UTF16 encoding of the query isn't the
> right way to go.

Yeah, that was pretty boneheaded.
N'...' works beautifully:

"exec sp_executesql N'select * from car where car_id=@p', @params=N'@p
int', @p=10000000"

runs just fine.

>
> Has anyone gotten any sort of prepared or sp_executesql statements to
> work with MS-SQL 7.0 or 2000? Can you point me in the right direction
> at the TDS level?
>
> Sumner
>
>
> ---
> You are currently subscribed to freetds as: [SumnerH AT fool.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page