[web2py:36017] forms

2009-11-26 Thread kurdt
hi, i am actually a django user, I want to try web2py, but I could like to know if web2py has FORMS? Forms that can be customize not the one that inherit from a MODEL. And of the coolest things I like about Django is there FORMS, very flexible (adding custom function or overriding function). Does

[web2py:36018] Re: bad image and word Validator

2009-11-26 Thread Simo
Thank, this solve a part of a problem, my site is also for french community . thanks for web2py users , am a java programmer and am very happy to use web2py On Wed, Nov 25, 2009 at 6:01 PM, mdipierro wrote: > > As a bad words validator you can try this one: > > http://web2py.com/examples/stati

Re: [web2py:36019] forms

2009-11-26 Thread Simo
You cant custum your form. this is one example a use. form=FORM(TABLE(TR("categorie:",A(category(1), _href=URL(r=request,c=request.controller, f='category', args=request.args))), TR("sous categorie:",A(category(3), _href=URL(r=request,c=request.controller, f='subcagegory', args=reque

[web2py:36020] Re: Help with frames

2009-11-26 Thread Lydia Manikonda
Something like breaking a particular page in to some frames. Like in html we normally mention like for example: A simple frameset document This frameset document contains: Some neat contents Some other neat contents

[web2py:36021] Re: forms

2009-11-26 Thread mdipierro
Yes. One way to do it is form=SQLFORM.factory(Field('name'), Field('gender',requires=IS_IN_SET(('Male','Female' (gender field will be render with select dropbox). You can embed it in template with {{=form}} or customized {{=form.custom.begin}} {{=form.custom.widget.name}} {{=form.cus

[web2py:36022] Re: Help with frames

2009-11-26 Thread mdipierro
In the templates (which we call views) you can put any HTML you like. You can put the HTML of your example without any change. Anyway, as a more general advice, you should use frames if the content is a complete HTML page. If you are trying to embed the output of a web2py action there are better w

[web2py:36023] Re: bad image and word Validator

2009-11-26 Thread mdipierro
If you can find a list of bad french words (singular and plural), I cam modify the validator to be extensible. On Nov 26, 2:30 am, Simo wrote: > Thank, this solve a part of a problem, my site is also  for french community > . >  thanks for web2py users , am a java programmer and am very happy to

[web2py:36024] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Mi experience with spam on blogs and cms engine is that 70% of spam comments are in english, 10-15% in chinese, 10% in russian and only the remaining 5% is written in my own language. Do you have the same experiences? One great feature for web2py could be a bayesan antispam filter, something like A

[web2py:36025] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Mi experience with spam on blogs and cms engine is that 70% of spam comments are in english, 10-15% in chinese, 10% in russian and only the remaining 5% is written in my own language. Do you have the same experiences? One great feature for web2py could be a bayesan antispam filter, something like A

[web2py:36026] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Or we could implement akismet for python... :-) http://www.voidspace.org.uk/python/akismet_python.html On 26 Nov, 10:51, mdipierro wrote: > If you can find a list of bad french words (singular and plural), I > cam modify the validator to be extensible. > > On Nov 26, 2:30 am, Simo wrote: > > > T

[web2py:36027] Re: bad image and word Validator

2009-11-26 Thread mdipierro
This is written in python too and the complete source is available: http://spambayes.sourceforge.net/ Massimo On Nov 26, 4:24 am, Doxaliber wrote: > Or we could implement akismet for python... > :-)http://www.voidspace.org.uk/python/akismet_python.html > > On 26 Nov, 10:51, mdipierro wrote: >

[web2py:36028] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread yamandu
The problem when I update is that was not possible to see the error. I got ticket screen but the link always led to another ticket screen. So I think there was a problem under my app too. On Nov 25, 12:38 pm, mdipierro wrote: > I do not understand. where you not getting a ticket? Something wrong

[web2py:36029] Re: bad image and word Validator

2009-11-26 Thread Doxaliber
Great. An open source solution is always better for me. :-) We could create a plugin to use this filter for comments and other user generated contents. On 26 Nov, 12:09, mdipierro wrote: > This is written in python too and the complete source is > available:http://spambayes.sourceforge.net/ > >

[web2py:36030] Re: possible ? WYSIWYG editor with integrated image upload

2009-11-26 Thread David
Mr Romero's been holding out on the goods it seems. This something I need as well. A simple tutorial and app example on web2py slices would be most excellent. Thank you for the work Jon! - David On Nov 25, 11:29 am, "mr.freeze" wrote: > Yes, more please! > > On Nov 25, 11:03 am, mdipierro wr

[web2py:36031] Data grids in Web2py

2009-11-26 Thread David
Do we have a data grid widget in web2py? If not, are there any plans to include this in the future? I'm currently building them manually with web2py, which works, but I've seen dataTables and it looks a lot nicer. Has anyone used dataTables? Do you have any examples that I can reference? Thank

[web2py:36032] Re: Complex SQL Query - Left Out Join With A Third table...

2009-11-26 Thread Yannick
Thanks Massimo, I just wonder, I do know that is possible to see the SQL Query by using _select()... I was wondering if there opposite operation ? Like if is possible to write the SQL query and see DAL code of web2py ? Thanks, Yannick P. On Nov 25, 9:00 am, mdipierro wrote: > Yes. > > left=(db.t

[web2py:36033] SQL Query with Case Statement...

2009-11-26 Thread Yannick
Hello Mate, I just double check in the book and the documentation resources because I was wondering how to actually create a DAL query that include "Case" statement ? Like let's say I have an SQL like this : SELECT salary, CASE WHEN salary <= 2000 THEN 'PoorOne' END AS salary_level FROM employ

[web2py:36034] IS_DATE validation not working

2009-11-26 Thread Johann Spies
In my db.py I have this as part of the auth_table: Field('birthdate', 'date',requires = IS_DATE(format=T('%Y-%m-%d'), error_message=T('must be -MM-DD!'))), However, when a non-date is entered, the form accepts it and corrupt the database resulting in a ticket. Why does this validator not wor

Re: [web2py:36035] Re: Markdown problem

2009-11-26 Thread Johann Spies
2009/11/24 mdipierro : I am testing with "Post a comment": > When you do WIKI(,safe_mode='escape') is default. Try with > safe_mode=None or safe_mode=True. With "save_mode='escape'" the result is "" With "save_mode=True" the result is "[HTML_REMOVED]Post a comment[HTML_REMOVED]" :( -- Yo

[web2py:36036] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread mdipierro
Please try again. When you get the first ticket click on it. If you get another ticket / locate the corresponding ticket file applciations//errors/ and email it to me. When you upgraded web2py, did you upgraded admin? web2py.py --upgrade=yes Massimo On Nov 26, 5:12 am, yamandu wrote: > The pro

[web2py:36037] Re: bad image and word Validator

2009-11-26 Thread mdipierro
It would be a nice app. On Nov 26, 5:24 am, Doxaliber wrote: > Great. An open source solution is always better for me. :-) > We could create a plugin to use this filter for comments and > other user generated contents. > > On 26 Nov, 12:09, mdipierro wrote: > > > This is written in python too an

[web2py:36038] Re: Data grids in Web2py

2009-11-26 Thread mdipierro
Yes http://web2py-crm.appspot.com/init/default/index uses datatables. The source is posted on applicances On Nov 26, 5:45 am, David wrote: > Do we have a data grid widget in web2py?  If not, are there any plans > to include this in the future? > > I'm currently building them manually with web2

[web2py:36039] Re: Complex SQL Query - Left Out Join With A Third table...

2009-11-26 Thread mdipierro
Sorry no. On Nov 26, 6:42 am, Yannick wrote: > Thanks Massimo, > I just wonder, I do know that is possible to see the SQL Query by > using _select()... I was wondering if there opposite operation ? Like > if is possible to write the SQL query and see DAL code of web2py ? > > Thanks, > Yannick P.

[web2py:36040] Re: IS_DATE validation not working

2009-11-26 Thread vvk
I faced a similar issue once. Write "requires" separately as db.dbname.fieldname.requires = [IS_DATE(error_message = "Must be - MM-DD")] On Nov 26, 5:56 pm, Johann Spies wrote: > In my db.py I have this as part of the auth_table: > > Field('birthdate', 'date',requires = IS_DATE(format=T('%

[web2py:36041] Re: SQL Query with Case Statement...

2009-11-26 Thread mdipierro
You cannot but you can try this: db(db.employees.salary, "CASE WHEN salary <= 2000 THEN 'PoorOne' END AS salary_level", orderby=db.employees.salary) let us know if it works. On Nov 26, 6:53 am, Yannick wrote: > Hello Mate, > > I just double check in the book and the documentation resources > b

[web2py:36042] Re: IS_DATE validation not working

2009-11-26 Thread mdipierro
haha. You found a bug. I just fixed it in trunk. For now just use this workaround Field('birthdate', 'date',requires = IS_DATE(format=str(T('%Y-%m- %d')),error_message=str(T('must be -MM-DD!', notice the str(T(...)) instead of T(..). Massimo On Nov 26, 6:56 am, Johann Spies wrote: >

[web2py:36043] Re: Markdown problem

2009-11-26 Thread mdipierro
I took a second look. >>> WIKI('this is a test').xml() 'this is a test\n' >>> WIKI('this is a test',safe_mode=True).xml() 'this [HTML_REMOVED]is[HTML_REMOVED] a test\n' >>> WIKI('this is a test',safe_mode=False).xml() 'this is a test\n' >>> WIKI('this is a test',safe_mode=False).xml() 'this

[web2py:36044] web2py 1.73.1 is OUT for testing

2009-11-26 Thread mdipierro
http://web2py.com/examples/static/1.73.1/web2py_src.zip http://web2py.com/examples/static/1.73.1/web2py_osx.zip http://web2py.com/examples/static/1.73.1/web2py_win.zip Please let me know if you check it out and everything is ok Fixed problem with storage and comparison of Row objects Fixed probl

[web2py:36045] how i got web2py woking with mod_proxy on ubuntu

2009-11-26 Thread selecta
i have a apache server running which i wanted to show my web2py apps that are running on the provided server under port 8000 so that i can call http://localhost/myapp/ <- thats the apache server instead of http://127.0.0.1:8000/myapp/ <- thats the web2py server what i had to do was to install mod

[web2py:36046] Export/Import problem

2009-11-26 Thread vvk
I've created database and wrote controllers without using UUID's. While exporting and importing databases, I'm facing these problems i) record id's are getting changed while importing and my search functions are no longer working because I've reference of id's of other tables, which are changing

[web2py:36047] Re: Export/Import problem

2009-11-26 Thread mdipierro
You do not need uuid unless you want to import records that you already have and want to replace them. If you use id_map={} db.table1.import_from_csv_file(ifile1, id_map=id_map) db.table2.import_from_csv_file(ifile2, id_map=id_map) the id_map={} makes sure all references between table1 and table

Re: [web2py:36048] Re: Don't you love it when editors mess up?

2009-11-26 Thread Thadeus Burgess
Actually, it should be self.settings.table_even. However somehow export_to_csv got stuck in there, and is in SVN trunk. I think at some point Massimo had export_to_csv in his copy/paste and somehow his IDE decided to paste it right there and he did not realize. Eclipse has done that to me many a

[web2py:36049] Routes

2009-11-26 Thread kbochert
As a new user to web2py, I am trying to get routes.py to work. Nothing I put into web2py/routes.py has any effect. example: routes_in=( ('^127\.0\.0\.1:.*', '/examples/default/index'), ) Moreover , clear errors in the routes.py have no effect. i.e. x = 6/0; @! Am I overlooking so

[web2py:36050] url rewriting bug in rewrite.py still not fixed

2009-11-26 Thread Wikus van de Merwe
Sorry for advertising the bug here, but as I've noticed that the list gets 10 times more attention than the issue tracker. Some time ago I've filled a bug against rewrite.py and its routing rules processing: http://code.google.com/p/web2py/issues/detail?id=58 It was marked as fixed in trunk but in

[web2py:36051] Re: Routes

2009-11-26 Thread Yarko Tymciurak
routes.py is read when web2py starts - be sure to re-start whatever server you are using (or restart web2py, if you are using the builting server). On Nov 26, 11:21 am, kbochert wrote: > As a new user to web2py, I am trying to get routes.py to work. > Nothing I put into web2py/routes.py has any e

[web2py:36052] Re: Routes

2009-11-26 Thread Wikus van de Merwe
Well, first, you don't need a comma after bracket, when there is only one rule there. Second, routes are only processed once when the server is first time started. Are you restarting your app server each time you change it? -- You received this message because you are subscribed to the Google Gro

[web2py:36053] Re: Export/Import problem

2009-11-26 Thread vvk
I tried these: Exported into csv file from appadmin interface three tables: auth_user, allot, product with allot(auth_user_id, product_id) having id's of user and product Then tried to import as: @auth.requires_login() def backup(): id_map = {} db.auth_user.import_from_csv_file(o

[web2py:36054] Re: Export/Import problem

2009-11-26 Thread vvk
I tried: Exported to csv file from appadmin interface, tables auth_user, product, allot with allot table having id references of auth_user and product allot(auth_user.id,product.id) Imported as: @auth.requires_login() def backup(): id_map = {} db.auth_user.import_from_csv_file(op

[web2py:36055] Re: how i got web2py woking with mod_proxy on ubuntu

2009-11-26 Thread mdipierro
Thank you for the suggestion. On Nov 26, 8:35 am, selecta wrote: > i have a apache server running which i wanted to show my web2py apps > that are running on the provided server under port 8000 > so that i can callhttp://localhost/myapp/<- thats the apache server > instead ofhttp://127.0.0.1:8000

[web2py:36056] Re: url rewriting bug in rewrite.py still not fixed

2009-11-26 Thread mdipierro
oops. sorry about that. I did not get the email notification from google code. I will take a look later today or tomorrow. Massimo On Nov 26, 11:55 am, Wikus van de Merwe wrote: > Sorry for advertising the bug here, but as I've noticed that the list > gets 10 times more attention than the issue

[web2py:36057] Re: Routes

2009-11-26 Thread mdipierro
technically you can reload routes without restarting. From the admin web based shell from gluon.rewrite improt * load() On Nov 26, 12:02 pm, Yarko Tymciurak wrote: > routes.py is read when web2py starts - be sure to re-start whatever > server you are using (or restart web2py, if you are using th

[web2py:36058] Re: Export/Import problem

2009-11-26 Thread mdipierro
Not sure I understand. Do you get broken references? Are you exporting the entire db? and you importing over the existing db or a clean db? Have you tried exporting and importing the entire db? db.export_to_csv_file(...) db.import_from_csv_file(...) On Nov 26, 12:16 pm, vvk wrote: > I tried: >

[web2py:36059] Re: url rewriting bug in rewrite.py still not fixed

2009-11-26 Thread mdipierro
I do not understand. Could you provide an example of path that is wrongly mapped. You say patch that "do not start with / are wrongly rewritten". Technically paths that do not start with / are not allowed so I am not sure how do you expect the rewrite to behave. On Nov 26, 11:55 am, Wikus van de M

[web2py:36060] Re: expire login when browser closes

2009-11-26 Thread vince
it will expire when browser close on firefox/safari. however, if you just close the tab the session won't expire. is there any workaround for this problem? -vince On Nov 20, 3:14 am, mdipierro wrote: > This expiration is handled at the web2py level. Thesessioncookie > used to maintain thesession

[web2py:36061] Re: Routes

2009-11-26 Thread kbochert
On Nov 26, 10:36 am, mdipierro wrote: > technically you can reload routes without restarting. From the admin > web based shell > > from gluon.rewrite improt * > load() > > On Nov 26, 12:02 pm, Yarko Tymciurak > wrote: > > > routes.py is read when web2py starts - be sure to re-start whatever > >

[web2py:36062] multiple validations problem

2009-11-26 Thread __Kyo__
Hi, i use this code in my application, it works very good when i insert a new record, but i have a little problem when i want to update a registry. For example: I have un my table inventory: product, country, quantity If i insert pencil, canada, 40 it inserts fine then if i want to insert again

[web2py:36063] Re: Data grids in Web2py

2009-11-26 Thread David
Just got a chance to look through the source... It's a whole lot cleaner than the mess I cobbled together to get it to work. Thank you for this Massimo :0) On Nov 26, 7:23 am, mdipierro wrote: > Yes > > http://web2py-crm.appspot.com/init/default/index > > uses datatables. The source is post

[web2py:36064] accessing web...@googlegroups please help

2009-11-26 Thread Eduardo Biano
Hi, I've been trying for the past weeks to access web2py@googlegroups.com but failed to connect when I clicked Groups at Google.com. The error displayed is Network Timeout. I googled but didn't find any solution. Tried searching email address of Google groups to address this concern but never fo

[web2py:36065] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread yamandu
Massimo, strange, but I can´t reproduce the problem. I tried to do the same mistake but I got a normal ticket behavior. But I don´t remember exactly how was the mistake with the brackets, only that it was on menu.py in menu definition. Could it be just a big syntax problem caused by bracket mismat

[web2py:36066] Re: Export/Import problem

2009-11-26 Thread vvk
No Broken references I deleted all my DB and created a new one with only One auth_user, One product in Product Table and only One entry in Allot Table. Not Exporting entire DB I'm not exporting entire DB, I'm exporting only three tables auth_user, product, allot and then I'm deleting only those th

[web2py:36067] Re: multiple validations problem

2009-11-26 Thread mdipierro
Look into gluon.validators.IS_NOT_IN_DB specifically: def set_self_id(self, id): self.record_id = id By settings the id of the current record you can prevent the check on update. Massimo On Nov 26, 4:32 pm, __Kyo__ wrote: > Hi, i use this code in my application, it works very good

[web2py:36068] Re: accessing web...@googlegroups please help

2009-11-26 Thread mdipierro
I do not know what to do about this. If anybody has a good idea please let me know. On Nov 26, 7:51 pm, Eduardo Biano wrote: > Hi, > I've been trying for the past weeks to access web2py@googlegroups.com but > failed to connect when I clicked Groups at Google.com. The error displayed is > Networ

[web2py:36069] Re: Crashing on Updating to 1.72.3

2009-11-26 Thread mdipierro
I do not know. Usually a recirsive ticket is caused by a problem in admin or a wrong filesystem permissions. On Nov 26, 8:58 pm, yamandu wrote: > Massimo, > > strange, but I can´t reproduce the problem. > I tried to do the same mistake but I got a normal ticket behavior. > But I don´t remember ex