Re: [sqlite] Update not completely commit(ing)

2010-12-24 Thread Drake Wilson
Quoth Joe Bennett , on 2010-12-24 18:28:18 -0600: > Have a question regarding a particular issue I am dealing with... I > have a database in which I create a pivot table to get a no dupe list > using a 'select distinct'. I then take that list into Python and then > iterate over it to look up data i

Re: [sqlite] Update not completely commit(ing)

2010-12-24 Thread Simon Slavin
On 25 Dec 2010, at 12:28am, Joe Bennett wrote: > update_data = 'update matrix set %s = %f, %s = %f where %s = "%s"' % > (A_B + '_Lat', Lat_Site, A_B + '_Lon',Lon_Site, A_B, Site[0]) You've used double quotes. I'm guessing that the value is a string, in which case you mean single quotes. But t