[web2py] Regarding update count

[Nam Soo In]

I am trying to update count depend on url exists in the DB
urlcount is integer type in database
It keeps giving me an error.

Here is my code
def storeMd5InDb(md5_url_list):
           import datetime
         
           for single_md5_url in md5_url_list:
               check_count=0
              
 
check_count=db(db.phalanx_request.url==single_md5_url[1]).select(db.phalanx_request.urlcount)
               if (check_count> 1):
                  check_count=check_count+1
                  
db(db.phalanx_request.url==single_md5_url[1]).update(count=check_count) 
               else:                                   
                  
 
db.phalanx_request.insert(md5=single_md5_url[0],url=single_md5_url[1],request_date=datetime.datetime.now(),status=False,urlcount=1)
                   db.commit() 

Any thought?

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.