[web2py] Re: PyCharm license for web2py dev - who wants?

2015-10-15 Thread Loïc
+1 thanks Le dimanche 11 octobre 2015 21:21:16 UTC+2, Francisco Ribeiro a écrit : > > Hello all, > > for those who know PyCharm is a great IDE from JetBrains that provides > free licenses for Open Source projects like web2py ( > https://www.jetbrains.com/buy/opensource/?product=pycharm ). To

[web2py] Re: How do I configure my domain to hosting PythonAnywhere

2014-09-17 Thread Loïc
https://www.pythonanywhere.com/wiki/OwnDomains Le dimanche 14 septembre 2014 17:20:54 UTC+2, Капылов Данил a écrit : How do I configure my domain to hosting PythonAnywhere Give detailed step by step instructions in please -- Resources: - http://web2py.com - http://web2py.com/book

Re: [web2py] web2py CMS

2014-06-06 Thread Loïc
:47:48 AM UTC-7, Loïc wrote: Hi Andrey, I can not tell you what would be the *best* cms : I developped tiny_website and my opinion would be biaised :-) You are the only one that knows if you need only basic features, or more bell and whistles. Test each one during 5 minutes, and choose

Re: [web2py] web2py CMS

2014-06-05 Thread Loïc
Hi Andrey, I can not tell you what would be the *best* cms : I developped tiny_website and my opinion would be biaised :-) You are the only one that knows if you need only basic features, or more bell and whistles. Test each one during 5 minutes, and choose the one that fits your needs if you

[web2py] Re: how can i join 3 tables and output a the all three together joined in web2py?

2013-12-20 Thread Loïc
I posted a response on SO : http://stackoverflow.com/questions/20697034/how-can-i-join-3-tables-and-output-a-the-all-three-together-joined-in-web2py/20698864#20698864 Le vendredi 20 décembre 2013 07:06:41 UTC+1, deepak sandhu a écrit : model: # coding: utf8 db.define_table('dept',

[web2py] Re: SQLite Integrity error after update to 2.8.2. = Widget problem?

2013-12-10 Thread Loïc
contraints. On Thursday, 5 December 2013 09:46:59 UTC-6, Loïc wrote: I know Massimo, but my problem seems to be located in the Widget management And that's why I started my message with *I have the same problem as the one explained here : https://groups.google.com/forum/?fromgroups#!topic

[web2py] Re: SQLite Integrity error after update to 2.8.2. = Widget problem?

2013-12-10 Thread Loïc
), _class=self.type, _name=self.fieldname, value=value, requires=self.tablename.parent.requires) And it works Le mardi 10 décembre 2013 12:36:03 UTC+1, Loïc a écrit : I'm still trying to understand this issue, as it is related

[web2py] Re: After upgrade to 2.8.2: class 'sqlite3.IntegrityError' foreign key constraint failed

2013-12-06 Thread Loïc
Hi Scott I don't fully understand you answer. Could you please show us what was your buggy code, and how you solved it? I'm still stuck with this problem... Thanks a lot -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Re: After upgrade to 2.8.2: class 'sqlite3.IntegrityError' foreign key constraint failed

2013-12-05 Thread Loïc
The workaround for me was to specify adapter_args=dict(foreign_keys=False) in the DAL connection. For example : db = DAL('sqlite://storage.sqlite', pool_size=1, lazy_tables=True, migrate=True, adapter_args=dict(foreign_keys=False)) Le jeudi 5 décembre 2013 06:48:52 UTC+1, Vch H a écrit : How

[web2py] SQLite Integrity error after update to 2.8.2. = Widget problem?

2013-12-05 Thread Loïc
Hello all- I have the same problem as the one explained here :https://groups.google.com/forum/?fromgroups#!topic/web2py/klspqXpha4E But as I have more specific informations, I start a new thread... *My Model (simplified) : * db.define_table('page', Field('parent', 'reference page',

[web2py] Re: SQLite Integrity error after update to 2.8.2. = Widget problem?

2013-12-05 Thread Loïc
On Thursday, 5 December 2013 05:04:17 UTC-6, Loïc wrote: Hello all- I have the same problem as the one explained here :https://groups.google.com/forum/?fromgroups#!topic/web2py/klspqXpha4E But as I have more specific informations, I start a new thread... *My Model (simplified

Re: [web2py] Error uploading 60 character named .pptx file

2013-11-14 Thread Loïc
I had a similar issue some time ago, but Windows was my testing machine, not the production server OS. So it was not very annoying... If you want to host on Windows, you may have to store the original filename in the database, and change it on the disk :

Re: [web2py] change web2py application directory

2013-10-31 Thread Loïc
18:18:17 UTC+1, Loïc ESPERN a écrit : Good idea I will make a try when upgrading my web2py repo... Thank you Le 30 oct. 2013 16:01, Richard Vézina ml.richa...@gmail.comjavascript: a écrit : Loïc, just a thought... How will you manage the upgrade of web2py version? If you have only

Re: [web2py] change web2py application directory

2013-10-30 Thread Loïc
Some weeks ago, I tried to create a symlink inside /applications folder, but I got an error in modules. I was using mklink command on Win7, and my app works fine when located inside /applications folder without symlink... Below is the ticket I got. Maybe you have an idea? Ticket ID

Re: [web2py] change web2py application directory

2013-10-30 Thread Loïc
it is different... If I remember there is a difference in hardlink and softlink that need to be consider... Richard On Wed, Oct 30, 2013 at 4:06 AM, Loïc loic@gmail.com javascript:wrote: Some weeks ago, I tried to create a symlink inside /applications folder, but I got an error in modules

Re: [web2py] change web2py application directory

2013-10-30 Thread Loïc ESPERN
Good idea I will make a try when upgrading my web2py repo... Thank you Le 30 oct. 2013 16:01, Richard Vézina ml.richard.vez...@gmail.com a écrit : Loïc, just a thought... How will you manage the upgrade of web2py version? If you have only a single repo, you will make symlink in new version

Re: [web2py] Re: 2 domains served by the same web2py

2013-10-25 Thread Loïc Espern
':'vtraffic', 'parking.integreen-life.bz.it':'parkbz'} ), vtraffic = dict(languages=['en', 'it', 'de']), parkbz = dict(languages=['en', 'it', 'de']), ) hope it helps Paolo On Thursday, October 24, 2013 11:19:05 PM UTC+2, Loïc wrote: Considering my previous post, and the routes

[web2py] Re: 2 domains served by the same web2py

2013-10-24 Thread Loïc
Did you try using routes.py? Something like # -*- coding: utf-8 -*- routes_app = ( (r'.*?:https?://www.site1.pt:\w* /$anything', r'site1'), (r'.*?:https?://www.site2.pt:\w* /$anything', r'site2') ) Le jeudi 24 octobre 2013 11:12:07 UTC+2, Ramos a écrit : hello, i need another domain

Re: [web2py] Re: 2 domains served by the same web2py

2013-10-24 Thread Loïc
Considering my previous post, and the routes documentation :http://www.web2py.com/books/default/chapter/29/04/the-core?search=routes#Routes-on-error Did you try to set up you routes.py file? Do you have a specific problems / error messages? Can you show us some code? -- Resources: -

[web2py] inversion between values and column in sqlite3

2013-10-04 Thread loïc lauréote
Hi, i use dal.py and for sqlite i have an inversion. Do you have the same problem ? thx message : test column doesn't exist. conf : windows 7, python27 *source code :* import re from dal import DAL, Field if __name__ == '__main__': db =

[web2py] Inversion between column and values on DAL for sqlite3

2013-10-04 Thread loïc lauréote
Hi, i have an inversion in my code when i inject datas with sql statement. message : Column test doesn't exists I don't understand why. I'm on windows 7 and python 27 code : import re from dal import DAL, Field if __name__ == '__main__': dicti = {'name':12} bidul = 'bidul' db =

[web2py] Re: compound IF statement for checks on a record

2013-10-01 Thread Loïc
Did you try the following (with and in lowercase) ? if vinyl.field1 and vinyl.field2: msg=yes the both have values else: msg=no they don't Le mardi 1 octobre 2013 05:40:25 UTC+2, davedigerati a écrit : I'm checking a record to see if two fields returned with values, or are nulls,

[web2py] web2py website down

2013-09-29 Thread Loïc
Pythonanywhere seems to have some issues this morning. My web-apps were down too... Everything seems OK now. -- 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)

Re: [web2py] Re: web2py website down

2013-09-29 Thread Loïc Espern
Strange... I can access web2py.com without problem since my previous message Le 29 sept. 2013 14:08, Gour g...@atmarama.net a écrit : On Sun, 29 Sep 2013 00:09:36 -0700 (PDT) Loïc loic.esp...@gmail.com wrote: Pythonanywhere seems to have some issues this morning. My web-apps were down too

[web2py] Re: from devel list

2013-09-27 Thread Loïc
Shortly, my point is that at the moment web2py is filling specific niche of being mostly used in intranet and/or smaller apps, but by having general CMS/ecommerce app ala Mezzanine/Cartridge, the usage of the framework could exponentially increase considering other 'pros' of the framework.

Re: [web2py] Re: from devel list

2013-09-27 Thread Loïc ESPERN
a good web2py CMS is not useful, but maybe just use WP or Joomla with a custom app for client specific need in symbiosis is more money wise?? So you have best of both world... Richard On Fri, Sep 27, 2013 at 9:32 AM, Loïc loic.esp...@gmail.com wrote: Shortly, my point is that at the moment

[web2py] Re: from devel list

2013-09-27 Thread Loïc
I do not recall if I tried it...maybe it was too simple. Which one it was? Yes simple is the word :-) https://github.com/espern/tiny_website http://www.tinywebsite.net/ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

Re: [web2py] Re: from devel list

2013-09-27 Thread Loïc ESPERN
Neither do I... However I'm open to ideas/contributions to improve it, step by step Regards 2013/9/27 Gour g...@atmarama.net On Fri, 27 Sep 2013 08:12:37 -0700 (PDT) Loïc loic.esp...@gmail.com wrote: Yes simple is the word :-) :-) https://github.com/espern/tiny_website http

Re: [web2py] Re: OFF topic - Git question

2013-09-25 Thread Loïc
Hi Marin I tried what you suggested : use a symlink inside /applications folder But I get an error on my modules. I'm unsing mklink command on Win7, and my app works fine when located inside /applications folder without symlink... Do you have an idea? Ticket ID

[web2py] RESTful webservice and patterns...

2013-09-18 Thread Loïc
Hi there Trying to use @request.restful() I have an issue : *My model : * db.define_table('company',Field('name'),Field('info')) db.define_table('employee',Field('employer',db.company),Field('name'),Field( 'info')) *My controller :* @request.restful() def api(): def GET(*args,**vars):

[web2py] Re: RESTful webservice and patterns...

2013-09-18 Thread Loïc
}, /company/name/{company.name.contains} ] And it works fine. Le mercredi 18 septembre 2013 16:50:51 UTC+2, Loïc a écrit : Hi there Trying to use @request.restful() I have an issue : *My model : * db.define_table('company',Field('name'),Field('info')) db.define_table('employee

[web2py] Issue with SQLFORM.smartgrid exportclasses

2013-09-07 Thread Loïc
Hi there, I have a controller which shows some fields of my database : @auth.requires(auth.has_membership('manager') or auth.has_membership( 'event_manager')) def edit_contacts_calendar(): db.calendar_contact.event.readable = db.calendar_contact.event.writable = True

[web2py] Re: Webhosts for Web2py

2013-08-29 Thread Loïc
My apps are hosted at pythonanywhere.com People there are very helpfull and responsive. I recommend it... Le mercredi 28 août 2013 16:41:25 UTC+2, Massimo Di Pierro a écrit : Answers below. On Tuesday, 27 August 2013 16:11:22 UTC-5, Vivek Jha wrote: I am new in web development and I have

[web2py] Question for web2py-users using pythonanywhere

2013-08-19 Thread Loïc
For users who host on pythonanywhere, I have a question about web2py custom domain setup : With a paying account, can I have one webapp with two applications inside, and have two domains pointing on each application? For example : WebApp |_ MyApp1 (www.myapp1.com) |_ MyApp2 (www.myapp2.com)

[web2py] Re: Bootstrap Carousel and web2py

2013-08-07 Thread Loïc
Hello Hugo You sait the carousel is not working as you wanted, but what's is the problem? error message, wrong content, blank field, ...? For you information, here is an example of a Web2py view with a bootstrap carousel :

[web2py] Re: IS web2py good for largescale

2013-08-04 Thread Loïc
Hello Massimo Could you please elaborate the following sentence, and if possible give an example of what we should do/avoid? built-in system is ok if you have one web2py instance and if you reuse the same keys else you can have a memory leak (keys do not expire with cache.ram). Thank you --

[web2py] Re: IS web2py good for largescale

2013-08-04 Thread Loïc
Thank you Anthony. Maybe I missed a point in the book, but does memory leak with cache.ram also applies to select caching? For example when you do rows = db(query).select(cache=(cache.ram,3600),cacheable=True) Is there any way to specify the key, or to empty the cache after some time? What is

[web2py] installation

2013-08-01 Thread Loïc
You should find an answer here : https://groups.google.com/d/msg/web2py/ry8x096dKZQ/eQrnusGVsloJ And here : http://www.web2py.com/books/default/chapter/29/03/overview?search=0.0.0.0 -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To

[web2py] Problem with virtual field

2013-07-30 Thread Loïc
Did you try Field.Virtual('area_name', lambda row: db.area(row.area_id).name), ? -- --- 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] Re: New Auth and general database management functionality in appadmin

2013-07-09 Thread Loïc
Hi David, In your existing application, did you copy the new appadmin controller new appadmin.html view from the welcome app? Le mardi 9 juillet 2013 08:46:51 UTC+2, David Marko a écrit : Hi Anthony, can you help me to make it alive in my app, please? I'm using the latest trunk web2py

[web2py] Re: New Auth and general database management functionality in appadmin

2013-07-03 Thread Loïc
Hello Anthony, I have some questions about the new feature you present here : Just create an Auth group that is to be allowed access to this page and specify the role of that group in auth.settings.auth_manager_role I think the correct spelling is *auth.settings.manager_group_role*, am I

[web2py] Re: New Auth and general database management functionality in appadmin

2013-07-03 Thread Loïc
Sorry I read too fast... Thank you Anthony Le mercredi 3 juillet 2013 15:32:47 UTC+2, Anthony a écrit : Just create an Auth group that is to be allowed access to this page and specify the role of that group in auth.settings.auth_manager_role I think the correct spelling is

[web2py] Error in User Management via privileged users

2013-07-02 Thread Loïc
Hello All I try to implement User Management via privileged users ( http://web2py.com/books/default/chapter/29/09?search=User+Management+via+privileged+users#User-Management-via-privileged-users-%28Experimental%29 ) In my db.py, I added the following line after creating my auth object

[web2py] zero value in SQLFORM.factory

2013-07-02 Thread Loïc
Hello all I a controller, I define a contact form like this : form=SQLFORM.factory( Field('your_name',requires=IS_NOT_EMPTY(), label=T('Your name')), Field('your_email',requires=IS_EMAIL(), label=T('Your email')), Field('subject',requires=IS_NOT_EMPTY(),

[web2py] Re: Someone interested in a simple CMS for web2py? - SimplrCMS

2013-06-25 Thread Loïc
Hi, I don't know if RadiantCMS is still alive. But if you have basic needs (manage pages content and hierarchy) you can have a look to TinyWebsite CMS : www.tinywebsite.net Demo here : http://www.tinywebsite.net/tiny_website_DEMO/ Github repo : https://github.com/espern/tiny_website.git Le

[web2py] Re: routes_app

2013-06-13 Thread Loïc
In your web2py root folder, you have a base routes.py for example in the base routes.py you define your two applications app1 and app2 : # -*- coding: utf-8 -*- #app1 routes_app = ( (r'.*?:https?://www.app1.com:\w* /$anything', r'app1'), (r'.*?:https?://app1.com:\w* /$anything',

[web2py] Publish an app on web2py poweredby or appliances?

2013-06-10 Thread Loïc
Hello all What are the steps to publish a website/app on web2py poweredby or appliances? Thank you -- --- 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

Re: [web2py] Re: Fixed issue 1422 introduced a bug in generic rss views?

2013-06-04 Thread Loïc
Hello all, Am I the only one having issues with generic RSS views? Is there any workaround for my problem? Thank you Le dimanche 2 juin 2013 14:16:25 UTC+2, Loïc a écrit : Well, I replaced python27/lib/xml/sax/*saxutils.py *with the patched file (see attached) But I still have the same

Re: [web2py] Re: Fixed issue 1422 introduced a bug in generic rss views?

2013-05-31 Thread Loïc
rss.to_xml(encoding='utf-8') * Thank you Le jeudi 30 mai 2013 23:09:53 UTC+2, Sebastian Ortiz Vasquez a écrit : Is not mandatory, is enough appling the patch described above to the sax_parser. On Thu, May 30, 2013 at 4:08 PM, Loïc ESPERN lo...@espern.netjavascript: wrote: I'm currently using

[web2py] Re: Re-create database tables

2013-05-31 Thread Loïc
If you want to delete all tablesand recreate them, you can : * (be aware that you will lose all your data) * - Delete all your tables on MySQL (it would be a good idea to make a backup of your data before...) - Delete all files in *YourApplication/databases *folder - Launch your

Re: [web2py] Re: Fixed issue 1422 introduced a bug in generic rss views?

2013-05-30 Thread Loïc ESPERN
://bugs.python.org/issue17606 On Wednesday, May 29, 2013 8:06:07 AM UTC-5, Loïc wrote: Hi All, It seems that the fix for issue 1422 introduced a bug on generic rss views. History : https://github.com/web2py/**web2py/commit/** ea34d1b3a02223e3032d91ad9269d7**0dcfd5f0b6#gluon/serializers.**pyhttps

[web2py] Fixed issue 1422 introduced a bug in generic rss views?

2013-05-29 Thread Loïc
Hi All, It seems that the fix for issue 1422 introduced a bug on generic rss views. History : https://github.com/web2py/web2py/commit/ea34d1b3a02223e3032d91ad9269d70dcfd5f0b6#gluon/serializers.py *First error :* On* gluon/serializers.py, line 166 *if feed.get() returns *None *we can't call

[web2py] Re: Self reference, MySQL, Admin interface

2013-05-15 Thread Loïc
Hello Sergey I encountered the same issue some month ago : https://groups.google.com/forum/#!searchin/web2py/mysql$20self$20reference/web2py/qonC3j5sOmQ/7Y9QYkXBj4kJ I opened a ticket about this : http://code.google.com/p/web2py/issues/detail?id=1342 In the meanwhile, I moved my database to

[web2py] Contribute in book translation - translations sync with original file?

2013-05-08 Thread Loïc
Hi All I would like to contribute in book translation. I found an existing translation in github *web2py-book / sources / 38-web2py-french-translation-in-progress *but I have 2 questions : 1. To contribute, I fork the source repo, do my translation, commit, and then send a pull

[web2py] Re: FullCalendar Example Question

2013-05-06 Thread Loïc
Maybe it would be more clear if you can provide some code... But if I have understood your question, you can add a a text in tip property. This text will be shown when your mouse is over the event. Here is an example events: [ {{for i,row in enumerate(rows):}}{{if i!=0:}},{{pass}}

Re: [web2py] Developers/contributors guidelines?

2013-05-05 Thread Loïc
I like too! -- --- 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 more options, visit

[web2py] Re: mobile menu links won't work. %3Ca%20href=

2013-05-04 Thread Loïc
You can open a ticket here https://code.google.com/p/web2py/issues/list Le samedi 4 mai 2013 12:47:56 UTC+2, BlueShadow a écrit : Hi, I got no clue what you mean by open a ticket. There is no error ticket generated for this. Am Samstag, 4. Mai 2013 00:04:15 UTC+2 schrieb Massimo Di

[web2py] Re: routes.py

2013-05-03 Thread Loïc
mai 2013 16:57:00 UTC+2, Anthony a écrit : I think default_app just tells it where to go if there is no app, controller, or function. You probably still need to specify myApp in your routes. Anthony On Thursday, May 2, 2013 9:54:20 AM UTC-4, Loïc wrote: Thank you anthony for your quick

[web2py] Re: routes.py

2013-05-03 Thread Loïc
mai 2013 08:42:03 UTC+2, Loïc a écrit : yes default_app is just to allow access to my app at http://127.0.0.1:8000(without specifying an app name) *You probably still need to specify myApp in your routes.* In my app-specific routes;py tried #!/usr/bin/python # -*- coding: utf-8

Re: [web2py] Re: routes.py

2013-05-03 Thread Loïc
Lundell a écrit : On 3 May 2013, at 9:02 AM, Loïc loic@gmail.com javascript: wrote: After some tries, I have found a solution : In web2py folder : *routes.py* # -*- coding: utf-8 -*- routes_app = ((r'/(?Pappadmin)\b.*', r'\gapp'), (r'(.*)', r'myApp'), (r

[web2py] routes.py

2013-05-02 Thread Loïc
Hello all, I want to play with URL revrite. So I took the example in the book (http://web2py.com/books/default/chapter/29/04?search=routes_in#Pattern-based-system) In the file *web2py\applications\myApp\routes.py* I have : #!/usr/bin/python # -*- coding: utf-8 -*- routes_in = ( ('/testme',

[web2py] Re: routes.py

2013-05-02 Thread Loïc
the parameter-based and pattern-based rewrite systems -- pick one or the other. On Thursday, May 2, 2013 8:29:37 AM UTC-4, Loïc wrote: Hello all, I want to play with URL revrite. So I took the example in the book ( http://web2py.com/books/default/chapter/29/04?search=routes_in#Pattern-based-system

[web2py] Re: Webfaction account with multiple apps under 1 web2py install

2013-05-01 Thread Loïc
Did you restart your webserver / reload routes? I use a similar routes.py for multiple domains and it works fine. Maybe you could try : routers = dict( BASE = dict( domains = { 'www.domain1.com' : 'app1', 'domain1.com' : 'app1', 'www.domain2.com' :

[web2py] Re: Webfaction account with multiple apps under 1 web2py install

2013-05-01 Thread Loïc
to browse www.domain1.com/app2 to see if it doesn't direct to app2? Mine does. hmm On Wednesday, May 1, 2013 8:48:31 AM UTC-5, Loïc wrote: Did you restart your webserver / reload routes? I use a similar routes.py for multiple domains and it works fine. Maybe you could try : routers

[web2py] Re: Webfaction account with multiple apps under 1 web2py install

2013-05-01 Thread Loïc
I would like to understand too... Maybe somebody else has an idea ? -- --- 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

[web2py] Re: Webfaction account with multiple apps under 1 web2py install

2013-05-01 Thread Loïc
I would like to understand too... Maybe somebody else has an idea ? -- --- 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

[web2py] Re: recaptcha in custom forms

2013-04-26 Thread Loïc
I think you should'nt call Recaptcha with 'PUBLIC_KEY' and 'PRIVATE_KEY' as strings PUBLIC_KEY and PRIVATE_KEY should be variables that contain the keys you have created on recaptcha website ( https://www.google.com/recaptcha/admin/create) On* models\db.py* I would remove the line

[web2py] Re: Change record representation in crud form?

2013-04-24 Thread Loïc
, _name=self.fieldname, value=value) return sel *In your model file . * foodSelector = HierarchicalSelect(db,db.food.name) db.food.parent.widget = foodSelector .widget Le mardi 23 avril 2013 10:59:10 UTC+2, Loïc a écrit : Hi All I have a model

[web2py] Re: twitter error using recipe from admin page

2013-04-24 Thread Loïc
Can you show some code...? Le mercredi 24 avril 2013 11:01:05 UTC+2, 黄祥 a écrit : hi folks, i'm trying to add twitter recent tweets that i learned from admin page. but when i'm implemented it returns an error : Unable to download because: local variable 'r' referenced before assignment

[web2py] Re: DAL select odd records

2013-04-24 Thread Loïc
Hi Maybe you could try something like db().select(db.myTable.name=='Alex', groupby=db.myTable.name) Le mercredi 24 avril 2013 13:24:01 UTC+2, Ramos a écrit : hello, i have a table like Name date John 2013-01-01 John2013-01-01 Alex2013-02-02 Alex2013-02-03 Alex

[web2py] Change record representation in crud form?

2013-04-23 Thread Loïc
Hi All I have a model file : db.define_table('food', Field('parent', 'reference food', label=T('Parent')), Field('name', unique=True, notnull=True, label=T('Name')), format='%(name)s' ) Let's imagine I have some records in my db (fruits, vegetables, ...) In my controller, I

[web2py] response.files strange behaviour?

2013-04-22 Thread Loïc
Hello All, *Welcome *app, in *layout.html* line 41 : {{ response.files.append(URL('static','css/web2py.css')) response.files.append(URL('static','css/bootstrap.min.css')) response.files.append(URL('static','css/bootstrap-responsive.min.css'))

[web2py] Re: response.files strange behaviour?

2013-04-22 Thread Loïc
4:34:46 PM UTC+2, Loïc wrote: Hello All, *Welcome *app, in *layout.html* line 41 : {{ response.files.append(URL('static','css/web2py.css')) response.files.append(URL('static','css/bootstrap.min.css')) response.files.append(URL('static','css/bootstrap-responsive.min.css

[web2py] db._common_fields.append and Lazy_tables

2013-04-18 Thread Loïc
Hello All consider the example model file below : db = DAL('sqlite://storage.sqlite') signature = db.Table(db,'auth_signature', Field('created_on','datetime',default=request.now, writable=False,readable=False, label=T('Created on')),

[web2py] Re: db._common_fields.append and Lazy_tables

2013-04-18 Thread Loïc
On Thursday, April 18, 2013 7:51:19 AM UTC-4, Loïc wrote: Hello All consider the example model file below : db = DAL('sqlite://storage.sqlite') signature = db.Table(db,'auth_signature', Field('created_on','datetime',default=request.now, writable=False,readable=False, label=T

[web2py] Re: db._common_fields.append and Lazy_tables

2013-04-18 Thread Loïc
' % auth.settings.table_user_name Anthony On Thursday, April 18, 2013 7:51:19 AM UTC-4, Loïc wrote: Hello All consider the example model file below : db = DAL('sqlite://storage.sqlite') signature = db.Table(db,'auth_signature', Field('created_on','datetime',default=request.now, writable=False

[web2py] Re: db._common_fields.append and Lazy_tables

2013-04-18 Thread Loïc
:25:50 AM UTC-4, Loïc wrote: One more question Anthony, If I have other tables which reference themselves like : db.define_table('mytable',Field('myfield','string')) db.define_table('my_other_table',Field('myTable','reference mytable')) should I replace the* 'reference mytable' *statement

[web2py] Typo on web2py.com homepage

2013-04-01 Thread Loïc
Red button on the right : Sites Powere*b* by web2py Regards -- --- 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 more

[web2py] Re: update existing project model without breaking backward compatibility...

2013-03-25 Thread Loïc
söndagen den 24:e mars 2013 kl. 19:29:19 UTC+8 skrev Loïc: Hello all, let's imagine I have an app with the following model : db.define_table('contact', Field('name'), Field('phone_number') ) I have already deployed my app, and I have several contacts with a name and a phone

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread Loïc
Niphlod, I would be pleased to contribute. What should I do? Le dimanche 24 mars 2013 00:08:40 UTC+1, Niphlod a écrit : candidate for submission on the poweredby ? or appliances ? On Saturday, March 23, 2013 8:34:39 PM UTC+1, Loïc wrote: Hi Marcel For my personal use I developed a basic

[web2py] update existing project model without breaking backward compatibility...

2013-03-24 Thread Loïc
Hello all, let's imagine I have an app with the following model : db.define_table('contact', Field('name'), Field('phone_number') ) I have already deployed my app, and I have several contacts with a name and a phone number. Then I realise that a contact can have multiple phone

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread Loïc
Hi Margaret, The total size of the app is about 9MB To populate the default data, I added some pictures, and a PDF file to download. You will find pics in : *static/images/photo_gallery* and a PDF file in *static/uploaded_files* If you remove the content of these two folders, you will save

[web2py] Re: No CMS for Web2Py?

2013-03-23 Thread Loïc
Hi Marcel For my personal use I developed a basic CMS. The goal was to have something very simple to use. Some features need to be improved, but I released the project recently. You can have a look at https://github.com/espern/tiny_website Regards Le mercredi 13 mars 2013 00:06:09 UTC+1, mjm a

[web2py] Re: Field('upload') : problem with file name

2013-03-17 Thread Loïc
Thank you Niphlod, I'll try this... Le samedi 16 mars 2013 18:04:28 UTC+1, Niphlod a écrit : I was wrong. the first part of the hash is a uuid, the second is a base16 encoding of the original filename. Seems that you need some logic to cut down long files if you plan to host on Windows.

[web2py] Field('upload') : problem with file name

2013-03-16 Thread Loïc
Dear All, I have a problem with Field('upload). It seems that some file names produce an error in DAL. Let's take a test app to reproduce it. 1) A simple model : db = DAL('mysql://user:pass@myServer') db.define_table('file', Field('title', label=T('Title'), notnull=True), Field('file',

[web2py] Re: Field('upload') : problem with file name

2013-03-16 Thread Loïc
No, I have created the uploadforder. I can upload every files I want, excepted a file which is named *Audi A6 Avant 3.0 V6 TDI 240 DPF Quattro Tiptronic S Line (Break) 10_2009, Packs et options - Cote automobile - autoplus.fr.txt* regardless its content Le samedi 16 mars 2013 16:00:58 UTC+1,

[web2py] Re: Field('upload') : problem with file name

2013-03-16 Thread Loïc
...? Regards, Ales On Saturday, March 16, 2013 4:14:29 PM UTC+1, Loïc wrote: No, I have created the uploadforder. I can upload every files I want, excepted a file which is named *Audi A6 Avant 3.0 V6 TDI 240 DPF Quattro Tiptronic S Line (Break) 10_2009, Packs et options - Cote automobile

[web2py] Re: Field('upload') : problem with file name

2013-03-16 Thread Loïc
in the table ? On Saturday, March 16, 2013 4:50:41 PM UTC+1, Loïc wrote: After some tries, I discovered that the problem is not in the characters. The problem is the file name length If filename length = 76 characters it works If filename length * 76 characters* the *error *ticket is raised

[web2py] NicEdit + image upload on a textarea

2013-02-22 Thread Loïc
Dear all, I had some trouble to use the upload button in NicEdit WYSIWYG editor. Now it works, so I share an example with wou, hoping it can help somebody. This code is probably not optimized, so feel free to adapt it This code uploads images in static/images/pages_content/[Name of the page]/

[web2py] Loading component is quite slow?

2013-02-20 Thread Loïc
Hello All In my application I use the LOAD helper to insert a component in my page. The component is a simple form that allows user to subscribe to the newsletter. When I refresh the page, I see a loading... message during 2 or 3 seconds, and then my component is loaded. As my component is

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Loïc
16:07:29 UTC+1, Anthony a écrit : That seems slow. Are there other components on the page? On Wednesday, February 20, 2013 8:46:47 AM UTC-5, Loïc wrote: Hello All In my application I use the LOAD helper to insert a component in my page. The component is a simple form that allows user

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Loïc
., another component on the page), but doesn't sound like that's the problem. Anthony On Wednesday, February 20, 2013 10:28:10 AM UTC-5, Loïc wrote: No, this is the only component in the page... Just to be sure, I have tried to load my component with ajax=False {{=LOAD('default

[web2py] Re: MySQL, self-reference, and null values

2013-02-18 Thread Loïc
Done http://code.google.com/p/web2py/issues/detail?id=1342 Thanks Le lundi 11 février 2013 00:40:59 UTC+1, Massimo Di Pierro a écrit : Can you please open a ticket so the issue is tracked? On Friday, 1 February 2013 09:20:54 UTC-6, Loïc wrote: Dear All, I have a 'page' model with a sef

[web2py] MySQL, self-reference, and null values

2013-02-01 Thread Loïc
Dear All, I have a 'page' model with a sef-reference: db.define_table('page', Field('parent', 'reference page', readable=False, writable=False), Field('title', unique=True, notnull=True) //more fields not important here ) When I insert a new page via appadmin without specifying a

[web2py] Redirect from inside a component

2013-01-31 Thread Loïc
Hello All, I have a question about my application organized as follows: *A main page : render_page *A component load_newsletter. This component displays a form with an email field and a submit button What I want to do : When the user fill the form in my component load_newsletter, I want to

[web2py] Re: Redirect from inside a component

2013-01-31 Thread Loïc
redirect() - http://web2py.com/books/default/chapter/29/07?search=redirect%28#Forms-and-redirection On Thursday, January 31, 2013 4:18:37 AM UTC-5, Loïc wrote: Hello All, I have a question about my application organized as follows: *A main page : render_page *A component load_newsletter

[web2py] Re: Redirect from inside a component

2013-01-31 Thread Loïc
. Anthony On Thursday, January 31, 2013 8:16:21 AM UTC-5, Loïc wrote: Thank you, but if I use next or redirect in my component's controler, the redirection is done in the component, not in the page that contains the component. For example, I have : -Page1 which contains component1 If I