<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff size=2>Thanks
for your quick response Matt!</FONT></SPAN></DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff size=2>I
already have dco2.c version 1.137.</FONT></SPAN></DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff size=2>What
flag do I have to change to return a NULL instead of a None singleton? I
changed ZEROLENISNULL to 1 as you suggested but it does not help... The more I
think about this the more I think the problem is not in dco2 but in Zope?? When
I do a <dtml-var> of the result, I get literally "None" in my application.
Could it be that Zope interprets the None singleton as a "None"?? This only
occurs for columns of type varchar2...</FONT></SPAN></DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff size=2>One
detail: there is a missing bracket ({) in source code:</FONT></SPAN></DIV>
<DIV><SPAN class=094481614-30042004></SPAN> </DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff size=2>#if
ZEROLENISNULL<BR> if (len ==
0)<BR> {<BR> Py_INCREF(Py_None);<BR> TRACE(T_EXIT,("sAs",
"ResultSetItem_value", Py_None,<BR> "0
Len"));<BR> return
Py_None;<BR> }<BR>#endif</FONT> </SPAN></DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff
size=2>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=094481614-30042004><FONT face=Arial color=#0000ff
size=2>Remy</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Matthew T.
Kromer [mailto:matt@bane.mi.org] <BR><B>Sent:</B> April 30, 2004 7:37
AM<BR><B>To:</B> remy_pinsonnault@roche.ca<BR><B>Cc:</B>
zope-db@zope.org<BR><B>Subject:</B> Re: [Zope-DB] Return a Null string instead
of a "None" string, DCOracle2<BR><BR></FONT></DIV>DCOracle2 never returns
"None" as a string -- it will return the None singleton. There's a compile
time flag in the source that controls the behavior of if a zero-length result
is returned as None or not. The default is for this to be OFF, but this is
something that is only in the CVS source -- the 1.3 release doesn't have that
change in it.<BR><BR><BR>On Apr 29, 2004, at 3:59 PM, Remy Pinsonnault
wrote:<BR><BR>
<BLOCKQUOTE><?fontfamily><?param Arial><?smaller>Hi,<?/smaller><?/fontfamily><BR> <BR><?fontfamily><?param Arial><?smaller>I'm
running the last DCOracle2 version under Windows XP, Oracle 9i and Python
2.3.<?/smaller><?/fontfamily><BR> <BR><?fontfamily><?param Arial><?smaller>Right
now the product returns a string containing "None" when the result is a
zero-length varchar2 (NULL). How can I change this behaviour?<?/smaller><?/fontfamily><BR> <BR><?fontfamily><?param Arial><?smaller>Can
i change something in the source code to get a Null value? At least if
I could modify the "None" string to something else it would be better
because the application is in spanish and None doesn't look good...<?/smaller><?/fontfamily><BR> <BR><?fontfamily><?param Arial><?smaller>Thanks
in advance<?/smaller><?/fontfamily><BR> <BR><?fontfamily><?param Arial><?smaller>Remy
Pinsonnault<?/smaller><?/fontfamily><BR><?fontfamily><?param Arial><?smaller>Information
Technology Specialist<?/smaller><?/fontfamily><BR><?fontfamily><?param Arial><?color><?param 0000,0000,EEEE><?smaller>PERCAN
PROJECT<?/smaller><?/color><?/fontfamily><BR><?fontfamily><?param Arial><?color><?param 0000,0000,EEEE><?smaller>ROCHE
LIMITED, CONSULTING
GROUP<?/smaller><?/color><?/fontfamily><BR>_______________________________________________<BR>Zope-DB
mailing
list<BR>Zope-DB@zope.org<BR>http://mail.zope.org/mailman/listinfo/zope-db<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>