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

[Chris D. <cdu...@ya...>]

Marcos,

Great idea (nvl as opposed to isnull). However cx_Oracle still returns None e.g.

cur1.execute("select nvl(subobject_name,'') from objects_big where rownum < 5")
data = cur1.fetchall()
print data
[(None,), (None,), (None,), (None,), (None,)]

I thought you'd "fixed it". Thanks for the idea anyway.

Chris

--- Marcos Sánchez Provencio <ma...@bu...> wrote:

> you may try to do it at oracle level
> 
> select isnull(col,'')...
> 
> it should be faster
> 
> El mié, 11-05-2005 a las 07:15 -0700, Chris Dunscombe escribió:
> > All,
> > 
> > Is there anyway that Null values returned from a query can be an "empty or zero length string"
> > instead of None?
> > 
> > This may seem a strange request as it's easy to use type to test if a null has been returned
> as
> > None. However I've a performance critical app where I need to output "nothing" (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 is quite an overhead
> when in
> > some cases I need to do it millions and sometimes billions of times.
> > 
> > Thanks,
> > 
> > Chris Dunscombe
> > 
> > 
> > 		
> > __________________________________ 
> > Do you Yahoo!? 
> > Read only the mail you want - Yahoo! Mail SpamGuard. 
> > http://promotions.yahoo.com/new_mail 
> > 
> > 
> > -------------------------------------------------------
> > 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=7393&alloc_id=16281&op=click
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
> 
> 
> -------------------------------------------------------
> 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_ids93&alloc_id281&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 



		
Discover Yahoo! 
Stay in touch with email, IM, photo sharing and more. Check it out! 
http://discover.yahoo.com/stayintouch.html