[web2py] why is form self submit getting executed on cancel?

My controller has a componentized form with an added Cancel button like this (this is an excerpt, so sorry for any typos): def update( ): myform = SQLFORM.factory( Field('text_in','text',requires=IS_NOT_EMPTY()), buttons=[INPUT(_type='submit',_value=T('Update'))], _id='myform',

[web2py] Re: why is form self submit getting executed on cancel?

How about something like, myform[0].insert(-1, TAG.BUTTON(T('Cancel')),_onclick= 'ajax("%s",[],":eval");' % URL( c='my_controller', f='cancel_update') ) If you want the cancel button to appear in the same table row as the submit button, you may need something like myform[0][1]...

[web2py] Problem with IMG helper function

Hi, Newbie here. In my db I have a link to a local image file located in static/images. From my index page I now want to show these images, but I can't figure out how to do that with the IMG helper function. My code: {{for movie in movies:}} {{=IMG(_src=URL(r=request,c='static/images/',f=' {{

[web2py] Re: why is form self submit getting executed on cancel?

The onclick event doesn't cancel the standard submit behavior -- it just adds the onclick behavior before submitting. If you want to prevent the submit action, do: _onclick='ajax("%s",[],":eval");return false' "return false" prevents the submit. An alternative to using onclick is to register a

[web2py] external link in menu with target option

What if I want to put a voice in the menu that link a page external to my application that I want to open in a new tab? thanks in advance Manuele --

Re: [web2py] How to remove 'default' from all URLs?

On Jun 24, 2012, at 11:26 PM, Alec Taylor wrote: > > Hmm, I'm not sure. > > I'm running the latest trunk from github: > https://github.com/web2py/web2py - If that makes a difference. > > Yes, the /profile/ URL is the one giving me trouble. It could be > something on the facebook side, though I'm

[web2py] Re: Problem with IMG helper function

> > {{=IMG(_src=URL(r=request,c='static/images/',f=' > {{=movie.local_poster_link}}'), _height=150)}} > {{=IMG(_src=URL('static', 'images/%(local_poster_link)s' % movie, _height= 150)}} Anthony --

[web2py] Re: external link in menu with target option

Instead of menu = [...('title',None,'http:...')...] do menu = [...('title',None,A('title',_href='http:...',_target='_blank'))...] On Monday, 25 June 2012 08:06:20 UTC-5, Manuele wrote: > > What if I want to put a voice in the menu that link a page external to > my application that I want

[web2py] Re: external link in menu with target option

You can control exactly what goes inside the for a given menu item by making the third element of that item a web2py HTML helper instead of just a URL. So, instead of: ('External Link', False, 'http://somesite.com') You can do: ('', False, A('External Link', _href='http://somesite.com', _targ

Re: [web2py] How to remove 'default' from all URLs?

On Jun 25, 2012, at 6:07 AM, Jonathan Lundell wrote: > > On Jun 24, 2012, at 11:26 PM, Alec Taylor wrote: >> >> Hmm, I'm not sure. >> >> I'm running the latest trunk from github: >> https://github.com/web2py/web2py - If that makes a difference. >> >> Yes, the /profile/ URL is the one giving me

[web2py] Re: Problem with IMG helper function

Hi Anthony, Unfortunately it does not work 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Traceback (most recent call last): File "C:\MyDev\web2py_src\gluon\restricted.py", line 204, in restricted ccode = compile2(code,layer) File "C:\MyDev\web2py_src\gluon\restricted.py", line 189, in compile2 retu

[web2py] Map database values to display values

Hello, I am extending the registration data with some custom fields (pretty standard). This is my code: from gluon.tools import Service from gluon.tools import Auth db = DAL('sqlite://storage.sqlite') auth= Auth(db) service = Service() db.define_table( auth.settings.table_user_nam

[web2py] Re: How to effectively use the select_datewidget instead of the popup datepicker calendar !! ???

Hello Anthony, What i can tell you is : 1) Even on a standalone test ... with no previous field define in a table ... the widget as shown in the web2py dev cookbook does not work the way they have said that it would work ... they might want to update it or to revise it ... ! .. well .. more p

Re: [web2py] Problem with IMG helper function

On Jun 25, 2012, at 6:20 AM, Anthony wrote: > {{=IMG(_src=URL(r=request,c='static/images/',f='{{=movie.local_poster_link}}'), > _height=150)}} > > {{=IMG(_src=URL('static', 'images/%(local_poster_link)s' % movie, > _height=150)}} > The (parens) are unbalanced. > {{=IMG(_src=URL('static', 'ima

[web2py] Re: How to effectively use the select_datewidget instead of the popup datepicker calendar !! ???

> > 1) Even on a standalone test ... with no previous field define in a table > ... the widget as shown in the web2py dev cookbook does not work the way > they have said that it would work ... they might want to update it or to > revise it ... ! .. well .. more precisely ... it does not show u

[web2py] Re: Map database values to display values

Check out the IS_IN_SET documentation at http://web2py.com/books/default/chapter/29/7. Instead of a list of individual items, it can be a list of two-tuples or a dictionary, where the first tuple item or dictionary key is the value and the second tuple item or dictionary value is the label to b

Re: [web2py] Problem with IMG helper function

Oops. Fixed in original post. On Monday, June 25, 2012 10:31:05 AM UTC-4, Jonathan Lundell wrote: > > On Jun 25, 2012, at 6:20 AM, Anthony wrote: > > > {{=IMG(_src=URL(r=request,c='static/images/',f='{{=movie.local_poster_link}}'), > > _height=150)}} > > > > {{=IMG(_src=URL('static', 'images

Re: [web2py] How to remove 'default' from all URLs?

print auth.settings.login_next /default/profile On Mon, Jun 25, 2012 at 11:37 PM, Jonathan Lundell wrote: > On Jun 25, 2012, at 6:07 AM, Jonathan Lundell wrote: >> >> On Jun 24, 2012, at 11:26 PM, Alec Taylor wrote: >>> >>> Hmm, I'm not sure. >>> >>> I'm running the latest trunk from github: >>>

Re: [web2py] How to remove 'default' from all URLs?

On Jun 25, 2012, at 7:48 AM, Alec Taylor wrote: > > print auth.settings.login_next > /default/profile Would you also print the direct result of a separate URL call, with %s? Thanks. > > On Mon, Jun 25, 2012 at 11:37 PM, Jonathan Lundell wrote: >> On Jun 25, 2012, at 6:07 AM, Jonathan Lundell w

Re: [web2py] How to remove 'default' from all URLs?

On Jun 25, 2012, at 7:48 AM, Alec Taylor wrote: > > print auth.settings.login_next > /default/profile Is it possible that you have a file controllers/profile.py? If you do, the router will not omit 'default' in the above case because it would be ambiguous. > > On Mon, Jun 25, 2012 at 11:37 P

[web2py] Re: Map database values to display values

On Monday, June 25, 2012 4:45:22 PM UTC+2, Anthony wrote: > > Check out the IS_IN_SET documentation at > http://web2py.com/books/default/chapter/29/7. Instead of a list of > individual items, it can be a list of two-tuples or a dictionary, where the > first tuple item or dictionary key is the v

[web2py] Re: Map database values to display values

> > Now, to support internationalization here, I see two options: > > - I implement a function which returns the desired predefined mapping, > according to the language of the user. How can I know this? How does the T > operator know this? > - I walk the list of ISO country codes applying the T

[web2py] Re: Map database values to display values

Yes, that is one of the options I mentioned. If I include all possible countries, my list would have200 entries. I still do not fully understand the process in which modules/views/controllers are loaded when requests are received. But, if I am not completely mistaken, these files are parsed each

[web2py] label_separator on SQLFORM.factory

hi all, I've put: crud.settings.label_separator = '' in db.py to avoid ':' in forms but it seems that this is not read by a SQLFORM.factory form. Is there any way to circumvent this? thanks in advance, Marco --

Re: [web2py] How to remove 'default' from all URLs?

On Tue, Jun 26, 2012 at 12:59 AM, Jonathan Lundell wrote: > On Jun 25, 2012, at 7:48 AM, Alec Taylor wrote: >> >> print auth.settings.login_next >> /default/profile > > Is it possible that you have a file controllers/profile.py? >.< That was the case. I thought I'd renamed everything to profile2

[web2py] Re: Map database values to display values

Do you already have the mapping, perhaps in a dictionary (or can you get it into one)? If so, maybe something like: ISO_COUNTRY_CODE_MAPPINGS = {k: T(v) for (k, v) in original_mapping. iteritems()} # requires Python 2.7 Anthony On Monday, June 25, 2012 11:53:24 AM UTC-4, Daniel Gonzalez wrote:

[web2py] Re: label_separator on SQLFORM.factory

SQLFORM.factory(..., separator='') On Monday, June 25, 2012 11:59:49 AM UTC-4, Marco Prosperi wrote: > > > hi all, I've put: > crud.settings.label_separator = '' > in db.py to avoid ':' in forms but it seems that this is not read by a > SQLFORM.factory form. Is there any way to circumvent this?

[web2py] Re: Creating users on checkout?

Not so easy? --

Re: [web2py] Re: Creating users on checkout?

auth.register On Mon, Jun 25, 2012 at 2:26 PM, RKS wrote: > Not so easy? > > -- > --

[web2py] unsigned DAL integer

Is there a way to get unsigned DAL integers ? Is there a way to represent BIGINT using DAL? --

[web2py] Re: Parsing python from db fields?

This all works, but I can't wrap my head around why everything after this snippet is no longer displayed. It does not even exist in the source. For example, my code is like this: {{import os}} {{from gluon.template import render}} {{=XML(render(bl

[web2py] Re: Parsing python from db fields?

BTW, it's EVERYTHING in html after that snippet. It won't display the footer or anything. --

Re: [web2py] Parsing python from db fields?

Both of these solutions ended up working. Passing URL and using globals(). Just wanted to let you know and say thanks for helping. --

[web2py] Re: unsigned DAL integer

> > Is there a way to get unsigned DAL integers ? > I don't think so. If you have created the table outside the DAL, perhaps telling the DAL it's a regular "integer" field will still work, though. > Is there a way to represent BIGINT using DAL? I'm not sure if this is in current stable, but

Re: [web2py] Re: Creating users on checkout?

I see that there are auth.register() and auth.login(), I'm already using login_form=auth.login(), in the controller, but otherwise I'm not certain the checkoutform would be form=auth.register(). Maybe it can be, but is that the best practice? Or just creating a function that writes into the sam

[web2py] limit to one logged user (and a single active session)

Hi, The web2py application I work on uses an API to automate another application. Only one instance of that application is allowed to initialise. therefore, at the time of login to web2py, I need to check if someone is already logged in. If so I can notify the other to wait. I thought of writi

Re: [web2py] limit to one logged user (and a single active session)

You can check the table auth_event to see if user logged in. But you will need an extra code to ensure that user logs out. On Mon, Jun 25, 2012 at 4:10 PM, Janath wrote: > Hi, > > The web2py application I work on uses an API to automate another > application. Only one instance of that applicati

Re: [web2py] limit to one logged user (and a single active session)

do you thin I can trigger an event when the session expires On Monday, June 25, 2012 2:13:23 PM UTC-5, rochacbruno wrote: > > You can check the table auth_event to see if user logged in. > > But you will need an extra code to ensure that user logs out. > > On Mon, Jun 25, 2012 at 4:10 PM, Jan

Re: [web2py] Re: Creating users on checkout?

Also, if you were to use the {{=*.custom.widget.email}} method you get errors when a logged in user is using the form. The form tries to act like a registration form instead of a checkout form. If I use things in the inputs like {{=auth.user.first_name}} it works to prefill values if users are

[web2py] Re: unsigned DAL integer

Thanks Anthony. On Monday, June 25, 2012 2:27:19 PM UTC-4, Anthony wrote: > > Is there a way to get unsigned DAL integers ? >> > > I don't think so. If you have created the table outside the DAL, perhaps > telling the DAL it's a regular "integer" field will still work, though. > > >> Is there a

[web2py] Redirecting to user/profile?

I'm having some issues I don't fully understand. I've customized an auth.login using login_form.custom.widget.email etc in a controller. It works fine and logs in users like you would expect. However, I have a view, checkout_test.html where I have included another form=auth.register() in the co

[web2py] Re: Redirecting to user/profile?

It may help if you show some code. On Monday, June 25, 2012 5:04:03 PM UTC-4, RKS wrote: > > I'm having some issues I don't fully understand. I've customized an > auth.login using login_form.custom.widget.email etc in a controller. It > works fine and logs in users like you would expect. > > How

[web2py] Re: How to effectively use the select_datewidget instead of the popup datepicker calendar !! ???

Finally, .. i got this to work in a semi satisfactory manner .. thank you Again Anthony ! For the ones who may have had or will have the same issue with the select_datewidget ! ... The idea here is 1) put the widget " def select_datewidget(field,value): " at the end of a model file (

[web2py] Re: Redirecting to user/profile?

I actually just decided that I probably just need to manually add new values to db.auth.users. That way this is actually a non-issue and I won't even need to worry about it. I think it may be harder since I don't know how to do that, especially with the checks on if auth.user or IS_IN_DB refere

[web2py] Re: Map database values to display values

On Monday, June 25, 2012 6:38:47 PM UTC+2, Anthony wrote: > > Do you already have the mapping, perhaps in a dictionary (or can you get > it into one)? If so, maybe something like: > > ISO_COUNTRY_CODE_MAPPINGS = {k: T(v) for (k, v) in original_mapping. > iteritems()} # requires Python 2.7 > > An

[web2py] Hook to automatically fill in some registration details

Hello, My application has a special requirement: the user details contain some values which should not be entered by the user, but automatically generated by the system, I am planning to add that information to the auth.settings.table_user_name. In this case the field that I am adding is:

[web2py] Reopening: problems running from subfolder with mod_wsgi

I am again running into occasional problems trying to run the trunk code from a subfolder instead of from a root folder under apache and mod_wsgi. Maybe my problem is compounded because I also have another web2py installed at the root, but it seems that some of the internal web2py functions are

[web2py] Re: Map database values to display values

> > Do you already have the mapping, perhaps in a dictionary (or can you get >> it into one)? If so, maybe something like: >> >> ISO_COUNTRY_CODE_MAPPINGS = {k: T(v) for (k, v) in original_mapping. >> iteritems()} # requires Python 2.7 >> >> I see. It is still iterating through the whole mapping

[web2py] Re: Hook to automatically fill in some registration details

You could make org_id a computed field. Or maybe set readable and writable to False and specify a default value (which can be a function). Anthony On Monday, June 25, 2012 6:29:22 PM UTC-4, Daniel Gonzalez wrote: > > Hello, > > My a

[web2py] Adding reference tables to auth

is there a way to add other tables to the current auth table setup ? I am aware of customizing existing tables but not adding tables to the database structure. e.g. Is it VALID to add other tables such at a country table and have auth_user reference this table without breaking web2py internal

[web2py] Re: Best practice using scheduler as a task queue?

This scenario is working out worse and worse. Now I'm getting tasks stuck in the 'RUNNING' state... even when there aren't any scheduler processes running behind them running! I'm guessing the server got killed mid-process, and now it doesn't know how to recover. Looks like a bug in the schedul

[web2py] Re: Best practice using scheduler as a task queue?

Er, let me rephrase: I don't recommend using the scheduler for *infinitely looping background tasks*. On Monday, June 25, 2012 4:54:30 PM UTC-7, Michael Toomim wrote: > > This scenario is working out worse and worse. > > Now I'm getting tasks stuck in the 'RUNNING' state... even when there > are

[web2py] Re: Reopening: problems running from subfolder with mod_wsgi

More info: I restart apache. Log in to admin in the subfolder version. Everything works properly. Log in to admin in the top level version. Visit the admin of the lower level version. Sometimes errors occur. Sometimes not. Sometimes it makes me log in again sometimes not. It appears that

[web2py] Re: Hook to automatically fill in some registration details

That worked, thanks. I took the computed field route. For other newbies like me, this is my code, for the time being very simple, but shows what I am doing: def reserve_org_id(row): return random.randint(0, 1) db.define_table( auth.settings.table_user_name, ... Field('org_id',

[web2py] Re: Reopening: problems running from subfolder with mod_wsgi

This error is always repeatable: The "Internal error" page always links incorrectly to the ticket. It links back to the top site. admin/default/ticket/up/10.102.67.127.2012-06-25.17-37-36.38cfaa82-a858-4e7b-9a69-9afc0fb3e7e7 If I visit the errors link normally I can see the error. --

[web2py] Re: problem with redirect using plugin_gmap

I found that I made a mistake and altered the plugin_gmap/index.html file and this is the reason things were not working. After I copied back the original plugin_gmap/index.html file from the plugin, it worked fine. I did have to add a {{pass}} like so for it to work and I don't understand th

[web2py] How capable is the ajax function in web2py.js?

Hello, Currently I have a pyjamas application doing some JSONRPC requests to web2py, in order to update a quite complex HTML table (6 columns, 20 rows, the markup in the cells is quiet complex, with images and nested td/tr elements). The pyjamas application is embedded into my web2py pages ins

[web2py] Dashboard in web2py?

I'm taking the first steps in web2py but I have a question that for me is very important as to continue or not with web2py. Does web2py have a admin dashboard as Wordpress, Textpattern, etc, so the client can update the site like they will normally do in a cms?? I know web2py it's not a CMS, but

[web2py] Distinct in Autocomplete widget select

Hi, I noticed the Autocomplete widget in gluon/sqlhtml.py does not support the distinct value for the select query. In a project I was working on instead of creating a new category like table I modified the sqlhtml.py to allow for setting a distinct value (default is false) attached is a patch

[web2py] web2py DAL, migration

Hi, I got web2py dal very wired problem. I follow that link. http://vimeo.com/23145118 db.define_table('stock_price2', Field('symbol'), Field('price', 'double'), Field('price_change', 'double'), ) Accidentally, i type chnage in the last field name. So I want to change it back to "change

[web2py] Adding a field in a table

Hi all, I am a GSOC student developer for Sahana Eden, a web2py based disaster management Application . I was trying to *add a field in the already defined table* *through DAL object* . The table also has some records in it . I don't want to use sql as this script might be used by many developer

[web2py] Re: Best practice using scheduler as a task queue?

I see Rails is adding some sort of queue: http://news.ycombinator.com/item?id=3899080 --

[web2py] Re: How capable is the ajax function in web2py.js?

> > >1. I do not want to reload pages: everything needs to work smoothly as >a desktop app. (of course, not all interactions with web2py, just the ones >related to this one real-time component). I guess the right tool for this >job would be the ajax function in web2py.ps. Is thi

[web2py] which files are checked for menu?

Hi! I'm studying hard. I will change the menu in the top of the screen. There are some menus like Login, Lost Password. But unhappily there are no menu.py ( in models directory). I want to change the menus including some others like the Login, Lost Password, Register etc.. Which files wil

[web2py] Re: web2py DAL, migration

You cannot change a field name. Changing a field name will be interpreted as the previous field being deleted and a new field with the new name bing created. In your case this worked when you replace change with chnage. When you changed it back to change it should have worked too. What error

[web2py] Re: Adding reference tables to auth

You can defined your own auth_user before auth.define_table and your own will be used. Or you can use auth.settings.extra_fields['auth_user'] = [Field(...),Field(...),Field(...), ... ] before auth.define_tables() On Monday, 25 June 2012 18:43:33 UTC-5, Horus wrote: > > is there a way to add ot

[web2py] Re: Dashboard in web2py?

web2py does not. You need to add a CMS to web2py. You can look into InstantPress or Movuca or cube2py. On Monday, 25 June 2012 19:31:25 UTC-5, Paulo Couto wrote: > > I'm taking the first steps in web2py but I have a question that for me is > very important as to continue or not with web2py. > Do

[web2py] Re: which files are checked for menu?

The scaffolding application uses views/layout.html which displays {{=MENU(response.menu)}} on the left and {{=auth.navbar()}} on the right. response.menu contains the menu items defined in modes/menu.py The auth.navbav() returns a helper object. You cannot alter it but you can defined your own

[web2py] invalid literal for int() with base 10: ''

I am currently getting this error working with DAL based on db.define_table('base_tags', Field('name', 'string', length=64, required=True, notnull=True), format='%(name)' ) db.define_table('base_timezones', Field('name', 'string'

[web2py] Re: Distinct in Autocomplete widget select

Thank you! It is now in trunk. On Monday, 25 June 2012 15:08:02 UTC-5, Brent Zeiben wrote: > > Hi, > I noticed the Autocomplete widget in gluon/sqlhtml.py does not support the > distinct value for the select query. In a project I was working on instead > of creating a new category like table I

[web2py] Re: Adding reference tables to auth

I saw that in the documentation. Can auth_user reference a table I create? so... auth.settings.extra_fields['auth_user']= [ Field('timezone_id',db.base_timezones), Field('type_id',db.base_types), Field('sex_id',db.base_sexes), Field

[web2py] Re: invalid literal for int() with base 10: ''

additional info... Function argument list (self=, table=, 'id': }>, migrate=True, fake_migrate=False, polymodel=None) Code listing 628. 629. 630. 631. 632. 633. 634. 635. 636. 637. foreign_key=referenced + ('(%s)' % id_fieldname), o

[web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

Hello web2py users, I have made a quick sign up form using SQLFORM.factory, all the data entered on the various fields of the form are validating correctly, my error msgs are poping up the way I want ( and not into the form ) My SQLFORM.factory in the controller index file goes like this ( I hav

Re: [web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

if form.process().accepted: db.auth_user.insert(**form.vars) response.flash = T('Quick Sign-up Accepted ! - Check your e-mail !') --

[web2py] Re: Adding reference tables to auth

I believe that should work. Anthony On Monday, June 25, 2012 10:41:48 PM UTC-4, Horus wrote: > > I saw that in the documentation. Can auth_user reference a table I create? > so... > > > auth.settings.extra_fields['auth_user']= [ > Field('timezone_id',db.base_timezones), >

[web2py] Re: web2py DAL, migration

Hey thanks you so much. I guess it is mysql wired thing. keyword reserve. But sometimes it does work. sometimes it does not. ^_^ --

[web2py] Authentication

I got following issue with web2py Authentication. I have to authenticate through URL "http://www.example.com/something/q?ID='username'&pass='password'" It return true or false. I cannot go and change it. And I have to do authentication with it for sure. After I got true or false, I would like

[web2py] Re: invalid literal for int() with base 10: ''

In all your table definitions you have format='%(name)' except in base_countries table, where you have format='%(name)s'. I don't understand the trace back, the error is caused by format='%(name)s', which is what I have in my table definitions, and which doesn't cause any errors. Kind regards

[web2py] ldap

from gluon.contrib.login_methods.ldap_auth import ldap_auth auth.settings.login_methods = [ldap_auth(mode='ad', server='abc.google.com', base_dn='ou=Users, dc=google,dc=com')] I am having the following error. File "gluon/contrib/login_methods/ldap_auth.py", line 9, in ImportError: No module n