Re: Can't get LCHARVAR's with InformixDB

2006-08-05 Thread fhurley
Carsten Haese wrote: > I'd suggest upgrading to the newest version of CSDK. Please let me know > what happens after the upgrade. That did the trick thanks very much. -- http://mail.python.org/mailman/listinfo/python-list

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread Carsten Haese
On Tue, 2006-08-01 at 14:05, [EMAIL PROTECTED] wrote: > Carsten Haese wrote: > > Once again, I'll need > > the create table statement for the table you're selecting from in order > > to investigate what's happening. > > Here it is: > > CREATE TABLE DEV_LOG( > LOG_ID SERIAL, > LEVEL VARCHAR (10)

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread fhurley
Carsten Haese wrote: > Once again, I'll need > the create table statement for the table you're selecting from in order > to investigate what's happening. Here it is: CREATE TABLE DEV_LOG( LOG_ID SERIAL, LEVEL VARCHAR (10), POI_NM VARCHAR (255), MSG_TX LVARCHAR(2000), MSG2_TX LVARCHAR(5000)

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread Carsten Haese
On Tue, 2006-08-01 at 11:47, [EMAIL PROTECTED] wrote: > Another thing... > > > Output is: > > description is <('msg_tx', 'lvarchar', 0, 0, None, None, 1)> > > The 0's worried me, as I could see where they could be used as parms to > allocate/trim things as necessary... just a thought. That is i

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread Carsten Haese
On Tue, 2006-08-01 at 11:41, [EMAIL PROTECTED] wrote: > Carsten Haese wrote: > > Could you possibly send me a minimal test script that shows the problem? > > Also, in case it matters, I'd like to know which versions of IDS and > > CSDK or Informix Connect you're using. > > > Here's a sample scrip

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread fhurley
Another thing... > Output is: > description is <('msg_tx', 'lvarchar', 0, 0, None, None, 1)> The 0's worried me, as I could see where they could be used as parms to allocate/trim things as necessary... just a thought. -- http://mail.python.org/mailman/listinfo/python-list

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread fhurley
Carsten Haese wrote: > Could you possibly send me a minimal test script that shows the problem? > Also, in case it matters, I'd like to know which versions of IDS and > CSDK or Informix Connect you're using. Here's a sample script: sql = '''select msg_tx from dev_log''' import informixdb conn =

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread Carsten Haese
On Tue, 2006-08-01 at 09:27, [EMAIL PROTECTED] wrote: > Carsten Haese wrote: > > What version are you using? I thought I fixed lvarchars a long time ago. > > 2.2, with Python 2.4 on Windows... I installed via > InformixDB-2.2.win32-py2.4.exe Hm, this certainly warrants further investigation. I do

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread fhurley
Carsten Haese wrote: > What version are you using? I thought I fixed lvarchars a long time ago. 2.2, with Python 2.4 on Windows... I installed via InformixDB-2.2.win32-py2.4.exe I can see the data with other tools... it's multi-line, stuff like stack traces, etc., and many start with newlines...

Re: Can't get LCHARVAR's with InformixDB

2006-08-01 Thread Carsten Haese
On Tue, 2006-08-01 at 09:02, [EMAIL PROTECTED] wrote: > I'm using the InformixDB package, which has been a real lifesaver, but > I'm finding I can't get any data from the Informix LCHARVAR types. > They're coming in as empty strings. > > The cursor._description for the field in question is: > ('ms

Can't get LCHARVAR's with InformixDB

2006-08-01 Thread fhurley
I'm using the InformixDB package, which has been a real lifesaver, but I'm finding I can't get any data from the Informix LCHARVAR types. They're coming in as empty strings. The cursor._description for the field in question is: ('msg_text', 'lvarchar', 0, 0, None, None, 1) Appreciate any help...