Testing for exc_traceback? The weirdest thing I've ever seen...

jwsacksteder at ramprecision.com jwsacksteder at ramprecision.com
Mon Jun 16 23:01:26 CEST 2003

I have a data extraction script that is pulling data out of an ODBC
datasource on Win32 using the standard DBI 1.0 ODBC code. When I iterate
over each row and column in turn, I am seeing strange behaviour on some date
fields. This is certainly due the abysmal odbc driver provided by my vendor.
My sad story is that I need to work around these bad records.

If I try the following statement-

	print type(my_row[3]) 
I get- 
	<type 'DbiDate'>

Which is expected.

If I try to
	print str(my_row[3]) 
I get-

My workaround would be to check for this condition and return null if this
happens, which I am trying to do like this-

for column_seq in row:
	if str(column_name) == "exc_traceback":
		dest_column = 'null'
		dest_column = column_seq		

It doesn't work as I would expect it to, so obvoiusly I'm thinking about it
wrong. What is the correct way to test for these values?

More information about the Python-list mailing list