[web2py] Re: "distinct" based on more than 1 field

2015-06-27 Thread Annet
For distinct to work you need orderby, I don't know if that works for more than one field. orderby=db.person.firstname | db.person.familyname, distinct = True Kind regards, Annet -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sou

Re: [web2py] Re: Layout problem

2015-06-27 Thread Selman Kocael
Every thing okay. But one thing missing. It is css file. In that page, right click and open source code, then search ".css" keyword. You must see this link: click the link, if you can't see this file check the static folder, if missing these files. you can copy other aplplications static folde

[web2py] Re: languages.py", line 914 - error

2015-06-27 Thread Dmitry Ermolaev
How seek this error in my translating file? Could You make a CHECK function to find that kind error? суббота, 27 июня 2015 г., 10:22:18 UTC+3 пользователь Massimo Di Pierro написал: > > Consider this > > T("Hello %s", "Dmitry") > > if "Hello %s" is translated with "Ciao" without the "%s" than >

[web2py] Re: dynamic query on web2py

2015-06-27 Thread 黄祥
yeah, the random thing in dal is handle the task. thank you so much for the pointer : dave, michael and anthony. thanks and best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p

[web2py] Re: "distinct" based on more than 1 field

2015-06-27 Thread villas
I think you need to use the distinct like this: rows = db(q).select(db.person.firstname, db.person.familyname, distinct=True) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: For those using ractive or vuejs. I need help !!

2015-06-27 Thread António Ramos
No help :) Im doomed... Em 26/06/2015 17:29, "António Ramos" escreveu: > Hello , > so far so good i created my second vuejs page inside web2py and this time > using components. > > > my doformind.js has some components and changes the delimiters to avoid > colision with curlies. > > Vue.config.de

[web2py] "distinct" based on more than 1 field

2015-06-27 Thread Davy Jacops
db "person" with 2 fields: db.define_table('person', Field('firstname', type='string'), Field('familyname', type='string'), . ) Need to make this table visible in SQLFORM.grid / SQLFORM.smartgrid, or SQLTABLE based on a JOIN query: q = ((db.person.id

[web2py] Re: dynamic query on web2py

2015-06-27 Thread Anthony
It's in the book: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#orderby--groupby--limitby--distinct--having-orderby_on_limitby-left-cache orderby='' Anthony On Saturday, June 27, 2015 at 8:28:09 AM UTC-4, 黄祥 wrote: > > yeah, something like that, but i don't know h

[web2py] Re: dynamic query on web2py

2015-06-27 Thread Michael Beller
Could you order by a virtual field where the virtual field is a lambda returning a random number? http://www.web2py.com/books/default/chapter/35/06/the-database-abstraction-layer#New-style-virtual-fields--experimental- On Saturday, June 27, 2015 at 8:28:09 AM UTC-4, 黄祥 wrote: > > yeah, something

[web2py] Re: bootstrap layout adaption

2015-06-27 Thread Michael Beller
I think it would be fairly straightforward. For any grid you would just pass the data using a rows object to the view and create the required structure in the template. For any form you have a couple of options but if you wanted to use the validators in SQLFORM I think you would set the CSS cla

[web2py] Re: dynamic query on web2py

2015-06-27 Thread 黄祥
yeah, something like that, but i don't know how to do an orderby with random option in web2py. any idea how to achieve it in web2py? thanks and best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: record versioning on auth tables

2015-06-27 Thread 黄祥
make sense, thank you so much for detail explaination, massimo. thanks and best regards, stifan -- 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 recei

[web2py] Re: languages.py", line 914 - error

2015-06-27 Thread Massimo Di Pierro
Consider this T("Hello %s", "Dmitry") if "Hello %s" is translated with "Ciao" without the "%s" than "Ciao" % "Dmitry" results in an error. The problem is the omission of a %s or or the addition of a %(name)s in the translation, possibly a misspelling of he (name)? On Saturday, 27 June 2015

[web2py] languages.py", line 914 - error

2015-06-27 Thread Dmitry Ermolaev
Traceback (most recent call last): File "C:\web2py-m\gluon\restricted.py", line 224, in restricted exec ccode in environment File "C:\web2py-m\applications\ipay\views\buy/index.html", line 184, in File "C:\web2py-m\gluon\html.py", line 612, in __init__ text = str(text) File "C:\