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

Erik Thiele erik at thiele-hydraulik.de
Fri, 23 Jul 2004 08:56:58 +0200


On Fri, 23 Jul 2004 14:19:32 +1000
Dave Cole <djc@object-craft.com.au> wrote:

> Erik Thiele wrote:
>=20
> > and... why is there several styles in DB API 2.0? i mean the
> > Sybase.paramstyle thing. i thought DB API was there for portability,
> > and then i find out that different modules have different ways to
> > create sql queries. so there is absolute zero portability. why?
>=20
> You will have to ask the database vendors that one.

ah! so it's a problem with the database? i thought that this parameter
substitution thing was an issue of the DB API and every python database
driver programmer just decides which one to use. so that's not true!
actually there should be a wrapper function on top of DB API that can
transform one single paramstyle into all the others. or is there a
technical reason why that's not possible? anyway once you maybe answer
this question i will make a suggestion to python DB guys to add this to
the FAQ. i tried to figure out why this is so for just too long time.
also that FAQ entry must point out why there is no wrapper, or where it
is :)

thx!
erik


--=20
Erik Thiele
Horst Thiele Maschinenbau-Hydraulische Ger=E4te GmbH
Im Kampfrad 2 - 74196 Neuenstadt
Tel.: 07139/4801-19
Fax.: 07139/4801-29
email: erik@thiele-hydraulik.de
Internet: http://www.thiele-hydraulik.de/