Updating a filename's counter value failed each time
John Gordon
gordon at panix.com
Mon Jun 17 16:44:03 EDT 2013
In <MtKvt.47400$ja6.35986 at fx18.am4> Alister <alister.ware at ntlworld.com> writes:
> > #update file's counter if cookie does not exist cur.execute('''UPDATE
> > files SET hits = hits + 1, host = %s, lastvisit =
> > %s WHERE url = %s''', (host, lastvisit, filename) )
> >
> > if cur.rowcount:
> > print( " database has been affected" )
> >
> > indeed every time i select afilename the message gets printed bu then
> > again noticing the database via phpmyadmin the filename counter is
> > always remaining 0, and not added by +1
> replase
> if cur.rowcount:
> print( " database has been affected" )
> with print cur.rowcount()
rowcount isn't a method call; it's just an attribute. You don't need
the parentheses.
--
John Gordon A is for Amy, who fell down the stairs
gordon at panix.com B is for Basil, assaulted by bears
-- Edward Gorey, "The Gashlycrumb Tinies"
More information about the Python-list
mailing list