[web2py] Re: put multiple database tables like grid in one place

trying your suggestion with datatables that have web2py multiple table relations join *ref:* http://www.web2pyslices.com/slice/show/2052/using-datatablesnet-with-web2py-for-ultra-fast-grid-display *models/db.py* db.define_table('sale_order', Field('sale_order_no') ) db.define_table('cash_in',

[web2py] Google Survey

Hi, Is there any web reference for web2py application like google survey? Appreciate if someone can refer me to repo or web reference. I need to fully design we2py Survey application just like google where users should be able to create surveys and also take surveys. Regards, Shazia --

[web2py] Re: Alias column names (akin to AS clause) in db select

Maybe def test(): rows = db(db.Table1.foo==db.Table2.foo).select(db.Table1.foo.with_alias( 'foo'), db.Table2.bar.with_alias('blah')) for row in rows: print row.foo, row.blah return locals() should work. Another way - if you can rewrite tables definitions - is to use the

[web2py] Re: how to rewrite an URL to drop a function name showing in the address bar

I removed routes_in and routes_out. The routes.py file in the site's root looks like so: routers = dict( # base router BASE=dict( default_application='init', ), stock=dict( default_function='index', functions=dict(

[web2py] Re: put multiple database tables like grid in one place

On Monday, August 28, 2017 at 2:50:29 PM UTC-7, 黄祥 wrote: > > my current models > db.define_table('sale_order', > Field('sale_order_no'), > Field('sale_order_date', 'date'), > Field('customer', 'reference customer'), > Field('product', 'reference product'), > Field('quantity', 'integer'), >

Re: [web2py] Re: Currency formating

Bruno, It's so old! But helped a lot. Thank you. Any way, news about locale? Best regards, Daniel Guilhermino Em quarta-feira, 25 de agosto de 2010 18:03:54 UTC-3, rochacbruno escreveu: > > I solved using temporarily this: > > def Moeda(valor, formatado=True): > from locale import

[web2py] Re: Two database join query

had you tried ? *e.g. not tested* rows = db(db1.table1.pid == db2.table2.pid).select() ref: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Inner-joins best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: put multiple database tables like grid in one place

my current models db.define_table('sale_order', Field('sale_order_no'), Field('sale_order_date', 'date'), Field('customer', 'reference customer'), Field('product', 'reference product'), Field('quantity', 'integer'), Field('price', 'double'), Field('total_price', 'double'), Field('grand_total',

Re: [web2py] Re: web2py 2.15.3 is OUT

On Monday, August 28, 2017 at 2:03:43 PM UTC-4, Yoel Benitez Fonseca wrote: > > Hi, > > new copy of 2.15.3, create a model with a date Field - using SQLite, > in appadmin or a CRUD form the date widget don't show the year, just > the name of the day. > How is this related to the current

[web2py] Re: put multiple database tables like grid in one place

On Wednesday, August 23, 2017 at 2:58:49 PM UTC-7, 黄祥 wrote: > > is there any way to put multiple database tables like grid in one place > using web2py way? > Can you sketch some sort of mock up, so we have a clearer idea of what you'd like? > tried before just using 2 database tables,

[web2py] Rocket logs and server crash

I came in to a message from UptimeRobot that my server was down (4:20 am mytime). So I check the logs ... The httpserver.log file ends at 4:02, with the last successful UptimeRobot check. The logs/web2py.log has 3 entries beyond that, at 4:05 Rocket is throwing an exception because

[web2py] Re: Two database join query

My app require two database . This why i post a question here ... On Tuesday, August 29, 2017 at 1:55:09 AM UTC+8, Alfonso Serra wrote: I guess this is the solution: https: //stackoverflow.com/questions/6824717/sqlite-how-do-you-join-tables-from-different-databases

[web2py] Re: how to rewrite an URL to drop a function name showing in the address bar

First, get rid of routes_in/routes_out -- they will not work in conjunction with "router". Regarding "default" in the URL -- how are you generating the URL. You can always add default_controller="default", but that should not be necessary, as "default" is the default value for

[web2py] Re: how to rewrite an URL to drop a function name showing in the address bar

Big thank you! This works. One little detail emerged though. Now that I replaced the pattern router.py (having my line in routes_out as above) in my site root with the parameter rewrite method my URL shows 'default': https://192.168.1.25:8000/stock

Re: [web2py] Re: web2py 2.15.3 is OUT

Hi, new copy of 2.15.3, create a model with a date Field - using SQLite, in appadmin or a CRUD form the date widget don't show the year, just the name of the day. I come from 2.14.6, don't know if this is something related only to 2.15.3 or is that i'm missing something. 2017-08-27 21:13

[web2py] Re: Two database join query

I guess this is the solution: https://stackoverflow.com/questions/6824717/sqlite-how-do-you-join-tables-from-different-databases If you want to write simpler sqls, the tables should be within the same database. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: how to create pdf report in web2py???

We have a winner. Great tool... 2017-08-26 14:19 GMT+01:00 Alex : > We created a report tool since creating pdf reports in a web application > is a common problem and none of the existing solutions were optimal for us. > We needed something that is easy to integrate, easy to use

[web2py] weird issue with date field

hi, i got a new copy of the lasted stable web2py from web2py.com, put in this simple model: tbl = db.define_table( "productos", Field('nombre', 'string', length=100, label='Nombre'), Field('codigo', 'string', length=30, label='Código'), Field('fecha_caducidad', 'date', label='Fecha caducidad'),

[web2py] Two database join query

Hello ! Hope someone can help . Thanks in advance ! I have two database : db1 = DAL('sqlite://first.sqlite') db2 = DAL('sqlite://second.sqlite') with tables : db1.define_table('table1', Field('id',requires=IS_NOT_EMPTY()), Field('pid',type='integer'), Field('title',type='string'), ) and

[web2py] Re: how to rewrite an URL to drop a function name showing in the address bar

On Monday, August 28, 2017 at 10:05:27 AM UTC-4, 98uj...@gmail.com wrote: > > No, the name 'index' withing 'showcase' is idle. > Then just use the parameter-based rewrite system with a configuration like this: routers = dict( stock=dict( default_function='index',

[web2py] Re: easy deploy on OpenShift

Il 22/08/2017 11:02, Manuele ha scritto: Dear web2py users, I'd like to submit to your attention this github project: https://github.com/manuelep/openshift_web2py it's a fork from the original homonym project no more mantained. Uhm... ok Openshift announced that it's going to dismiss

[web2py] Re: how to rewrite an URL to drop a function name showing in the address bar

No, the name 'index' withing 'showcase' is idle. On Monday, August 28, 2017 at 9:56:13 AM UTC-4, Anthony wrote: > > Do you have a /showcase/index function? > > On Monday, August 28, 2017 at 2:03:40 AM UTC-4, 98u...@gmail.com > wrote: >> >> I chose pattern-based rewrite because I don't know

[web2py] Re: how to rewrite an URL to drop a function name showing in the address bar

Do you have a /showcase/index function? On Monday, August 28, 2017 at 2:03:40 AM UTC-4, 98uj...@gmail.com wrote: > > I chose pattern-based rewrite because I don't know better. I am temporary > part time web coder relying on web2py book 100% with understanding at about > 60%. Being a mature

[web2py] Re: Alias column names (akin to AS clause) in db select

On Monday, July 31, 2017 at 1:25:31 PM UTC-7, Paolo Caruccio wrote: > > Maybe the web2py book could help you: > > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=with_alias#Self-Reference-and-aliases > > That appears to only be talking about using aliases

[web2py] Re: how to rewrite an URL to drop a function name showing in the address bar

I chose pattern-based rewrite because I don't know better. I am temporary part time web coder relying on web2py book 100% with understanding at about 60%. Being a mature person I am fond of eloquence in life as well as in URL's however complexity has its price. I sense from what you are