[Zope-DB] Re: DCOracle2 TIMESTAMP DataType Issue

2007-03-22 Thread Matthew T. Kromer
The type table just registers the known Oracle data types and whether or not there are type converters registered, TYPEENTRY has no converter, TYPOENTRY has a registered output converter, CTYPOENTRY has a coercion output converter, where oracle is asked to return the result as a different

[Zope-DB] RE: DCOracle2 TIMESTAMP DataType Issue - Resolved :-)

2007-03-22 Thread Maan M. Hamze
Matt - IT WORKED :-D I tried it with both, SQLT_DAT, and SQLT_STR: I started by adding: a. CONVERTOUTF(SQLT_TIMESTAMP); //Add to list of CONVERTOUTF at the top of file Then: I: With SQLT_DAT I replaced TYPEENTRY(SQLT_TIMESTAMP) in TypeTable[] with a. CONVERTOUTF(SQLT_TIMESTAMP, SQLT_DAT,7) //

[Zope-DB] RE: DCOracle2 TIMESTAMP DataType Issue

2007-03-21 Thread Maan M. Hamze
This is the error I am getting with DCOracle2 on Win XP with a TIMESTAMP field fetched in a record set. r = c1.fetchone() Traceback (most recent call last): File stdin, line 1, in ? File C:\Python\lib\site-packages\DCOracle2\DCOracle2.py, line 1182, in fetch one v =