Hmm - looks like I dropped some inverted commas
On 24/08/12 20:10, Donal McMullan wrote:
import MySQLdb as mdb
con=mdb.connect('172.16.48.9', 'showtime', 's1000@ma25db', '
artists_core')
c = con.cursor(mdb.cursors.DictCursor)
c.execute("""SELECT Artist_Name, Artist_ID, Login_ID FROM
artists_core.employee limit 1,10""")
rows = c.fetchall()
for row in rows:
print "%s %s" % (row["Artist_Name"], row["Artist_ID"])
--
Donal McMullan
Production Engineer
--
view archives: http://groups.google.com/group/python_inside_maya
change your subscription settings:
http://groups.google.com/group/python_inside_maya/subscribe
