Howdy, I'm having troubles with psqlite2 and the return types from a query. The problem is that my data which is numeric, is being returned as a string. I'm aware of the detect_types=sqlite.PARSE_DECLTYPES argument to the connect function.
Here's my connection code: self.connection = sqlite.connect(self.dbFile, detect_types=sqlite.PARSE_DECLTYPES)# self.connection.text_factory=str self.cursor = self.connection.cursor() Here's my sql (I'm returning risk1, which is numeric): create table risk( quantity varchar(8), color varchar(8), risk1 real, risk2 real, primary key (quantity, color) ); ( I have also tried [REAL, float, FLOAT], none work for me) Here's my query (this will probably be not much use out of context...): primaryKeys = self.primaryKeyFields[table] primaryKeyList= ' and '.join(['%s = ?'% pKey for pKey in primaryKeys]) query = 'select %s from %s where %s' % (field, table, primaryKeyList) paramList = [state[primaryKey] for primaryKey in primaryKeys] self.cursor.execute(query, paramList) Any ideas? TIA, Danny -- http://mail.python.org/mailman/listinfo/python-list