Hello, I have the following query working in pure SQL on SQLite but do not
know how to convert it to pyDAL:
SELECT * FROM buy WHERE date('now','-2 days') < timestamp;
The buy table schema is:
CREATE TABLE "buy"(
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"order_id" CHAR(512),
"market"
2.15.3-2017.08.07
I had same here, with SQLite too.
I confirm it can be solved so:
1) rename databases/ to databases_corrupted/
2) create empty folder databases/
3) navigate to appadmin or main page -> database is now empty
4) copy databases_corrupted/sqlite.db back to databases/sqlite.db
or so:
Set proper validater in your models or create a custom validator or use a
javascript plugin that behave has you would your input field to do in the
front end as you collect the data in the way you want in the backend...
Instead of asking why you try to use don't work, ask us how to do what you
try
This use case keeps on haunting me... :)
Sometimes i want to hide columns from a smartgrid but I still want to be
able to search for them AND use it within the SQLFORM links parameter, like
the 'fingerprint' parameter in the following example:
in model:
db.define_table('mytable',
Field('nam
I have many tables that share common attributes, so for convenience and
ease of refactoring, I decided to define such common fields and then simply
reference those fields when defining tables. For example:
namefield = Field("name")
db.define_table('table1', namefield)
db.define_table('table2',
Hello all,
I am using logging methods: ldap_auth (in 'ad' mode) and auth.
My application logins perfectly from web auth form, validate with both
methods, depending the order of them.
I am using AuthJWT for remote access, from an Android mobile application.
It works fine with local database.
My
Hello Steve,
I had read about MongoDB for a project that I had in mind... When I see
your thread first question come to mind is why porting relational database
to mongo... In mongo you will have to design your database in a much
different way then in and relational engine in order to make some ben
I think you can enforce that this way :
auth.settings.login_methods = [ldap_auth(...)] as the only method...
For instance I have :
auth.settings.login_methods = [auth, ldap_auth(...)]
So it check the password first in web2py then in Active Directory... I
guess by removing the auth ad an authent
On Monday, September 25, 2017 at 9:35:04 AM UTC-7, Richard wrote:
> Instead of asking why you try to use don't work, ask us how to do what you
> try to achieve, it will be more productive.
>
>
Except when the first response is "well, what did you try?"
I think it's useful to say "I'm tyring
Thanks, but why this is working
form.components.append(A('Indietro',_class='btn btn-default',
_onclick="window.history.back()"))
and this is not working?
form.append(BUTTON('Indietro', _onclick="window.history.back()"))
Il giorno lunedì 11 settembre 2017 01:06:00 UTC+2, Massi
On Monday, September 25, 2017 at 11:37:10 AM UTC-7, Dave S wrote:
>
>
>
> On Monday, September 25, 2017 at 9:35:04 AM UTC-7, Richard wrote:
>
>
>> Instead of asking why you try to use don't work, ask us how to do what
>> you try to achieve, it will be more productive.
>>
>>
> Except when the f
just want to learn about mongodb and how to use it with web2py, the same
code is work in all rdms (tested in sqlite, mysql, postgre except change
configuration db uri in appconf.ini and the executesql() create index for
text field in mysql (minor) ) but when tested with nosql (first try with
mo
On Monday, September 25, 2017 at 2:44:19 PM UTC-7, 黄祥 wrote:
>
> just want to learn about mongodb and how to use it with web2py, the same
> code is work in all rdms (tested in sqlite, mysql, postgre except change
> configuration db uri in appconf.ini and the executesql() create index for
> tex
"object_type" reserved word in web2py?
thanks
Alex Glaros
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subs
Hi i am working to build a multi-tenant application which has a company
table which stores logo and other data. I defined a company table, added
extra fields in auth_user and created an action (simplified version) like
below. web2py uploaded the logo image file under
myapp/uploads/company.logo/
15 matches
Mail list logo