Re: [web2py] Re: Change the field that displays in the "Welcome First_Name" bar?

2011-12-22 Thread Thomas Dall'Agnese
). Cheers, Thomas On Fri, Dec 23, 2011 at 2:16 PM, Anthony wrote: > On Thursday, December 22, 2011 10:23:59 PM UTC-5, Thomas Dall'Agnese wrote: >> >> Hi there, >> >> Is there a way to change the field displayed in the "Welcome" block on >> the top

[web2py] Get the ID of the just inserted row

2011-12-22 Thread Thomas Dall'Agnese
Hi, Let say I have 2 tables: db.define_table('post', Field('content')) db.define_table('comment', Field('content'), Field('post', 'reference post)) When I add a "post" (through a FORM), I would like to automatically add 3 comments that refer to that post. How can I retrieve the ID of the just i

Re: [web2py] Re: Get the ID of the just inserted row

2011-12-23 Thread Thomas Dall'Agnese
orm.vars.id to get to the paragraph concerned) > > On Dec 23, 3:01 pm, Thomas Dall'Agnese > wrote: > > Hi, > > > > Let say I have 2 tables: > > > > db.define_table('post', Field('content')) > > db.define_table('comment',

[web2py] format parameter not working?

2011-12-23 Thread Thomas Dall'Agnese
Hi, I set the format of a table to a given field, and reference it in another table. Unfortunately, the format seems to be ignored and instead of a combobox there is a textfield where I can input manually the id of the referenced table. I am using the trunk version. Do I need to set up anything

[web2py] Get the ID of a row in a virtual field?

2011-12-23 Thread Thomas Dall'Agnese
Hi, Is it possible to get the ID of a row in a virtual field? I tried the following piece of code to virtually get the number of comments of a given post (assuming two tables "post" and "comment" where a "comment" entry can have a "post", so a post as many comments): db.post.virtual_comments_nb

[web2py] Re: Get the ID of the just inserted row

2011-12-23 Thread Thomas Dall'Agnese
Hi Anthony, Thanks for your answer. I used the form.vars.id way. And indeed, I had to change my process because the form.process().acceptedwas false after doing a form.validate(). So I changed the form.validate() with form.process().accepted and delete the inserted post if an exception is rais

Re: [web2py] Get the ID of a row in a virtual field?

2011-12-23 Thread Thomas Dall'Agnese
It works, thanks! In the examples, they can call directly row.field_name. Why do I have to specify the table name as well in my case? (row.tablename.fieldbame) Is it a mistake in the book or is my case different than the examples? Book example: http://www.web2py.com/book/default/chapter/06#New

Re: [web2py] Get the ID of a row in a virtual field?

2011-12-23 Thread Thomas Dall'Agnese
Another question: the virtual field is not displayed in the SQLTABLE() html rendering but is correctly displayed in the JSON rendering, is it normal?

[web2py] Re: format parameter not working?

2011-12-23 Thread Thomas Dall'Agnese
Sure. db.define_table('comment', Field('user', type='reference auth_user', label=T('User')), Field('date_added', type='datetime', label=T('Date Added')), Field('error_type', type='reference error_type', label=T('Error Type')), Field('balise', type='ref

Re: [web2py] Get the ID of a row in a virtual field?

2011-12-23 Thread Thomas Dall'Agnese
able... Imagine you use viritual field in the context of a join where your > other table having the same field name is joint into that request... > > Richard > > > On Fri, Dec 23, 2011 at 9:09 AM, Thomas Dall'Agnese < > thomas.dallagn...@gmail.com> wrote: > >>

Re: [web2py] Re: format parameter not working?

2011-12-23 Thread Thomas Dall'Agnese
first > (otherwise the validators cannot be defined because they refer to the > referenced table). So, try defining db.comment after the other tables that > it references. > > Anthony > > > On Friday, December 23, 2011 9:16:15 AM UTC-5, Thomas Dall'Agnese wrote: >>

[web2py] Login through RPX resets the username?

2011-12-24 Thread Thomas Dall'Agnese
Hi, Everytime I login through RPX (using my Google account), the username is reseted to it's default value (the part before the @gmail.com). If I go to my profile, change the username, logout and log back in, the username is reseted... Is it normal and is there a way to change it? Best, Thoma

[web2py] Re: Login through RPX resets the username?

2011-12-24 Thread Thomas Dall'Agnese
No, I am using the default auth_user.

[web2py] Deployment problem on dotcloud with PostgreSQL

2011-12-24 Thread Thomas Dall'Agnese
Ticket report: syntax error at or near "user" LINE 4: user INTEGER REFERENCES auth_user(id) ON DELETE CASCADE, ^VERSIONweb2py™(1, 99, 4, datetime.datetime(2011, 12, 14, 14, 46, 14), 'stable')PythonPython 2.6.5: /home/dotcloud/rsync-1324797830040/TRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-24 Thread Thomas Dall'Agnese
adding check_references=['user'] to the DAL() call does not solve the problem but raises a new ticket: 'user'VERSIONweb2py™(1, 99, 4, datetime.datetime(2011, 12, 14, 14, 46, 14), 'stable')PythonPython 2.6.5: /home/dotcloud/rsync-1324798764157/TRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 1

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-25 Thread Thomas Dall'Agnese
Hi Massimo, That's what I thought, but I did not manually add any table called "user". - db.py defines tables *auth_user* - Edit db_wizard.py defines tables *balise*, *balise_archive*, * comment*, *comment_archive*, *episode*, *episode_archive*, *error_type*, *error_type_archiv

[web2py] Re: ExtJS / qooxdoo - Python wrapper

2011-12-25 Thread Thomas Dall'Agnese
You can have a look at the Django-ExtJS plugin (using ExtJS 3).

[web2py] Re: Ext JS REST Grid + WEB2PY CRUD ?

2011-12-25 Thread Thomas Dall'Agnese
Hi, Has anything be updated to use ExtJS libraries in web2py? I am using some ExtJS 4 grids on my application, feeding the grids through JSON outputs from web2py, but not using the CRUD feature. Which means I am manually parsing the SORT and PAGING information from the ExtJS calls (through JSON

[web2py] Re: Ext JS REST Grid + WEB2PY CRUD ?

2011-12-25 Thread Thomas Dall'Agnese
The screenshot: http://data.imagup.com/10/1139541911.PNG

[web2py] Janrain Engage OR normal register/login

2011-12-29 Thread Thomas Dall'Agnese
Hi, Is it possible to allow normal login in addition to login via RPX (janrain engage)? If I activate RPX, I cannot register through the "normal" process. Is it possible to keep the "normal" login as well as the RPX one? Best regards, Thomas

Re: [web2py] Re: Janrain Engage OR normal register/login

2011-12-30 Thread Thomas Dall'Agnese
rms" at the end of this section: > http://web2py.com/books/default/chapter/29/9#Other-login-methods-and-login-forms. > There's also: > > http://www.web2pyslices.com/slices/take_slice/124 > http://www.web2pyslices.com/slices/take_slice/28 > > Anthony > > &g

Re: [web2py] Re: Janrain Engage OR normal register/login

2011-12-30 Thread Thomas Dall'Agnese
Another problem with the slices: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. Traceback (most recent call last): File "/windows/Users/Thomas/Dropbox/appz/2011/dotcloud_web2py/gluon/restricted.py", line 204, in restricted exec ccode in environment File "/windows/Users/Thomas/D

Re: [web2py] Re: Janrain Engage OR normal register/login

2011-12-30 Thread Thomas Dall'Agnese
It works if we remove the first parameter (request) in the ExtendedLoginForm: auth.settings.login_form = ExtendedLoginForm(auth, other_form, signals=['token'])

[web2py] Re: MySql table already exists error

2011-12-30 Thread Thomas Dall'Agnese
But if we change the table definition, for example we add one field, it will not be updated then, isn't it? How can we migrate a MySQL table?

Re: [web2py] Re: MySql table already exists error

2011-12-30 Thread Thomas Dall'Agnese
run with migrate=False > 3) web2py is aware of the tables (created by web2py or you run > fake_migrate) but you need to change them > set migrate=True until the migration has happened. > > I guess you are asking about 3. > > On Dec 30, 9:53 pm, Thomas Dall'Agnese > wrote

[web2py] Re: MySql table already exists error

2011-12-30 Thread Thomas Dall'Agnese
I see, thanks for your help! Cheers, Thomas

[web2py] Error creating tables on a MySQL database on DotCloud?

2011-12-30 Thread Thomas Dall'Agnese
Hi, After having errors in PostgreSQL, I moved to MySQL and also got errors. With MySQL, I can't create some tables (but some tables worked!). Error: Traceback (most recent call last): File "/home/dotcloud/current/gluon/restricted.py", line 204, in restricted exec ccode in environment Fi

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2011-12-30 Thread Thomas Dall'Agnese
Sent to your DePaul e-mail address. I am looking forward to a solution to that problem as MySQL doesn't work neither on DotCloud (error creating a table, see other post).

Re: [web2py] Error creating tables on a MySQL database on DotCloud?

2011-12-31 Thread Thomas Dall'Agnese
aybe the problem is due to DotCloud, not web2py. Cheers, Thomas On Sunday, January 1, 2012, Massimo Di Pierro wrote: > Not sure what the problem is but list:reference does work with mysql. > Are you sure the table does not exist already? > > On Dec 30, 10:25 pm, Thomas Dall&

[web2py] Re: Error creating tables on a MySQL database on DotCloud?

2012-01-02 Thread Thomas Dall'Agnese
Actually, I just tried on FluxFlex and it doesn't work neither! I have the same error if I use the MySQL database (provided by FluxFlex) but it works using SQLite. The project is open source, available here: https://github.com/ThomasDalla/FansubCheck_web2py/tree/master/public_html/applications/f

[web2py] Re: Deployment problem on dotcloud with PostgreSQL

2012-01-04 Thread Thomas Dall'Agnese
Hi Jérôme, Thanks for your advice. Is it possible to change the name 'user' used by web2py without changing the code in the 'gluon' folder?