[web2py] Re: help with helper!

2014-05-14 Thread Joe Barnhart
I see you're using font-awesome. You need to add "fa" as well as the icon name you want "fa-home". I also recommend you use the URL helper if you ever want the url re-writing features of web2py. My recommendation is: A(I(_class="fa fa-home"),SPAN("Home",_class="menu-item-parent"),_href=URL( '

Re: [web2py] help with helper!

2014-05-14 Thread Carlos Costa
Are you using it in the MENU helper? 2014-05-14 20:14 GMT-03:00 greenpoise : > I tried this but didnt work. I am using it in the menu section > > > Thanks > > > > On Wednesday, May 14, 2014 3:59:19 PM UTC-7, yamandu wrote: > >> Like this >> >> A(I(_class="fa-home"),SPAN("Home",_class="menu-item-

[web2py] why huge memory requirment

2014-05-14 Thread Bapi Roy
Why web2py application take 420 MB to run one instance in ningx server . I am using Cloud VPS from Digital Ocean with 512 MB RAM. I used https://code.google.com/p/web2py/source/browse/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh script to run web2py app.  -- Resources: - http://web2py.com - h

[web2py] Help with a helper!

2014-05-14 Thread Danel Segarra
I cant get this one: Home I have this so far: [A(I(SPAN(_class=('menu-item-parent','Home')), _class='fa-home',_title= 'Home',), False, None, []),] I am missing the URL part. Dont know where it goes! Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://

[web2py] Error Connecting mssql

2014-05-14 Thread xavier zuniga
Please someone can help with this: Developing on Win7;Python2.7;SQLSERVER2008R2. Already developing on c# against SQLSERVER2008R2 with no problem Connection string: db = DAL('mssql://sa:1@DEYANIRA-THINK/aei') I got this Error: Failure to connect, tried 5 times: Traceback (most recent call las

Re: [web2py] help with helper!

2014-05-14 Thread greenpoise
I tried this but didnt work. I am using it in the menu section Thanks On Wednesday, May 14, 2014 3:59:19 PM UTC-7, yamandu wrote: > > Like this > > A(I(_class="fa-home"),SPAN("Home",_class="menu-item-parent"),_href="index.html", > > _title="Home") > > > 2014-05-14 18:59 GMT-03:00 greenpoise

Re: [web2py] help with helper!

2014-05-14 Thread Carlos Costa
Like this A(I(_class="fa-home"),SPAN("Home",_class="menu-item-parent"),_href="index.html", _title="Home") 2014-05-14 18:59 GMT-03:00 greenpoise : > I need help with this helper! > > I have this > > "menu-item-parent">Home > > > and I made this: > > [A(I(SPAN(_class=('menu-item-parent','Home')

[web2py] help with helper!

2014-05-14 Thread greenpoise
I need help with this helper! I have this Home and I made this: [A(I(SPAN(_class=('menu-item-parent','Home')), _class='fa-home',_title= 'Home',), False, None, []),] I am missing the URL('home") cant get it to work. Where should I put it? thanks -- Resources: - http://web2py.com - http:

Re: [web2py] how string_agg for groupby?

2014-05-14 Thread Richard Vézina
I can't use .with_alias()... I use the SQL string feature that works for another query... I mean it has return an entry in Row dict base on the "AS field_name" of the SQL string. In the case above, I guess that the parser failed on the 2 "AS" in the SQL sring... I have not been able to find in dal

[web2py] smartgrid linked tables "Query Not Supported: no such column" undocumented feature

2014-05-14 Thread Remco Boerma
Hi, Working with the SQLFORM.smartgrid i found undocumented behaviour. If i use linked tables, the fields selection is required for the linked tables grid as well. This might need a tune up in the docs. As it is a grid and thus valid - it caught me by surprise. Reading "in the grid view" to

Re: [web2py] web2py book site problem?

2014-05-14 Thread Dave S
On Wednesday, May 14, 2014 12:50:09 PM UTC-7, Richard wrote: > > No problem here > > Perhaps you waited to long to try ;-) Seems to be back to working properly for me. /dps > > On Wed, May 14, 2014 at 1:47 PM, Dave S >wrote: > >> I'm getting a 502-backend from Python Anywhere when I try to

Re: [web2py] web2py book site problem?

2014-05-14 Thread Richard Vézina
No problem here On Wed, May 14, 2014 at 1:47 PM, Dave S wrote: > I'm getting a 502-backend from Python Anywhere when I try to access the > book. Am I just standing on the wrong tile? > > Some detail: I've had the tab for the book open to "function in views" > for a while, and it was ok after

Re: [web2py] SQL string as a query (about Anthony presentation)

2014-05-14 Thread Richard Vézina
Is this possible because of .parse() ? Richard On Wed, May 14, 2014 at 12:50 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Yes it is!! > > I should have test before ask > > Richard > > > On Wed, May 14, 2014 at 12:49 PM, Richard wrote: > >> Hello Anthony, >> >> You mention briefly

[web2py] Re: Is anyone working on a two-step login for auth? (Sometimes called two factor authentication)

2014-05-14 Thread pallav
Another update - submitted the fixed code as a pull request. This fixes the issue that was causing unit tests to fail. Waiting to hear back from the team. On Tuesday, April 29, 2014 4:57:49 AM UTC-4, thehuman trashcan wrote: > > Thanks for working on this! I think it is important and look forwar

[web2py] web2py book site problem?

2014-05-14 Thread Dave S
I'm getting a 502-backend from Python Anywhere when I try to access the book. Am I just standing on the wrong tile? Some detail: I've had the tab for the book open to "function in views" for a while, and it was ok after the last time I started FF (yesterday or Monday), and just now I wanted

Re: [web2py] how string_agg for groupby?

2014-05-14 Thread Richard Vézina
So I can do this : db().select(db.other_table.other_field, "string_agg(CAST(COALESCE(table1.sign_id, NULL) AS text), ', ') AS sing_id", ...) The only thing still not working is .with_alias('alias_name') not working in this context... SQL "sql_string AS alias_name" not seems to work Richard On

Re: [web2py] SQL string as a query (about Anthony presentation)

2014-05-14 Thread Richard Vézina
Yes it is!! I should have test before ask Richard On Wed, May 14, 2014 at 12:49 PM, Richard wrote: > Hello Anthony, > > You mention briefly that this is possible : > > db("mytable.myfield == 'something'").select(db.mytable.ALL) > > Is this possible : > > db(db.mytable.myfield == 'something').s

[web2py] SQL string as a query (about Anthony presentation)

2014-05-14 Thread Richard
Hello Anthony, You mention briefly that this is possible : db("mytable.myfield == 'something'").select(db.mytable.ALL) Is this possible : db(db.mytable.myfield == 'something').select("*") Or db(db.mytable.myfield == 'something').select("mytable.myfield") ? Thanks Richard -- Resources: -

Re: [web2py] Issue about ,user_signature=True

2014-05-14 Thread Anthony
We probably need to see some code. On Wednesday, May 14, 2014 12:11:21 PM UTC-4, Ramos wrote: > > My case is > I´m on Page A , digitally signed. > Page A has a link to Page B. > Page B is not digitally signed. > i´m in Page A, i click the link to page B. I get and auth error. > If i cut the link

Re: [web2py] Issue about ,user_signature=True

2014-05-14 Thread António Ramos
My case is I´m on Page A , digitally signed. Page A has a link to Page B. Page B is not digitally signed. i´m in Page A, i click the link to page B. I get and auth error. If i cut the link to B and paste it in the url of the browser i get redirected to page A with auth error 2014-05-14 17:04 GM

Re: [web2py] Issue about ,user_signature=True

2014-05-14 Thread Marin Pranjić
So you are on page A. You click the link on page B that is not signed. Which one is signed then? Do you have any decorators on function B? Are you using the same host name on both pages? (you might be missing www. in a link for example) On Wed, May 14, 2014 at 5:47 PM, António Ramos wrote: >

Re: [web2py] Facebook Oauth Login + Posting

2014-05-14 Thread Michele Comitini
this should be the correct way to access the user access token. token = auth.settings.login_form.accessToken() 2014-05-14 6:51 GMT+02:00 EvilLinux : > Hello, > > I am hoping someone might be able to help me figure what I might be doing > wrong or what the next steps I would need to do with calling

Re: [web2py] Issue about ,user_signature=True

2014-05-14 Thread António Ramos
yes!! 2014-05-14 16:45 GMT+01:00 Marin Pranjić : > are you logged in? > > Marin > > > On Wed, May 14, 2014 at 5:28 PM, António Ramos wrote: > >> Hello i use user_signature=True in an app. >> >> I recently moved it to a linux(centos)box at webfaction >> >> suddenly i get "Not authorized" when cli

Re: [web2py] Issue about ,user_signature=True

2014-05-14 Thread Marin Pranjić
are you logged in? Marin On Wed, May 14, 2014 at 5:28 PM, António Ramos wrote: > Hello i use user_signature=True in an app. > > I recently moved it to a linux(centos)box at webfaction > > suddenly i get "Not authorized" when clicking a link to page B in a page A > that has a signed url > > the

[web2py] How to migrate to UUID references in db without messing up reference fields

2014-05-14 Thread Ian W. Scott
I need to take an existing db and implement a UUID referencing system so that I can sync local db's with a central remote version. But I'm concerned that this will break reference fields that refer to the newly synced rows. My understanding is that the UUID field is necessary because a csv impor

[web2py] Issue about ,user_signature=True

2014-05-14 Thread António Ramos
Hello i use user_signature=True in an app. I recently moved it to a linux(centos)box at webfaction suddenly i get "Not authorized" when clicking a link to page B in a page A that has a signed url the link to page B is not a signed url http://xxx.pt//myapp/default/equip/97?emp=131 It shows th

[web2py] how string_agg for groupby?

2014-05-14 Thread Richard
Hello, Is there a way to do string_agg() with in web2py for a query that have groupby clause? Richard -- 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) --- Y

[web2py] Re: SELECT helper - get current selected value...

2014-05-14 Thread Anthony
Give your SELECT a name: SELECT(..., name='myselect') and upon form submission, the selected value will be in request.post_vars.myselect, as with all form inputs. Anthony On Wednesday, May 14, 2014 9:04:35 AM UTC-4, alex wrote: > > hello guys, need help with SELECT helper. > Lets say I have a

Re: [web2py] web2py conference - online talks

2014-05-14 Thread António Ramos
or this ? http://www.ractivejs.org/ 2014-05-14 12:28 GMT+01:00 Anthony : > Is this the reactive.js you are using: > https://github.com/component/reactive? > > > On Wednesday, May 14, 2014 1:20:25 AM UTC-4, Massimo Di Pierro wrote: >> >> I am looking at jQuery.js + underscore.js + reactive.js an

[web2py] reddit clone - foreign key constraint failed

2014-05-14 Thread Uri Tamir
Hi all, I've been following Massimo's video tutorials (which are *great!* thanks Massimo) when trying to build the reddit clone and populate it i get a ticket - foreign key constraint failed the database was populated with users and posts but not with comments. I t

[web2py] Facebook Oauth Login + Posting

2014-05-14 Thread EvilLinux
Hello, I am hoping someone might be able to help me figure what I might be doing wrong or what the next steps I would need to do with calling the user's facebook access token. I followed the web2py book's method to obtain the facebook login: ## import required modules try: import json exc

[web2py] SELECT helper - get current selected value...

2014-05-14 Thread alex
hello guys, need help with SELECT helper. Lets say I have a SELECT object: sel = SELECT(OPTION('database1', _value='1'), OPTION('database2', _value='2'), ) I would like to display database information according to the selected option in SELECT helper. How can I get the current selected valu

[web2py] Many-to-Many relationship and multi SQLFORMs submission automatically

2014-05-14 Thread Sihui Huang
In my application, one has urls and tags. What I'm doing is when the user entering data for an url, he/she will also select relative tags. I store urls and tags into two different tables and I plan to use a reference table which describe the many-to-many relationship between tags and urls. I

[web2py] Re: form element select add options

2014-05-14 Thread Trend Codax
>From a row like this: Country_db = dba().select(dba.country.ALL) my_options = Country_db.country Am Montag, 12. Mai 2014 23:58:04 UTC+2 schrieb Trend Codax: > Hey guys, > I have a form, a SQL Form. I'm adding an element, a select element. But > how can i add Options to this element? > > >

[web2py] Re: form element select add options

2014-05-14 Thread Lucas Schreiber
Thanks, that's exactly what I was looking for :) Am Montag, 12. Mai 2014 23:58:04 UTC+2 schrieb Trend Codax: > > Hey guys, > I have a form, a SQL Form. I'm adding an element, a select element. But > how can i add Options to this element? > > > form = SQLFORM(dba.account_directory) > my

[web2py] Re: form element select add options

2014-05-14 Thread Anthony
Use the OPTION() helper to create options, and pass them to SELECT(). SELECT(OPTION('option 1'), OPTION('option 2'), ...) If the options should have submitted values that are different from their displayed values, you can set the _value attribute separately. If you have an existing list, you ca

Re: [web2py] web2py conference - online talks

2014-05-14 Thread Anthony
Is this the reactive.js you are using: https://github.com/component/reactive? On Wednesday, May 14, 2014 1:20:25 AM UTC-4, Massimo Di Pierro wrote: > > I am looking at jQuery.js + underscore.js + reactive.js and I find > everything I ever looked for. Seems much more flexible than Angular.js and

Re: [web2py] web2py conference - online talks

2014-05-14 Thread António Ramos
Massimo, have you tried Angular-ui? http://angular-ui.github.io/bootstrap/ 2014-05-14 5:40 GMT+01:00 Massimo Di Pierro : > I have been using angular.js a lot but I find the controller pattern to be > too constraining. for example I cannot use promises outside the scope of a > controller. I also