[web2py] How to create patch for welcome app?

2010-02-08 Thread Alex
I've changed models/menu.py of welcome application This is original code: ... response.menu_edit=[ [T('Edit'), False, URL('admin', 'default', 'design/%s' % request.application), [ [T('Controller'), False, URL('admin', 'default', 'edit/%s/controllers/default.py' \

[web2py] Re: How to create patch for welcome app?

2010-02-09 Thread Alex
x27;, 'default', 'edit/%s/controllers/%s.py' \ % (request.application,request.controller=='appadmin' and 'default' or request.controller))], On 9 фев, 01:31, mdipierro wrote: > Accepted and in trunk! Thank you. > > On Feb 8, 3:41 pm, Alex w

[web2py] Toggle on/off editarea on startup

2010-02-20 Thread Alex
I have added DISPLAY parameter in web2py\applications\admin\models \0.py It helps to manage mode of web2py built in code editor on page startup. It is usefull with Its All Text Firefox plugin which allow to edit context of textareas in your favorite editor. UliPad for example) This plugin work well

[web2py] Re: Toggle on/off editarea on startup

2010-02-22 Thread Alex
Hi, again. I still need the advice ) -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more optio

[web2py] Re: Toggle on/off editarea on startup

2010-02-26 Thread Alex
omething you would > have to edit admin application automatically just to set the option to > "later". > > I +1 this patch, since it looks to be a useful addition for those who > use the built-in editor. > > -Thadeus > > > > On Thu, Feb 25, 2010 at 1:04 PM,

[web2py] Database JOIN on more than 2 tables

2010-10-04 Thread Alex
Hello, I was wondering what the syntax was to do a SQL JOIN on more than 2 tables. I understand the syntax for 2 tables is: db(db.table1.col == db.table2.FKcol).select() What if I want to JOIN the above resultset with more tables? I tried nesting the statements like: db(db(db.table1.col == db

[web2py] Re: How to loop through two items

2010-10-04 Thread Alex
I'm not quite sure what you are trying to accomplish - but it sounds like you have 2 result sets from the database and you want to show values from both? If so, you can always run two seperate loops and concatenate the values into strings and then display the final string with what you want. If t

[web2py] Re: Database JOIN on more than 2 tables

2010-10-04 Thread Alex
Thank you very much! So obvious (as it always is once you see the answer) :). Thanks again! On Oct 4, 12:50 am, annet wrote: > Hi Alex, > > Here's how you join more than two tables in web2py: > > db((db.table1.col == db.table2.FKcol)&(db.table1col == > db.table

[web2py] Re: redirection question

2010-10-04 Thread Alex
Have you thought about maybe looking into the AJAX calls that are available? That way, the page won't postback. You can call a controller to do whatever you need with the data from the form. Otherwise, I can't see an easy way without somehow saving the state of where the page was called from (me

[web2py] Accessing COUNT column from DAL row

2010-10-13 Thread Alex
Hello, I have a query that does a select and COUNT on my model. I wish the present the COUNT value of each row on the view but am having trouble figuring out the syntax for doing this. I have a for loop, iterating through each row in the resultset and tried to follow the example in the book, by

[web2py] Re: MENU issues ...

2010-10-13 Thread Alex
Hello, I can try to answer your first 2 questions: 1. It looks like the parameters are (based on the example in the book): - 1st parm (Item Text - 'One'): The text you want to show for the item, so the list item will render with the text of: One - True | False: True means that web2py will app

[web2py] Re: Accessing COUNT column from DAL row

2010-10-14 Thread Alex
y) return dict(rankings = rankings) On the view I just want to get to reference/display the count column in each row. Thanks! On Oct 14, 12:32 am, mdipierro wrote: > show us the query. > > On Oct 13, 10:47 pm, Alex wrote: > > > > > Hello, > > > I have a que

[web2py] Re: Accessing COUNT column from DAL row

2010-10-14 Thread Alex
You just want > > for row in rows: print row.auth_user.first_name, row(count) > > On Oct 14, 6:17 am, Alex wrote: > > > > > Sure thing. > > > I have something like: > > >     count = db.game_session.createdBy.count() > >     rankings = db((db.game_

[web2py] Re: labels in crud.select

2010-10-14 Thread Alex
Are you trying to display a more user friendly column name rather than the DB column name? If so, you can do this already. The crud.select() has a method called "field_labels", which takes a dictionary of field names to their labels. http://www.web2py.com/book/default/chapter/07#Methods crud.se

[web2py] Re: Accessing COUNT column from DAL row

2010-10-14 Thread Alex
rror. Am I still missing something? On Oct 14, 9:53 am, Alex wrote: > Ahh thank you very much.  I'll give it a try.  If this is the case, > then I believe the syntax example in the book/online is incorrect. > > Chapter 6 - DAL - Grouping and Counting section > > The boo

[web2py] Re: Accessing COUNT column from DAL row

2010-10-14 Thread Alex
print row > > before the =row(count) line and see what the structure of the row > looks like from the console. > > It might be row['count'] depending on how your data is structured. > > On Oct 14, 5:20 pm, Alex wrote: > > > > > Hmm, I gave it a try o

[web2py] Re: dealing with extra clicks on a link

2010-10-15 Thread Alex
Hello, I was going to do something similar with some 2 players games (which I have yet to implement), but was planning on doing the polling on the client-side with Javascript and AJAX. There is a function in Javascript: window.setTimeout(jsFunctionToRun, timeToRunInMilliseconds); That can be

[web2py] Re: labels in crud.select

2010-10-15 Thread Alex
use... I try with 1.83.2 and 1.87.3. > > I try with fields=['myfield1','myfield2'] and without it always > with  field_labels and also with and > without headers='fieldname:capitalize'... > > Is it a issue? > > Richard > > > > On Thu,

[web2py] Re: labels in crud.select

2010-10-15 Thread Alex
t'},headers='fieldnam­e:capitalize') > > selected=crud.select(table,fields=['field1'],field_labels={'field1':'abc'},­headers='fieldname:capitalize') > selected=crud.select(table,fields=['field1'],field_labels={'field1&#x

[web2py] Re: labels in crud.select

2010-10-18 Thread Alex
No problem. The fields attribute shouldn't affect the headers attribute and vice versa. You should be able to hide columns with the Fields attribute. Good luck! On Oct 18, 11:13 am, Richard Vézina wrote: > Ok! > > It works, thanks Alex > > I will have much more work s

[web2py] Re: DAL and relations

2010-10-21 Thread Alex
It's because since your images have a reference now to your albums - that means an album can have many images. So for every record in your album table, it gets a new attribute for the image. Take a look in the book at section 6.20. It explains it there. On Oct 21, 9:40 pm, iu_long wrote: > I a

[web2py] Re: readable=False not working with crud.select(db.table)

2010-10-21 Thread Alex
It looks like you are using the CRUD API. I think the readable attribute only applies to the SQLFORM API (if you change your controller to return a SQL form, it'll not show the column). For CRUD, there is a "fields" attribute you can supply to explicitly say what fields you want to show. Just us

[web2py] Re: Selecting from dropdown using Ajax

2010-11-08 Thread Alex
How are you passing the value in the request.vars? I'm going to guess that on your AJAX call in the _onChange handler, you want to specify the parameters. You can do something like: - ajax( '{{=URL(c='controllerName',f='test_chg', args=request.args(0))}}', ['firmdrop'],'target' ) You can pass

[web2py] Re: Using the results of a select/option in a query

2010-11-09 Thread Alex
You should be able to access the variables passed by your form through: request.vars ex. Given a form with this control: You can access this in the controller through: request.vars.chatText On Nov 9, 6:04 pm, Lorin Rivers wrote: > OK, I answered my own question from before. > > I now have i

[web2py] Re: Not getting a result from query

2010-11-09 Thread Alex
Are you sure there are records coming back? Try doing a "print records" and make sure data is coming back. Sounds like it just may be an empty result set from the query. On Nov 9, 6:50 pm, Lorin Rivers wrote: > I think I'm close: > given this controller > > my_macaddr = db4().select(db4.data_ta

[web2py] Re: Selecting from dropdown using Ajax

2010-11-09 Thread Alex
;);", What this does is on the onChange event, it will populate the hidden input we added with the selected option's value. This is then passed through the AJAX call. Hopefully this helps. Let me know :) On Nov 9, 8:28 pm, oneroler wrote: > Alex, > > Thanks.  I thought bas

[web2py] Authentication and multiple logon sessions

2010-11-11 Thread Alex
Hello, I have a question regarding how the authentication defines each unique user session. I am working on an app that uses the authentication and was trying to test with multiple users logged onto my site. My test is opening IE and logging onto the site as one user, then opening a new IE insta

[web2py:33406] Are Content Internationalization and event framework missing?

2009-10-22 Thread Alex
Hello All, web2py looks very intersting framework, just bought a manual in pdf today. But in comparision with Django 2 nice things are missed: 1. Content Internationalization (automatic handling blog-posts in several languages) 2. Events framework - that allows cross-apps event notification an

[web2py:35764] IS_IN_DB - Label

2009-11-21 Thread Alex
It is possible to use several items in IS_IN_DB label, but how to use column name from refrence table? For example 3 tables: type_class (type_class_name) type (type_class_id, type_name) detail (type_id, detail_name) I can do for "requires" in detail table this: requires=IS_IN_DB(db, 'type.id',

[web2py:35968] The same controller method for ajax and nonajax call

2009-11-24 Thread Alex
Hello, I have "get_workout" action in controler and this action could be called either directly using GET method, or could be called using AJAX. If it's called using GET it should return (render) whole page. If it's called using AJAX it should return (render) only a part of the page It's not cl

[web2py:35970] Re: The same controller method for ajax and nonajax call

2009-11-24 Thread Alex
t; so > > http://mysite.com/init/default/index/for normal pages > > http://mysite.com/init/default/index.json/to get the dict converted to json > > or > > index.xml to get it in xml format.. > > -Thadeus > > > > On Tue, Nov 24, 2009 at 10:06 PM, Alex wrote: > &g

[web2py:36002] Re: The same controller method for ajax and nonajax call

2009-11-25 Thread Alex
needed :) On Nov 25, 6:42 am, "mr.freeze" wrote: > Send a var back with the ajax request: > > > {{=a.title}} > > if request.vars.is_ajax: >     > > On Nov 24, 10:14 pm, Alex wrote: > > > > > But how can controller method know if current request

[web2py:36115] domain hostname in routes.py

2009-11-28 Thread Alex
Hello, I want to run one web2py instance where each web2py application will be mapped to different domain and with ability to map some urls differently in different domains. I tried to edit routes.py but without success. Can anyone show examples of such routes.py? Thanks. -- You received this

[web2py:36117] Re: domain hostname in routes.py

2009-11-28 Thread Alex
e: > You can but strongly suggest you use virtual hosts in apache + > mod_wsgi + mod_rewrite. It will give you more flexibility in the long > run. > > Massimo > > On Nov 28, 10:31 am, Alex wrote: > > > > > Hello, > > > I want to run one web2py instance wh

[web2py:36120] Omit default controller for for any action

2009-11-28 Thread Alex
Is there any way to omit default controller name in URL if there is appropriate default controller action, like it's done for index action but to work for any default controller action? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to

[web2py:36158] Re: Omit default controller for for any action

2009-11-29 Thread Alex
n Nov 29, 5:35 am, Iceberg wrote: > On Nov29, 2:11am, Alex wrote: > > > Is there any way to omit default controller name in URL if there is > > appropriate default controller action, like it's done for index action > > but to work for any default controller action? >

[web2py:36223] Unicode error using mail.send() from tools.py

2009-11-30 Thread Alex
mail.send(\'m...@gmail.com\', \'subject\', body)\n File "/var/www/ web2py/gluon/tools.py", line 271, in send\nattachment.attach (email.MIMEText.MIMEText(text.encode(encoding)))\nUnicodeDecodeError: \'ascii\' codec can\'t decode byte 0xd0 in position 30: ordinal not in range(128)\n' This erro

[web2py:36225] Re: Unicode error using mail.send() from tools.py

2009-11-30 Thread Alex
ason is because there are non-latin characters in the text body. > > Where are you getting your data source? Is it possible to use UTF-8 encoded > characters instead of ASCII? > > Are you attempting to pass a different encoding scheme to the Mail object? > > Can we get some co

[web2py] SQLFORM upload field like in appadmin

2010-01-26 Thread Alex
When I update record with upload field using database administration tool of admin interface, loaded image file into this upload file is shown with thumb, link to file and delete checkbox. When I try to update this record in my controller, I see input field with browse button only. Please, suggest

[web2py] Re: SQLFORM upload field like in appadmin

2010-01-26 Thread Alex
Wow! It works. Thank you. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit t

[web2py:14083] How to link CAS user id's with records from other DB.

2008-12-23 Thread Alex
Hello! I'm writing application which just set of memos for users, how can I be sure what user see/edit only his personal messages? Considering table structure like this dba.define_table('services', SQLField('memo'), SQLField('remind_interval'), SQL

[web2py:14274] Postgres error

2008-12-29 Thread Alex
Hello! I got error message with postgress: Traceback (most recent call last): File "/home/alex/web2py/gluon/restricted.py", line 62, in restricted exec ccode in environment File "/home/alex/web2py/applications/monitoring/models/db.py", line 25, in SQLFi

[web2py:14277] Re: Postgres error

2008-12-29 Thread Alex
So only solution to rename tables and fields everywhere ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from

[web2py] User Login/Logout authentication event

2010-11-12 Thread Alex
Hello, I have a question regarding authentication. I would like to find a way to do certain events (ie. store stuff in the cache, update a last login time in the DB, etc.) when a user logs in and logs out. I'm currently just using the built in "auth" object and was wondering if there was a simp

[web2py] Re: User Login/Logout authentication event

2010-11-12 Thread Alex
Excellent! Thanks! On Nov 12, 11:51 am, mdipierro wrote: > auth.settings.login_onaccept=lambda form: do_something(form) > > same with logout, etc. > > On Nov 12, 11:50 am, Alex wrote: > > > > > Hello, > > > I have a question regarding authentication

[web2py] Re: web2py 1.89.1 is OUT... update?

2010-11-12 Thread Alex
Maybe a bug? When I create a .LOAD component, the save doesn't seem to work in IE or Firefox. On Nov 12, 10:44 pm, mdipierro wrote: > The fact is after you upgrade you get the new admin which uses a new > API function. Unless you restart the server that API function is not > available. This is a

[web2py] Re: TOP10 list

2010-11-23 Thread Alex
Depending on how complicated the calculation is, you can *may* be able to do the calculation in the DAL. If it's just a simple sum, you can use SUM(), then then orderby descending the SUM() amount and limitby=(0,10). Otherwise, you could always create a sorted List and as you iterate through each

[web2py] SQLFORM.grid custom search where is the error?

2012-09-27 Thread alex
I have this table db.define_table('t', Field('a', type='string'), Field('b', type='string'), ) db.t.insert(a='US', b='Washington') db.t.insert(a='US', b='Rochester') db.t.insert(a='US', b='Los Angeles') db.t.insert(a='US', b='Minneapolis') Now I want to search the items in a grid wit

Re: [web2py] SQLFORM.grid custom search where is the error?

2012-09-28 Thread alex
ersion maybe it is easier to understand what happens. Thank you anyway. Alex On Friday, September 28, 2012 3:45:25 PM UTC+9, Johann Spies wrote: > > On 28 September 2012 07:15, alex > wrote: > >> >> What am I doing wrong? >> > > A good way to learn this q

Re: [web2py] SQLFORM.grid custom search where is the error?

2012-09-28 Thread alex
e latest trunk? > > On Friday, 28 September 2012 04:36:26 UTC-5, alex wrote: >> >> Thank you Johann, of course I did already, >> >> The query itself gets translated correctly. >> I think that something very subtle is happening when I pass search_widget >> =sear

Re: [web2py] Re: data source configuration

2012-04-04 Thread Alex
, log settings and so on for testing, development and production environment (and of course you could use your own environment, e.g. customer specific). Alex Am Mittwoch, 4. April 2012 04:04:08 UTC+2 schrieb Anthony: > > thanks for the cache info. I think that's the way to go f

Re: [web2py] Re: data source configuration

2012-04-05 Thread Alex
e.g. connection = cache.get_configuration_property('dbconnection') if not added to the cache a global application object would probably be necessary. Am Donnerstag, 5. April 2012 00:48:24 UTC+2 schrieb Anthony: > > Do you have a proposal for how web2py should do this? > > On Wednesday, April

Re: [web2py] Re: data source configuration

2012-04-06 Thread Alex
ar with modules)? does this also work with compiled applications? and with (external) cron jobs? Alex Am Freitag, 6. April 2012 07:40:57 UTC+2 schrieb Anthony: > > Can't you just create a regular Python module, store the settings in > there, and import the module in your ap

Re: [web2py] Re: data source configuration

2012-04-06 Thread Alex
thanks, Anthony. In case that's the way to go: could this be added somewhere to the official documentation? I think that's really important and it is not obvious for non-python-experts (like me). Alex Am Freitag, 6. April 2012 15:44:43 UTC+2 schrieb Anthony: > > could you

[web2py] compatibility issue

2013-03-10 Thread Alex
am = pjoin(file_properties['path'], name) previously this was stream = open(pjoin(file_properties['path'], name), 'rb') now my code does not work anymore. I assume the missing open call is a bug, right? Alex -- --- You received this message because you are subscribed to

[web2py] bug with onvalidation argument in form.accepts

2013-03-10 Thread Alex
ame and not status: This bug already exists for a long time (at least since 1.99.2). Is there any chance it gets fixed? thanks, Alex -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving

[web2py] Re: compatibility issue

2013-03-10 Thread Alex
schrieb Massimo Di Pierro: > > Can you check is the current trunk works for you? We are trying to improve > the APIs of retrieve. > > On Sunday, 10 March 2013 13:58:23 UTC-5, Alex wrote: >> >> I'm currently using web2py 2.1.1 and wanted to try 2.4.2 but I got a >>

[web2py] Re: compatibility issue

2013-03-10 Thread Alex
am). There was only one trunk version that did that. It was reverted > because of caching concerns. The current trunk version is another > experiment. These are tests. This is not the standard behavior. I am glad > it now works as you expect but it not decided it is going to stay this w

[web2py] Re: compatibility issue

2013-03-10 Thread Alex
great, I almost got confused. current trunk looks fine to me :) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For mo

[web2py] db column comment

2013-03-12 Thread Alex
2=success') So I'm somehow misusing the comment argument for my internal documentation (I don't use the autogenerated forms). It would be very useful to have an argument like dbcomment for the Field class. Alex -- --- You received this message because you are subscribed t

Re: [web2py] db column comment

2013-03-12 Thread Alex
otten (and thus leads to outdated comments in my code or db). if I understood you correctly there is no way to set the db column comment with web2py at the moment? thanks, Alex -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group.

Re: [web2py] db column comment

2013-03-12 Thread Alex
> On Tuesday, March 12, 2013 3:22:22 PM UTC+1, Alex wrote: >> >> actually I don't need the comment in the backend but I want to comment my >> code. Often it is useful for me to have the comment in the db as well. >> When I add or change a comment in my code I also

Re: [web2py] db column comment

2013-03-12 Thread Alex
Richard, this sounds interesting but I did not fully understand what you're doing. Some code would probably help. thanks, Alex Am Dienstag, 12. März 2013 16:24:06 UTC+1 schrieb Richard: > > Alex, > > Maybe you could be interested to know how manage labels, comments, etc. >

[web2py] Re: Is this a bug? DAL update records using an expression

2013-03-12 Thread Alex
== id).update(minutes_done = db.client_service.minutes_done + minutes) as a workaround. that makes the code much harder to read. I see no reason why the first query should not be possible. Any chance this will be fixed? Alex Am Mittwoch, 6. März 2013 19:30:22 UTC+1 schrieb Cliff Kachinske: >

[web2py] Re: Is this a bug? DAL update records using an expression

2013-03-14 Thread Alex
I just opened a bug report (Issue 1391). Alex Am Donnerstag, 14. März 2013 13:56:34 UTC+1 schrieb LightDot: > > This probably breaks quite a few apps out there? It did one for us. > > Did anyone open a bug report? > > Regards, > Ales > > On Wednesday, March 13, 2013 1

Re: [web2py] db column comment

2013-03-18 Thread Alex
Richard, thanks for sharing! Although I don't see how that would help in my case (I'd still have to comment the field in my db.py file) it's good to see some new approaches. Alex Am Donnerstag, 14. März 2013 15:08:39 UTC+1 schrieb Richard: > > Hello Alex, > > Here w

Re: [web2py] Re: Web2Py support on roadmap for pycharm 3

2013-03-26 Thread Alex
awesome :) desperately waiting for a good IDE with web2py support. what are currently the best options for debugging web2py applications? I'm using Komodo Edit which is quite nice - is it possible to easily debug a web2py application with Komodo IDE? Wing IDE seems to support debugging but the

[web2py] how to .represent a calculated field in SLQTABLE

2012-09-29 Thread alex
In a controller I have this: fields=[db.table.id.count()] columns = [str(db.table.id.count())] headers = {str(db.table.id.count()):'Total recs',} rows=db(qry).select(*fields) t=SQLTABLE(rows, columns=columns, headers=headers) How can I use .represent on the calculated field db.table.id.count()

[web2py] Re: SQLFORM.grid custom search where is the error?

2012-09-29 Thread alex
h')) if form.process().accepted: qry=search_query(form.vars.search) fields=[db.t.a, db.t.b] table=SQLFORM.grid(qry, fields=fields, field_id=db.t.id,searchable=False ) return locals() index.html {{extend 'layout.html'}} {{=form}} {{=table}} On Friday, Sept

[web2py] Calculated field in SQLFORM.grid

2012-09-29 Thread alex
I have a relation [1:n] from table A to table B. define_table('A', Field('name', type='string')) define_table('B', Field('ref_a', type='reference A')) Then I have this grid qry = db.A.id>0 grid = SQLFORM.grid(qry,links=links) How do I write links (and the lambda function in it) in order

Re: [web2py] Re: Calculated field in SQLFORM.grid

2012-10-01 Thread alex
at 9:26 AM, Massimo Di Pierro > > > wrote: > >> This is currently not possible unless you denormalize and store the count >> in a column of A. >> >> >> On Saturday, 29 September 2012 23:01:22 UTC-5, alex wrote: >>> >>> >>> I ha

[web2py] Re: SQLFORM.grid custom search where is the error?

2012-10-03 Thread alex
7;re really not even using the grid search then. You're controlling > the entire search form and placing it on the page in your view, right? > > -Jim > > On Saturday, September 29, 2012 9:52:25 PM UTC-5, alex wrote: >> >> I found the way to bypass the problem. >>

[web2py] Re: Adding to derived smartgrid constraints.

2012-10-03 Thread alex
I had a slightly different case, maybe useful to share. I had a table "model" with two references to "make" and I wanted the models in the grid, but filtered by one of the two referenced fields of the "make" table. db.py db.define_table('make', Field('name')) Make_one = db.make.with_alias(

[web2py] SQLFORM.grid dinamically update fields

2012-10-03 Thread alex
I have a SQLFORM.grid. When the user updates field 'a' in the grid, before submitting the form, field 'b' should represent a calculation based on value of 'a'. For instance b=a+1 db.py db.define_table('t', Field('a', type='integer'), Field('b', type='integer') ) default.py def index

[web2py] Re: SQLFORM.grid dinamically update fields

2012-10-04 Thread alex
rm.custom.widget.b}} {{=grid.update_form.custom.submit}} {{=grid.update_form.custom.end}} {{else:}} {{=grid}} {{pass}} On Thursday, October 4, 2012 9:49:27 AM UTC+9, alex wrote: > > > I have a SQLFORM.grid. > When the user updates field 'a' in the grid, before submitting the form, > fiel

[web2py] Re: How show a menù for user logged in and of a specified group

2012-10-05 Thread alex
if auth.is_logged_in() and (auth.has_membership('Public') or auth. has_membership('Admin')): response.menu.append((T('Home'),URL('default','index')==URL(),URL('default' ,'index'),[])) if auth.is_logged_in() and auth.has_membership('Admin'): response.menu.append((T('Home'),URL('default','index')

[web2py] Re: SQLFORM.grid dinamically update fields

2012-10-05 Thread alex
val()}, dataType: 'json',success:function(result){ $("#t_b").val(result.two); }}); }); }); {{=grid}} In controller function "do_this" I can perform all the database lookup I need, based on the values passed by the ajax call. On Thursday, October 4, 20

[web2py] How to attach an onclick event to a custom form field?

2012-10-08 Thread alex
I have this custom form: {{=form.create_form.custom.begin}} {{=*form.create_form.custom.widget.field*}} {{=form.create_form.custom.submit}} {{=form.create_form.custom.end}} how do I attach an event "onclick" to the widget 'field", to obtain this? --

[web2py] Re: How to attach an onclick event to a custom form field?

2012-10-08 Thread alex
a problem with firefox 15.0.1. Firefox was expecting a lost focus event, while with chrome opera safari also the event $("#form_field").change was accepted. On Monday, October 8, 2012 6:29:28 PM UTC+9, alex wrote: > > I have this custom form: > >

[web2py] pack application from other script

2011-12-11 Thread Alex
t? another question: the packed application also contains the folders databases, cache etc. How does this work when the application is installed on the server? are these folders simply ignored? thanks, Alex

[web2py] Re: pack application from other script

2011-12-16 Thread Alex
no ideas? maybe there is a way to pack the application from the command line? I could also call this from my python script. On 11 Dez., 15:12, Alex wrote: > I have a python deployment script where I update the build info (build > nr., build date), compile the application, pack it and f

[web2py] pack application

2012-01-09 Thread Alex
he request object so I don't know how I can call it. Please also let me know In case it is not possible so I don't spend more time searching for possible solutions. Alex PS: I already asked this question 1 month ago but did not get any answers, I hope it's ok to try again.

[web2py] Re: pack application

2012-01-09 Thread Alex
thanks! do I really need everything in the archive or would the directories 'compiled' and 'static' be enough? On 9 Jan., 22:21, Massimo Di Pierro wrote: > cd applications/app > tar zcvf web2py.app.name.w2p * > > On Jan 9, 1:39 pm, Alex wrote: > > > &

[web2py] Re: error class proposal

2012-01-17 Thread Alex
I've created a function getFormFields which I call for every form I'm using. In this function I go through all inputs of the form with form.elements('input, select, textarea') and then I check if the name of the input field exists in form.errors. If there is an error I add a css error class. At th

[web2py] config file - configuration per environment

2012-03-17 Thread Alex
Hi, what is the best way to have settings depending on the environment? I know this question has been asked a couple of times before but I could not find any useful answers. I want to run multiple instances of my application for multiple customers, which also means a different db connection for e

[web2py] Re: config file - configuration per environment

2012-03-18 Thread Alex
; I use SQLite for configs > > http://zerp.ly/rochacbruno > Em 17/03/2012 21:26, "Alex" escreveu: > > > > > > > > > Hi, > > > what is the best way to have settings depending on the environment? I > > know this question has been asked a

[web2py] data source configuration

2012-03-30 Thread Alex
a workaround for me? I have some ideas but nothing seems to be optimal. I'd prefer to avoid dirty hacks... thanks, Alex

[web2py] Re: data source configuration

2012-03-30 Thread Alex
t it to new records. > Effectively, this means every record in a table with such a field will only > be seen when the default value of the field in this request is the same as > when it was generated. (You can still get all records by either setting the > default to None, or addi

Re: [web2py] Re: data source configuration

2012-04-03 Thread Alex
ing why such an essential feature is missing... Alex Am Montag, 2. April 2012 22:01:08 UTC+2 schrieb Derek: > > @cache('key', 5000, cache.ram) > > > that's how you cache it... > > > > On Monday, April 2, 2012 1:53:15 AM UTC-7, Carlos Correia wrote: >> >

[web2py] problem with updating Form with writable=False Fields

2011-09-17 Thread Alex
ds[field.name] = self.record[field.name] elif self.table[field.name].default!=None: fields[field.name] = self.table[field.name].default why is it checking writable==False? shouldn't it test for writable==True or do I get something wrong here? Alex

[web2py] Re: problem with updating Form with writable=False Fields

2011-09-17 Thread Alex
d.password = '' the form.accepts tries to update all fields. But I would only like to update the password field and not modify any other fields. On 17 Sep., 17:46, Alex wrote: > Hi, > > first of all, many thanks to Massimo and all other contributers. > web2py is an amazing

[web2py] Re: problem with updating Form with writable=False Fields

2011-09-17 Thread Alex
e sql statement? On 17 Sep., 17:54, Alex wrote: > I forgot to mention the following: I create the row myself because I > simply want to change the password: > id = auth.user_id > record = Row() > record.id = id > record.password = '' > > this row is then passed to S

[web2py] Re: problem with updating Form with writable=False Fields

2011-09-21 Thread Alex
chieve only an update of setting1? On 18 Sep., 04:59, Massimo Di Pierro wrote: > Why not just do? > > auth = Auth() > auth.settings.extra_field['auth_user'] = [] > auth.define_tables() > > On Sep 17, 10:46 am, Alex wrote: > > > > > Hi, > > &

[web2py] error referencing table with custom primarykey

2011-09-22 Thread Alex
notnull=True)) I'm using a different solution now so this is not a problem for me anymore. I just wanted to mention it since it seems to be a bug. It was working with a web2py version from January, when I updated it in June it didn't work anymore (I don't know the exact version numbers anymore). I'm using PostgreSQL. Alex

[web2py] Re: error referencing table with custom primarykey

2011-09-22 Thread Alex
still the same. I opened an issue, #440 On 22 Sep., 18:16, Massimo Di Pierro wrote: > can you try 1.99.1 and if still does not work open an issue? Thanks > > On Sep 22, 11:11 am, Alex wrote: > > > > > Hi, > > > this table definition causes an error: > >

[web2py] Re: problem with updating Form with writable=False Fields

2011-09-23 Thread Alex
could someone confirm if that is a bug? or explain to me why it's behaving that way. I would like to know if I could expect a bug fix anytime soon (in case it's a bug), if not I will make a workaround and create the update statement on my own in that case. On 21 Sep., 21:25, pbreit wrote: > I gue

[web2py] Re: problem with updating Form with writable=False Fields

2011-09-23 Thread Alex
thanks for the response! I already thought about using dbio=False parameter, with the update_record method this should now be quite easy. explanation why it's important for me: in my scenario the auth_user table has many additional fields (address, bank account information, etc.), all these settin

[web2py] Re: Clean up unused string

2011-09-27 Thread Alex
I guess it should be quite easy to write a script which scans all the py files for labels and compares them with the labels from the translation file. Maybe a script like this already exists? Alex On 27 Sep., 21:29, Richard Vézina wrote: > What do you mean, the untranslated yellow backgro

[web2py] authentication question

2011-09-27 Thread Alex
401 error page? (to display a nice page instead of just the error message) or should I do something different than raising the http error? the error can only occur if the user manipulated the url. Alex

[web2py] Re: authentication question

2011-09-29 Thread Alex
thanks, I know about this option. I use it when I just test for a role, I guess requires_login can be omitted in this case. I've seen that I can use routes_onerror in routes.py to define custom error pages for http errors and all other errors. I tested it successfully, works great!

  1   2   3   4   5   6   7   8   9   10   >