[web2py] Re: Database row update problem !

2013-07-01 Thread Alex
from the documentation: update_record should not be confused with >>> row.update(name='Curt') because for a single row, the method update updates the row object but not the database record, as in the case of update_record so you should use update_record instead. or even better: db(db.contest.id =

Re: [web2py] Re: Database row update problem !

2013-07-01 Thread Ahmad Faiyaz
thanks, but it sometimes work, sometimes doesn't !! what can be the problem ! On Tue, Jul 2, 2013 at 5:34 AM, Alex wrote: > from the documentation: > update_record should not be confused with > >>> row.update(name='Curt') > because for a single row, the method update updates the row object but n

Re: [web2py] Re: Database row update problem !

2013-07-01 Thread Ahmad Faiyaz
weird things happening, when i check the db table with appadmin, it shows for contest.running = yes [ updated the value with sqlform.grid ] , but when i fetch the row with DAL on app, it shows contest.running = no [ which is the default ] why ? On Tue, Jul 2, 2013 at 6:18 AM, Ahmad Faiyaz wrote:

Re: [web2py] Re: Database row update problem !

2013-07-01 Thread Anthony
Can you show the code you are now using and describe the workflow of how the record gets updated and how you are then attempting to view the updated record? Anthony On Monday, July 1, 2013 8:37:32 PM UTC-4, Ahmad Faiyaz wrote: > weird things happening, when i check the db table with appadmin,

Re: [web2py] Re: Database row update problem !

2013-07-01 Thread Ahmad Faiyaz
here is the database definition: db.define_table('contest', Field('name', length=128 ), Field('contest_host', length=128,), Field('duration', 'time' ), Field('time_passed','time', default = 0), Field('rank_frozen','time', default = 0), Field('running',length= 10, readable=False, default = "no"), F

Re: [web2py] Re: Database row update problem !

2013-07-01 Thread Anthony
You left out some critical code from the original question -- your Javascript sends each post request twice: function send_data(id){ $.post("{{=URL('contest','flip_contest_status')}}", {id: id} ); $.post("{{=URL('contest','flip_contest_status')}}", {id: id} ) .done

Re: [web2py] Re: Database row update problem !

2013-07-02 Thread Ahmad Faiyaz
wow!! many many thanks.. :) On Tue, Jul 2, 2013 at 10:15 AM, Anthony wrote: > You left out some critical code from the original question -- your > Javascript sends each post request twice: > > function send_data(id){ > $.post("{{=URL('contest','flip_contest_status')}}", {id: id} ); >