Re: [cx-oracle-users] Nulls returned as None and not as as "empty or zero lenght string"

[Marcos P. <ma...@bu...>]

you may try to do it at oracle level

select isnull(col,'')...

it should be faster

El mi=C3=A9, 11-05-2005 a las 07:15 -0700, Chris Dunscombe escribi=C3=B3:
> All,
>=20
> Is there anyway that Null values returned from a query can be an "empty=
 or zero length string"
> instead of None?
>=20
> This may seem a strange request as it's easy to use type to test if a n=
ull has been returned as
> None. However I've a performance critical app where I need to output "n=
othing" (zero length /
> empty string) if the value is null. Hence at present I have to perform =
this "type test" on ALL
> columns that don't have a "Not Null" constraint in the database which i=
s quite an overhead when in
> some cases I need to do it millions and sometimes billions of times.
>=20
> Thanks,
>=20
> Chris Dunscombe
>=20
>=20
> 	=09
> __________________________________=20
> Do you Yahoo!?=20
> Read only the mail you want - Yahoo! Mail SpamGuard.=20
> http://promotions.yahoo.com/new_mail=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7393&alloc_id=3D16281&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users