Re: [PD] accessing mysql database

2007-04-12 Thread Frank Barknecht
Hallo, Luigi Rensinghoff hat gesagt: // Luigi Rensinghoff wrote: Yes i can acces the database from python, entering some lines of python: db = MySQLdb.connect(localhost, root, gigiroot, sfx_database) sql = SELECT * FROM soundfile where description like '%birds% cursor.execute(sql) data =

Re: [PD] accessing mysql database

2007-04-08 Thread David Powers
Hi Luigi, Just to be clear: Can you connect to the database with just Python? If not, I will try to help later today. This gives me a good excuse to try such a thing, I've been doing PHP+MySQL typical web programming lately, but Python is (in my opinion) a far nicer language than PHP and I've

Re: [PD] accessing mysql database

2007-04-08 Thread Luigi Rensinghoff
Yes i can acces the database from python, entering some lines of python: db = MySQLdb.connect(localhost, root, gigiroot, sfx_database) sql = SELECT * FROM soundfile where description like '%birds% cursor.execute(sql) data = cursor.fetchall() print data. but from PD it does not work Am

Re: [PD] accessing mysql database

2007-04-08 Thread David Powers
Ahhh I guess I can't be of any help then, I haven't used Python inside PD too much ... But I'd love to hear the outcome of this. ~David On 4/8/07, Luigi Rensinghoff [EMAIL PROTECTED] wrote: Yes i can acces the database from python, entering some lines of python: db =

Re: [PD] accessing mysql database

2007-04-08 Thread Thomas Grill
Hi Luigi, Yes i can acces the database from python, entering some lines of python: db = MySQLdb.connect(localhost, root, gigiroot, sfx_database) sql = SELECT * FROM soundfile where description like '%birds% cursor.execute(sql) data = cursor.fetchall() print data. but from PD it does