Updating a filename's counter value failed each time

[MRAB]

On 17/06/2013 21:44, John Gordon wrote:
> 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.
>
Well, you do need parentheses, it's just that you need them around the
'print':

if cur.rowcount:
     print(cur.rowcount)