Re: [web2py] SQLite, or some other database?

On Friday, 2 January 2015 16:03:16 UTC-6, mweissen wrote: > > I have tried to convert an application from SQLite to Postgresql and I > have found two differences: > > (1): > q = some query like db.table.field<3 > b = some boolean like a<3 > db(q & b) > > SQLite needs to convert b to '0' or '1',

[web2py] Web2Py on AWS EC2

I have an instance running Linux at Amazon AWS EC2 after carefully following the instructions provided by Amazon here . I have set-up the security groups as mentioned in the documentation provided by Amazon.

[web2py] Re: Format clause for multiple table relationships

On Friday, 2 January 2015 20:12:31 UTC, Massimo Di Pierro wrote: > > I think you are asking about this: > > db.define_table( > 'manufacturer', > Field('name'), > format = '%(name)s') > > db.define_table( > 'model', > Field('manufacturer', db.manufacturer), > Field('model')

Re: [web2py] SQLite, or some other database?

I have tried to convert an application from SQLite to Postgresql and I have found two differences: (1): q = some query like db.table.field<3 b = some boolean like a<3 db(q & b) SQLite needs to convert b to '0' or '1', Postgresql to 'FALSE' or 'TRUE' (2): orderby generates some difficult error me

[web2py] Load() in a page with a form

Need to see some code. -- 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 subscribed to the Google Groups "web2py-

[web2py] Load() in a page with a form

Ive got a page with a form embedded in it. I also have a load call, but that form wont submitit will when i just pull the .load file so I know its not the coding. Thoughts? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Format clause for multiple table relationships

I think you are asking about this: db.define_table( 'manufacturer', Field('name'), format = '%(name)s') db.define_table( 'model', Field('manufacturer', db.manufacturer), Field('model'), format=lambda r: '%s %s' % (r.manufacturer.name, r.model)) # one hidden query db.

Re: [web2py] Re: navbar in sqlform.grid

just guessing do you have the "requires" clause in your db.py file? E.g.: db.yourTable.yourField.requires = IS_NULL_OR(IS_IN_DB(db, db.otherTable.otherField, '%(fieldName)s',zero=T('choose one'))) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/w

Re: [web2py] This looks like it needs some web2py love...

+1 On Sat, Dec 7, 2013 at 1:32 PM, Jason (spot) Brower wrote: > https://github.com/github/gitignore > > -- > 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 Issu

Re: [web2py] database select from set encoding

Postgres adapter sets client_adapter to UTF8 https://github.com/web2py/pydal/blob/master/pydal/adapters/postgres.py#L147 Do you have the same problem without the as_dict? If you have direct (command line) access to the db, post the content of the field. Paolo On Friday, January 2, 2015 4:03:41

Re: [web2py] SQLite, or some other database?

SQLite is by design an excellent embedded database, better suited for single user implementation and targeted at small datasets. For larger datasets there is no reason not to use PostgreSQL, it's free, well supported by web2py, handles very large datasets and it's easy to setup. Migration from SQ

Re: [web2py] Re: navbar in sqlform.grid

I tried and it is the same. If i click on inspect element everything is there but the dropdown is not shown 2014-12-30 14:37 GMT+01:00 Jim Steil : > Have you tried removing all of your javascript and css to see if it works? > > -Jim > > On Tue, Dec 30, 2014 at 7:33 AM, Vid Ogris wrote: > >> My f

Re: [web2py] database select from set encoding

decode('utf-8') crashes my view. and I can't find the error 2014-12-30 19:37 GMT+01:00 Michele Comitini : > the string is a utf-8 encoded string not unicode object > > >>> print 'Moj\xc4\x8dca'.decode('utf-8') > Mojčca > > > > 2014-12-30 15:32 GMT+01:00 Niphlod : > >> let's tackle the problem fr

[web2py] Re: pagination issue redirecting to the current page

in the view links add the page and element id: {{=A('Select', _id = i.id, _class="btn btn-danger",_href=URL("select", args= i.id, vars=dict(id=i.id,page=page)))}} {{elif i.selected:}} {{=A('Selected', _id = i.id, _class="btn btn-info",_href=URL("select", args= i.id, vars=dict(id=i.id, page=page <

Re: [web2py] session uuid

Thanks very much Michele, that works perfectly! I appreciate it. BTW: I hope I am not excessively self-assertive but if you have a minute and you can take a look at this other problem I posted, I would really appreciate it: https://groups.google.com/forum/#!topic/web2py/avpnonuPaJU On Friday, J

[web2py] SQLite, or some other database?

>From reading a lot of web2py tutorials and guides, they always say SQLite is good for small implementations of databases, whereas other SQL flavors are better suited for larger uses. Is there any reason why? Can I still use SQLite if I have a lot of information to store? -- Resources: - http:

[web2py] New Powered by site - advertise your work

We have a new "powered by" web site. http://web2py.com/poweredby Please check it out, report any problem, and feel free to use it to advertise your web sites. Massimo -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Re: 2.9.11 migration

how did you upgrade ? On Wednesday, December 31, 2014 8:31:42 PM UTC+1, lucas wrote: > > hey everyone, > > i just upgraded from 2.9.5 to 2.9.11 web2py onto a new centos 6.5 server. > > is there any migration stuff i need to know because just doing admin in > the url and apache is throwing back: >