Re: [Tutor] Trying to use MySQLdb.cursor

2005-03-25 Thread Vicki Stanfield
>> below to print the data returned from my query, but I would like to > make >> labels at the top of the columns. How do I do this dynamically? > > You shouldn't, it makes your code very vulnarable to changes in the > database! > Its the same principle as using 'select * from...', a bad idea in >

Re: [Tutor] Trying to use MySQLdb.cursor

2005-03-25 Thread Alan Gauld
> below to print the data returned from my query, but I would like to make > labels at the top of the columns. How do I do this dynamically? You shouldn't, it makes your code very vulnarable to changes in the database! Its the same principle as using 'select * from...', a bad idea in production co

Re: [Tutor] Trying to use MySQLdb.cursor

2005-03-25 Thread Liam Clarke
mySQL also has it's own metadata commands - http://dev.mysql.com/doc/mysql/en/getting-information.html Looks like you want to use the DESCRIBE command. On Fri, 25 Mar 2005 06:25:52 -0500, Kent Johnson <[EMAIL PROTECTED]> wrote: > Vicki Stanfield wrote: > > I finally gave up and used MySQLdb

Re: [Tutor] Trying to use MySQLdb.cursor

2005-03-25 Thread Kent Johnson
Vicki Stanfield wrote: I finally gave up and used MySQLdb to connect to my database. It connects okay, and returns data, but now I have a new question. I use the code below to print the data returned from my query, but I would like to make labels at the top of the columns. How do I do this dynamica

Re: [Tutor] Trying to use MySQLdb.cursor

2005-03-24 Thread Danny Yoo
On Fri, 25 Mar 2005, Vicki Stanfield wrote: > I finally gave up and used MySQLdb to connect to my database. It > connects okay, and returns data, but now I have a new question. I use > the code below to print the data returned from my query, but I would > like to make labels at the top of the co