Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 26 Jan 2017 13:23:56 -0500 (EST)
From:      DTD <doug@safeport.com>
To:        python@FreeBSD.org
Subject:   MySQLdb question
Message-ID:  <alpine.BSF.2.00.1701261321410.15335@bucksport.safeport.com>

next in thread | raw e-mail | index | archive | help
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)

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
doug@safeport.com
Voice: 301-217-9220
   Fax: 301-217-9277



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?alpine.BSF.2.00.1701261321410.15335>