DTD(d...@safeport.com)@2017.01.26 13:23:56 -0500: > I am using py27-MySQLdb-1.2.5 (the default) for FreeBSD 10.3 > > cmd="update ipv4 set s8='%s',s16='%s',s24='%s' where ip='%s'" % > (s8,s16,s24,row[0]) > c.execute(cmd)
When you say that it isn't working, I assume you mean it's not updating any rows? To see if that's the case, you can assign the return from execute and print the result, and print it out. numrows = c.execute(cmd) print numrows Or use the rowcount attr of the cursor print c.rowcount If it's showing 0 rows, try running select where select * where ip='1.186.248.251 Is it possible you're connecting to a different host/db than you're using for your manual SQL? -karl > > does not work. I actually used try/except. It does not throw an error > > cmd=update ipv4 set s8='1.',s16='1.186.',s24='1.186.248.' where > ip='1.186.248.251' > > is a valid statement and works. It just does not work through > execute. I also tried appending a ';' to cmd > > Thanks for any help/thoughts > > _____ > Douglas Denault > http://www.safeport.com > d...@safeport.com > Voice: 301-217-9220 > Fax: 301-217-9277 > _______________________________________________ > freebsd-python@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-python > To unsubscribe, send any mail to "freebsd-python-unsubscr...@freebsd.org" _______________________________________________ freebsd-python@freebsd.org mailing list https://lists.freebsd.org/mailman/listinfo/freebsd-python To unsubscribe, send any mail to "freebsd-python-unsubscr...@freebsd.org"
