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

2013-07-02 Thread Ahmad Faiyaz
est. > name).first() > > You probably forgot to revert after debugging, but above you have > hard-coded and id of 13 into the query. > > Anthony > > On Monday, July 1, 2013 10:55:17 PM UTC-4, Ahmad Faiyaz wrote: > >> here is the database definition: >> >> db.

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

2013-07-01 Thread Ahmad Faiyaz
t shows *no* then what to do then ? You can download the whole w2p file from here: https://dl.dropboxusercontent.com/u/34972503/web2py.app.SAI_BETA.w2p username: administrator pass: admin1234 then go to contest/configure to check !! use start , stop button to update the status. On Tue, Jul 2, 20

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 Ahmad Faiyaz
od 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 == id ).update(running = value) > > which only results in one sql statement. > > Alex >

[web2py] Database row update problem !

2013-07-01 Thread Ahmad Faiyaz
Hello, i am trying to update a row on a db table, but it is not updating, what is the problem ? my db table 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_f

[web2py] How to force Auth module to disable Password encryption!

2013-05-23 Thread Ahmad Faiyaz
Hello, I am new on web2py. I am using it to develop a Programming Contest Management system. Now on a ONSITE Programming Contest , we have to distribute username and password printed on paper. So i have implemented a function which will generate user accounts automatically then print the passwo