[python-sybase] problems with executing dynamically created queries.

[Erik Thiele]

On Fri, 23 Jul 2004 11:46:10 -0700
"Jeff Younker" <jyounker@ofoto.com> wrote:

> Erik Thiele writes:
> 
> hmmmm. still i have no working example.
> 
> there is this python-sybase module and i cannot get it to work. there
> must be something wrong here. Could you give me a query that runs on the
> above configuration? i want to create the query dynamically. i.e. no
> static query, but instead some query like the one above.
> 
> is the python-sybase module broken?
> 
> --
> 
> Ok, to try to help here:   What database libraries are
> you linking against? The three possibilities that I can
> think of are: Sybase,  ODBC of some sort, and FreeTDS.
> 
> I know that there are problems with FreeTDS and parameter
> substitution.  I'm not sure whether the problems are with
> the Sybase module or FreeTDS itself.
> 
> The module works great against the client sybase
> libraries.
> 
> -jeff

FreeTDS 0.62.3
Sybase 0.36
Python 2.3.3
Gentoo Linux. everything is kept up-to-date.
MS-SQL Server 7.0 on Windows NT 4.0

i am looking for a working example of a query with parameter substitution.

erik


-- 
Erik Thiele