[web2py] Re: groupby in sqlform.grid resulted into unsupported query

I am also having the same issue. I am using "2.5.1-stable+timestamp.2013.06.06.15.39.19" -- On Tuesday, August 6, 2013 4:08:38 AM UTC+5:30, villas wrote: > > IMO anyone who want to have a grid populated by aggregate functions should > be rolling their own, but that isn't the iss

[web2py] About the database name

According to chapter 6.4 of the book let's have a connection like db = DAL('sqlite://storage.db') and the statement >>> print db._dbname sqlite (1) What I do not understand: Why is _dbname == "sqlite"? I think that is the name of the *connector *and the name of the *database *should be "stor

Re: [web2py] Re: 2 domains served by the same web2py

I dont get it. i tried this with no success i created an empty routes.py file in my web2py folder then inside i wrote # -*- coding: utf-8 -*- routes_app = ( (r'.*?:http?://www.cires.pt:\w* /$anything', r'welcome'), (r'.*?:http?://apps.cires.pt/empre:\w* /$anything', r'empre'), (r'.*

Re: [web2py] Re: 2 domains served by the same web2py

So, you have define your base "routes.py" on web2py folder. Then, do you have set up an app-specific routes.py in your application folder? For example, in welcome app you should have a routes.py file containing something like (just a stupid example from one of my apps) : # -*- coding: utf-8 -*- r

Re: [web2py] Re: xmlrpc security

It should be possible in combination with gluon/contrib/login_methods/x509_auth.py using the standard @auth_requires_login or checking authorization data in a model after the usual auth=Auth() is properly instantiated and initiated. mic 2013/10/25 Massimo Di Pierro > I do not think xmlrpc can

[web2py] Request: Error Traceback Page: Requested URL with Arguments

Hi, I would love to see a little addition to the error page: A line where it displays the entire URL with all the arguments. I know its already under the request button. but its spread and I have to search for it every time. it would really speed up my process of looking for an error. And I guess

[web2py] Re: Unable to join more than one table in SQLForm.grid

Ah, now I understand what you are trying to do. This works for me in that the Add button takes me to auth_group. You will have to define an oncreate function to link the new group back to the user, by the way. RTFM for that. Stare at my query until you understand how it works. The controller

Re: [web2py] Re: form.custom usage

Thanks Anthony, I will try... Next week I will reproduce it. Em 25/10/2013 00:21, "Anthony" escreveu: > Not quite clear what the problem is. What you put in the view shouldn't > matter -- that just generates the HTML to display the widgets -- it doesn't > have anything to do with validation (and

[web2py] Re: Cannot add a NOT NULL column with default value NULL

What happens if you add default='' to the field def? On Thursday, October 24, 2013 7:10:29 PM UTC-4, Carlos Zenteno wrote: > > What is wrong with the last line of my table? > > db.define_table('tenants_extra', > Field('tenant', 'reference tenants'), > Field('address', 'reference addresses'

[web2py] Re: Request: Error Traceback Page: Requested URL with Arguments

ehm, where exactly ? Il giorno venerdì 25 ottobre 2013 11:59:12 UTC+2, BlueShadow ha scritto: > > Hi, > I would love to see a little addition to the error page: > A line where it displays the entire URL with all the arguments. > I know its already under the request button. but its spread and I hav

[web2py] Re: drop down for grid or smart grid search fields

On Wednesday, October 23, 2013 9:01:23 AM UTC+5:30, Sarbjit wrote: > > Can someone please help. > > On Tuesday, October 22, 2013 4:39:00 PM UTC+5:30, Sarbjit wrote: >> >> I am using GRID for displaying my database results. I want to use search >> feature provided by GRID/SMARTGRID where users ca

Re: [web2py] Re: 2 domains served by the same web2py

it works now in my web2py folder i created this routes.py routes_in = ( ((r'.*http://www.cires.pt.* (?P.*)', r'/welcome/default\g')), ((r'.*http://apps.cires.pt/empre.* (?P.*)', r'/empre/default\g')), ((r'.*http://apps.cires.pt/ERP.* (?P.*)', r'/ERP/default\g')), ((r'.*http://apps.cires.p

Re: [web2py] Re: 2 domains served by the same web2py

oops ((r'.*http://www.previnil.pt.* (?P.*)', r'/previnil/default\g')), is not working. It defaults to /welcome/ why? 2013/10/25 António Ramos > it works now > in my web2py folder i created this routes.py > > routes_in = ( > ((r'.*http://www.cires.pt.* (?P.*)', r'/welcome/default\g')), >

[web2py] Re: drop down for grid or smart grid search fields

I was looking at the code in gucon.sqlform elif (field.type.startswith('reference ') or field.type.startswith('list:reference ')) and \ hasattr(field.requires,'options'): value_input = SELECT( *

[web2py] Re: Unable to join more than one table in SQLForm.grid

Thanks that worked :) On Friday, October 25, 2013 3:34:03 PM UTC+5:30, Cliff Kachinske wrote: > > Ah, now I understand what you are trying to do. > > This works for me in that the Add button takes me to auth_group. You will > have to define an oncreate function to link the new group back to the

[web2py] Re: drop down for grid or smart grid search fields

It's not necessary modify the code in gluon. You could replace the text input in the query panel. For example: 1) in db.py we define our table db.define_table('contact', Field('name'), Field('phone')) 2) in default.py we define our controller to create the grid def contacts(): grid=SQ

[web2py] Re: drop down for grid or smart grid search fields

Thanks a lot Paolo Caruccio!! On Friday, October 25, 2013 6:39:46 PM UTC+5:30, Paolo Caruccio wrote: > > It's not necessary modify the code in gluon. > You could replace the text input in the query panel. For example: > > 1) in db.py we define our table > > db.define_table('contact', >Field(

Re: [web2py] Re: 2 domains served by the same web2py

On 25 Oct 2013, at 2:17 AM, Loïc Espern wrote: > So, you have define your base "routes.py" on web2py folder. > Then, do you have set up an app-specific routes.py in your application folder? No, you can do everything in the root routes.py. > > For example, in welcome app you should have a rout

Re: [web2py] Re: 2 domains served by the same web2py

On 25 Oct 2013, at 2:09 AM, António Ramos wrote: > I dont get it. > > > i tried this with no success > i created an empty routes.py file in my web2py folder > then inside i wrote > > # -*- coding: utf-8 -*- > > routes_app = ( > (r'.*?:http?://www.cires.pt:\w* /$anything', r'welcome'), >

[web2py] Re: About the database name

That is an internal variable used to known the name of db engine (sqlite, postgres, etc.) On Friday, 25 October 2013 03:25:59 UTC-5, mweissen wrote: > > According to chapter 6.4 of the book let's have a connection like > > db = DAL('sqlite://storage.db') > > and the statement > > >>> print db._db

[web2py] Re: auth.messages.verify_email html template

I'm having the same problem. I have a general email template wich receives some context variables. I want to use that same template for sending the "verify_email", but can't figure it out. Any example? Thanks in advance. El miércoles, 24 de abril de 2013 13:39:10 UTC-3, Cristoffer Fairweather

Re: [web2py] Re: 2 domains served by the same web2py

routes_in = ( (r'.*?:https?://www\.cires\.pt:.* /$anything', r'/welcome/$anything'), * (r'.*?:https?://www\.previnil\.pt:.* /$anything', r'/previnil/$anything'),* (r'.*?:https?://apps\.cires\.pt:.* /empre/$anything', r'/empre/$anything'), (r'.*?:https?://apps\.cires\.pt:.* /erp/$anyt

Re: [web2py] Re: 2 domains served by the same web2py

On 25 Oct 2013, at 8:04 AM, António Ramos wrote: > routes_in = ( > (r'.*?:https?://www\.cires\.pt:.* /$anything', r'/welcome/$anything'), > (r'.*?:https?://www\.previnil\.pt:.* /$anything', r'/previnil/$anything'), > (r'.*?:https?://apps\.cires\.pt:.* /empre/$anything', > r'/empre/$a

[web2py] Re: Using dots on the URL. [routes.py] or [nginx]

I think I need to include here: (r'.*?:https?://subdomain.domain.com:\w* /$anything', r'myapp'), It should be appended after the 'w', I tried with this options, but no success: 1. (r'.*?:https?://subdomain.domain.com:\w.* /$anything', r'myapp'), 2. (r'.*?:https?://subdomain.domain.com:\

Re: [web2py] Re: 2 domains served by the same web2py

yes with the bold line commented out i stil go to welcome when i write in my browser http://www.previnil.pt is that because welcome is the default app? 2013/10/25 Jonathan Lundell > On 25 Oct 2013, at 8:04 AM, António Ramos wrote: > > routes_in = ( > (r'.*?:https?://www\.cires\.pt:.* /$

[web2py] How Do You Choose Frameworks That Will Survive?

Web2py seems to be good example for it: http://ask.slashdot.org/story/13/10/23/1633232/ask-slashdot-how-do-you-choose-frameworks-that-will-survive but it needs some points from more experienced ones... Sincerely, Gour -- As the ignorant perform their duties with attachment to results, the le

Re: [web2py] Re: 2 domains served by the same web2py

On 25 Oct 2013, at 8:29 AM, António Ramos wrote: > yes > with the bold line commented out i stil go to welcome when i write in my > browser http://www.previnil.pt > > is that because welcome is the default app? It is, yes, so not a great path to use for testing. Keep in mind that you should

Re: [web2py] Re: 2 domains served by the same web2py

yes i reload the routes on every change to routes.py but how do i route to previnil app when i write http://www.previnil.pt ??? I have my 2 dns pointing to my web2py server (www.cires.pt and www.previnil.pt) 2013/10/25 Jonathan Lundell > On 25 Oct 2013, at 8:29 AM, António Ramos wrote: > >

Re: [web2py] 2 domains served by the same web2py

On 25 Oct 2013, at 9:18 AM, António Ramos wrote: > yes i reload the routes on every change to routes.py > > but how do i route to previnil app when i write http://www.previnil.pt ??? > > I have my 2 dns pointing to my web2py server (www.cires.pt and > www.previnil.pt) I'm about to be offline

[web2py] **{'data-something': '...'} with A() helper in w2p 2.4.7 not working

Hello, Is this possible in later version of w2p : DIV(A(I(_class='icon-download'), CAT(' '), T('Save relative oganization chart as...'), SPAN(_class='caret'), _class='btn dropdown-toggle', _href='#', ***{'data-toggle': 'dropdown'}*), UL(LI(A('png', _href=URL('directory

Re: [web2py] **{'data-something': '...'} with A() helper in w2p 2.4.7 not working

You forgot the leading underscore -- should be: **{'_data-toggle': 'dropdown'} Anthony On Friday, October 25, 2013 1:00:20 PM UTC-4, Richard wrote: > > Hello, > > Is this possible in later version of w2p : > > DIV(A(I(_class='icon-download'), CAT(' '), T('Save relative oganization > chart as...

Re: [web2py] **{'data-something': '...'} with A() helper in w2p 2.4.7 not working

HA! Thanks! Richard On Fri, Oct 25, 2013 at 1:08 PM, Anthony wrote: > You forgot the leading underscore -- should be: > > **{'_data-toggle': 'dropdown'} > > Anthony > > On Friday, October 25, 2013 1:00:20 PM UTC-4, Richard wrote: >> >> Hello, >> >> Is this possible in later version of w2p : >

Re: [web2py] **{'data-something': '...'} with A() helper in w2p 2.4.7 not working

Also, note that specifically for "data-" attributes, you can now do: A(..., data=dict(toggle='dropdown')) Anthony On Friday, October 25, 2013 1:08:47 PM UTC-4, Anthony wrote: > > You forgot the leading underscore -- should be: > > **{'_data-toggle': 'dropdown'} > > Anthony > > On Friday, October

[web2py] Re: Using dots on the URL. [routes.py] or [nginx]

neither for: (r'.*?:https?://subdomain.domain.com:[\w\.]+ /$anything', r'style'), output: First URL is working ok, second not: 1. http://subdomain.domain.com/profile/albert Works 2. http://subdomain.domain.com/profile/albert.abril

[web2py] How Do You Choose Frameworks That Will Survive?

First choose a language as it has a longetivity beyond a framework (i.e. Python). Then choose a framework which meets your needs and start using it. I dont think long analysis will do any good as it is not that difficult to learn and adapt to another framework (especially python). I've done mos

Re: [web2py] **{'data-something': '...'} with A() helper in w2p 2.4.7 not working

Great! Than you Anthony. Richard On Fri, Oct 25, 2013 at 1:10 PM, Anthony wrote: > Also, note that specifically for "data-" attributes, you can now do: > > A(..., data=dict(toggle='dropdown')) > > Anthony > > > On Friday, October 25, 2013 1:08:47 PM UTC-4, Anthony wrote: >> >> You forgot the

Re: [web2py] Re: xmlrpc security

Hi guys, Thanks for the pointers. I'm trying to use self-signed certs to remove login/password from the xmlrpc interface for machine authentication. Digging more in the docs, it looks like part of this is apache config. I'll do some more testing and report back if/what changes I have to make to

[web2py] Access the server data in javascript

I want to access the server data in the client side. I am currently ajax calling and returning the data in a dict. I am storing the returned data structure in a javascript variable. When I try to print the data from javascript variable, the console log shows html characters for double quotes. I

[web2py] Re: display results from DB using the selected option by pulling

Thanks Cliff, I will take a look and let you know how it goes. I did not think this would need JQuery/Ajax before. On Thursday, October 24, 2013 4:55:47 PM UTC-4, Cliff Kachinske wrote: > > Two chapters in the online manual will answer your questions. > >- JQuery and Ajax >- Components

[web2py] Multiple forms with single submit button???

Hello All, I have one question regarding putting one single button for multiple forms... At present I have 4 form and its corresponding submit buttons. Now I would like to have single button instead of four... I would like have a submit button which submit only those user entered value in specif

[web2py] Re: Multiple forms with single submit button???

you can't post to the same page more than a form at a time (unlessajax is involved). For sure you can't have a single controller handling multiple posts and redirect to very different pages for every pseudo-formhow should that happen (meaning what are you trying to achieve) ? You have

[web2py] Re: Cannot add a NOT NULL column with default value NULL

Yes I read all the old 2009 posts regarding this issue and added default = '' and also IS_NOT_EMPTY() and still get the same error... -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/iss

[web2py] Re: Cannot add a NOT NULL column with default value NULL

Yikes. Is there data already in the table? I've had problems with that in the past myself. Can you add the field OK without the not null? On Friday, October 25, 2013 4:14:28 PM UTC-4, Carlos Zenteno wrote: > > Yes I read all the old 2009 posts regarding this issue and > added default = '' an

[web2py] Re: Multiple forms with single submit button???

my goal is when user enter either of four form field value it goes to corresponding redirect page after pressing one submit button. thanks On Friday, 25 October 2013 12:49:31 UTC-7, Niphlod wrote: > > you can't post to the same page more than a form at a time (unlessajax is > involved). > For s

Re: [web2py] Best way to learn web2py

I don't think anything is "missing". People just want to get their toes wet when creating websites, and prefer instant gratification to reading the documentation. Nothing wrong with that, and adding more documentation really isn't going to solve the problem. My advice to anyone who wants to lea

[web2py] Re: Multiple forms with single submit button???

what if he fills two forms then ? On Friday, October 25, 2013 10:49:40 PM UTC+2, sonu kumar wrote: > > my goal is when user enter either of four form field value it goes to > corresponding redirect page after pressing one submit button. > > thanks > > On Friday, 25 October 2013 12:49:31 UTC-7, Ni

[web2py] Re: another blank editor question

Well, I'm still seeing this occasionally. I switched the raspberry pi to Arch just to simplify things. I am starting the server with "python2.7 web2py.py -i my.ip.address". Restarting the server appears to fix it. The request that breaks is: Request URL: http://localhost:8000/admin/default/e

[web2py] Re: How Do You Choose Frameworks That Will Survive?

I don't know, I chose 'Zope' in 2002 because it was open source and backed by a for-pay company. The framework itself lived on for around 12 years from it's inception, which I think is pretty good, considering that everything they did was pretty much unheard of at the time. Python didn't have

[web2py] Re: Access the server data in javascript

use {{=XML()}} around things you want to return raw in your views. On Friday, October 25, 2013 12:23:16 PM UTC-7, Ramesh Kumar wrote: > > I want to access the server data in the client side. I am currently ajax > calling and returning the data in a dict. I am storing the returned data > structur

[web2py] Re: Cannot add a NOT NULL column with default value NULL

I had a couple of records in the table. I went ahead and deleted those and now it works!! Weird... thanks for the help... -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Rep

Re: [web2py] Best way to learn web2py

On Friday, October 25, 2013 1:51:09 PM UTC-7, Derek wrote: > > I don't think anything is "missing". People just want to get their toes > wet when creating websites, and prefer instant gratification to reading the > documentation. Nothing wrong with that, and adding more documentation > really

[web2py] Re: Multiple forms with single submit button???

In general user have to enter only one field...but if fills two then there should be message stating please enter one field... Is this possible...? thanks On Friday, 25 October 2013 13:52:13 UTC-7, Niphlod wrote: > > what if he fills two forms then ? > > On Friday, October 25, 2013 10:49:40 PM

Re: [web2py] Best way to learn web2py

On Friday, October 25, 2013 2:16:24 PM UTC-7, Dave S wrote: > > > On Friday, October 25, 2013 1:51:09 PM UTC-7, Derek wrote: >> >> I don't think anything is "missing". People just want to get their toes >> wet when creating websites, and prefer instant gratification to reading the >> documentatio

[web2py] Re: Multiple forms with single submit button???

every form must be submitted separately. You definitely can't handle the situation when the user fills two forms (unless you choose to discard one of them and submit just the first one) because there's no way to redirect to multiple pages At this point, why don't you make a single form with

[web2py] having trouble with data-xxx when they are not a simple option

using web2py 2.5.1 source on windows Having trouble creating an INPUT with a "non-trivial" data attribute. Did try the following: INPUT(...,**{'_data-options':XML('{"mode":"calbox"}')} ) INPUT(..., data={'options':XML('{"mode":"calbox"}')} ) and several combinations with raw strings but it alw

[web2py] Re: Multiple forms with single submit button???

Now I have modified my code as you said but still not working...it is not redirecting def index(): values= ['','P2', 'P3', 'P8', 'P9', 'P10', 'P14', 'P15', 'P16', 'P17', 'P24'] protease = FORM('Select prot:',SELECT(values,_name='protease',_onchange="jQuery.post('%s',{'protease':jQue

[web2py] TypeError: float argument required, not str

This is my table: db.define_table('tenants_extra', Field('tenant', 'reference tenants'), Field('address', 'reference addresses'), Field('tenant_type', type = 'string', length = 32, default = T('Condo'), required = True, label = T('Type'), comment = T('Type of your organization'), not

Re: [web2py] Using dots on the URL. [routes.py] or [nginx]

On 25 Oct 2013, at 10:20 AM, Albert Abril wrote: > neither for: > (r'.*?:https?://subdomain.domain.com:[\w\.]+ /$anything', r'style'), > > output: > > First URL is working ok, second not: > 1. http://subdomain.domain.com/profile/albert Works > 2. http://subdomain.domain.com/profil

Re: [web2py] Best way to learn web2py

It would help to know exactly what we can do better. Where do you need we need more explanations? On Friday, 25 October 2013 16:19:56 UTC-5, Dave S wrote: > > On Friday, October 25, 2013 2:16:24 PM UTC-7, Dave S wrote: >> >> >> On Friday, October 25, 2013 1:51:09 PM UTC-7, Derek wrote: >>> >>> I

[web2py] Re: Multiple forms with single submit button???

There is no form.process() so request.vars are never moved into form.vars. On Friday, 25 October 2013 17:06:17 UTC-5, sonu kumar wrote: > > Now I have modified my code as you said but still not working...it is not > redirecting > > def index(): > values= ['','P2', 'P3', 'P8', 'P9', 'P10', 'P1

[web2py] Can I temporarily disable record_versioning?

Hi, I appreciate the db.table._enable_record_versioning() capability provided by web2py, but there are some occasions when I'd like to modify a table that has record versioning implemented and not modify the archive. Is there some way that I can temporarily disable record versioning? I guess I c

[web2py] bootstrap 3 skeleton app?

hi there, is there available anywhere yet a web2py skeleton app with bootstrap 3 integrated? thanks, e. -- 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) ---

[web2py] web3py status

hi there, i've seen peppered throughout this list references to "web3py". i seems like it's mostly the unofficial name of of a concept at this stage, but i also see references to work being pulled into web2py from web3py... where is this web3py and what's its current state? thanks, e. -- R

[web2py] Alias on Fields

Hello Sirs, I access a customer Db with two tables as follows: db.define_table('events', Field('event_id', type='integer'), primarykey=['event_id']) db.define_table('documents', Field('document_id'), Field('event_id', 'reference events') primarykey=['document_i

[web2py] Re: Can I temporarily disable record_versioning?

yes. comment the line that enables record versioning, or make it conditional to something. On Friday, 25 October 2013 23:43:39 UTC-5, tomt wrote: > > Hi, > I appreciate the db.table._enable_record_versioning() > capability provided by web2py, but there are some occasions when > I'd like to modif

[web2py] Re: bootstrap 3 skeleton app?

we are working on it. ;-) On Friday, 25 October 2013 21:20:47 UTC-5, elguavas wrote: > > hi there, > > is there available anywhere yet a web2py skeleton app with bootstrap 3 > integrated? > > thanks, > e. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://gith

[web2py] Re: web3py status

I am sorry to day not much has happened. :-( On Friday, 25 October 2013 21:26:36 UTC-5, elguavas wrote: > > hi there, > > i've seen peppered throughout this list references to "web3py". i seems > like it's mostly the unofficial name of of a concept at this stage, but i > also see references to w

[web2py] Re: How Do You Choose Frameworks That Will Survive?

On Fri, 25 Oct 2013 14:07:09 -0700 (PDT) Derek wrote: > I'd suggest just choosing whatever fits your needs now, and is open > source, with easily readable (or relatively so) source code. Well, I'm here 'cause I did choose framework for *my* use, but posted that link hoping that someone more exp

Re: [web2py] 2 domains served by the same web2py

May be * (r'.*https?://www\.previnil\.pt.* /$anything', r'/previnil/$anything'),* could help. I have a similar line which works. 2013/10/25 Jonathan Lundell > > On 25 Oct 2013, at 9:18 AM, António Ramos wrote: > > yes i reload the routes on every change to routes.py > > but how do i route to