Re: MySQL set and enum, calling values

2009-12-12 Thread Carsten Haese
Victor Subervi wrote: > On Fri, Dec 11, 2009 at 8:13 PM, Gabriel Genellina > mailto:gagsl-...@yahoo.com.ar>> wrote: > Are you sure the column is declared as SET and not, say, VARCHAR? > > > yes Indeed it is, and knowing that, I can actually decode your original post. I apologize that I didn'

Re: MySQL set and enum, calling values

2009-12-12 Thread Victor Subervi
On Fri, Dec 11, 2009 at 8:13 PM, Gabriel Genellina wrote: > En Fri, 11 Dec 2009 16:28:23 -0300, Victor Subervi < > victorsube...@gmail.com> escribió: > > On Fri, Dec 11, 2009 at 3:12 PM, Carsten Haese > >wrote: >> >> Victor Subervi wrote: >>> > [...] if I go to print, say, >>> > colFieldValues[2

Re: MySQL set and enum, calling values

2009-12-11 Thread Gabriel Genellina
En Fri, 11 Dec 2009 16:28:23 -0300, Victor Subervi escribió: On Fri, Dec 11, 2009 at 3:12 PM, Carsten Haese wrote: Victor Subervi wrote: > [...] if I go to print, say, > colFieldValues[20], which is a set, it prints out the whole set: > set('Extra-small','Small','Medium','Large','XLarge

Re: MySQL set and enum, calling values

2009-12-11 Thread Victor Subervi
On Fri, Dec 11, 2009 at 3:12 PM, Carsten Haese wrote: > Victor Subervi wrote: > > [...] if I go to print, say, > > colFieldValues[20], which is a set, it prints out the whole set: > > set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge') > > But if I print out colFieldValues[20

Re: MySQL set and enum, calling values

2009-12-11 Thread Carsten Haese
Victor Subervi wrote: > [...] if I go to print, say, > colFieldValues[20], which is a set, it prints out the whole set: > set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge') > But if I print out colFieldValues[20][0], it prints out "s". The only reasonable explanation of this

MySQL set and enum, calling values

2009-12-11 Thread Victor Subervi
Hi; I have the following code: cursor.execute('describe %s;' % store) colFields, colFieldValues = [itm[0] for itm in cursor], [itm[1] for itm in cursor] ... for col in colFields: ... print '%s: %s\n' % (col, colValue[0]) Don't worry about the colValue[0]. In fact, the code throws no errors. H