[web2py] Re: DAL Query string for MariaDB

2017-01-23 Thread Jorrit
Did you try it to see what happens? On Friday, January 20, 2017 at 11:43:40 PM UTC+1, SR wrote: > > What will be DAL Query string in db.py for MariaDB database in my Centos 7 > machine? > Is this right? > db = DAL('mysql://root:password@localhost/db_name’) > -- Resources: - http://web2py.com -

[web2py] Re: Validating field with IS_EXPR

2017-01-19 Thread Jorrit
-- and it's not documented). > > Anthony > > On Wednesday, January 18, 2017 at 12:13:36 PM UTC-5, Jorrit wrote: >> >> I have this model, where I want to validate that the end_timeslot is not >> below the start_timeslot: >> >> db.define_table

[web2py] Validating field with IS_EXPR

2017-01-18 Thread Jorrit
I have this model, where I want to validate that the end_timeslot is not below the start_timeslot: db.define_table('staffingexception', Field('employee_id', 'reference auth_user'), Field('from_date', 'date', required=True), Field('to_date', 'date',

[web2py] Re: Are executesql parameters escaped?

2017-01-13 Thread Jorrit
auth_user where id = ?', placeholders=(1, ), > as_dict=True) > > the nitty gritty details of the syntax depend on the driver parameter > > On Thursday, January 12, 2017 at 2:46:28 PM UTC+1, Jorrit wrote: >> >> When I use *db.executesql* like so: >> >> birthdays =

[web2py] Are executesql parameters escaped?

2017-01-12 Thread Jorrit
When I use *db.executesql* like so: birthdays = db.executesql("SELECT * FROM auth_user WHERE DAYOFYEAR(curdate() -2) < dayofyear(dateOfBirth) " "AND DAYOFYEAR(curdate()) +7 >= dayofyear(dateOfBirth) " "AND employeeState_id = {1} AND location_i

[web2py] Re: Upgrading web2py

2016-12-29 Thread Jorrit
28 December 2016 10:20:22 UTC-6, Jorrit wrote: >> >> I have an application that runs on web2py 2.9.11 . I tried downloading >> the latest version, packaging the app in the old version and re-uploading >> it in the new version, but predictably this did not work. The documenta

[web2py] Upgrading web2py

2016-12-28 Thread Jorrit
I have an application that runs on web2py 2.9.11 . I tried downloading the latest version, packaging the app in the old version and re-uploading it in the new version, but predictably this did not work. The documentation says that upgrading should just be a matter of unzipping the new version of