Re: [Tutor] MySQLdb field type

2009-08-11 Thread Kent Johnson
On Tue, Aug 11, 2009 at 11:10 AM, Rick Pasotto wrote: > I didn't realize there were different MySQLdb modules. I didn't realize you had specified MySQLdb...sorry, I'm not being very helpful. I don't know where to find that information for MySQLdb. Kent ___

Re: [Tutor] MySQLdb field type

2009-08-11 Thread Rick Pasotto
On Mon, Aug 10, 2009 at 07:22:03PM -0400, Kent Johnson wrote: > On Mon, Aug 10, 2009 at 3:52 PM, Rick Pasotto wrote: > > Not exactly what I'm looking for. > > > > The type_code in the tuple is a number. For one of my tables I see the > > following numbers: 1, 2, 10, 252, 253, 254. What I wanted was

Re: [Tutor] MySQLdb field type

2009-08-10 Thread Kent Johnson
On Mon, Aug 10, 2009 at 3:52 PM, Rick Pasotto wrote: > Not exactly what I'm looking for. > > The type_code in the tuple is a number. For one of my tables I see the > following numbers: 1, 2, 10, 252, 253, 254. What I wanted was a listing > telling me which number was which type_code. Ah, right. I

Re: [Tutor] MySQLdb field type

2009-08-10 Thread Rick Pasotto
On Mon, Aug 10, 2009 at 02:50:01PM -0400, Kent Johnson wrote: > On Mon, Aug 10, 2009 at 1:08 PM, Rick Pasotto wrote: > > After executing a query that returns values, cursor.description contains > > a list of tuples, one tuple for each field. Each tuple has seven values > > consisting of > > (name,

Re: [Tutor] MySQLdb field type

2009-08-10 Thread Kent Johnson
On Mon, Aug 10, 2009 at 1:08 PM, Rick Pasotto wrote: > After executing a query that returns values, cursor.description contains > a list of tuples, one tuple for each field. Each tuple has seven values > consisting of > (name,type_code,display_size,internal_size,precision,scale,null_ok). > > Where

[Tutor] MySQLdb field type

2009-08-10 Thread Rick Pasotto
After executing a query that returns values, cursor.description contains a list of tuples, one tuple for each field. Each tuple has seven values consisting of (name,type_code,display_size,internal_size,precision,scale,null_ok). Where can I find a listing of what the various type_codes are? Do I n