Re: [web2py] returning from a controller and escaping the html...

2011-01-20 Thread rochacbruno
def return_dis(): return XML(hi there dude, escape=True|False) Em 20/01/2011, às 06:27, encompass encomp...@gmail.com escreveu: I have a control function as follows: def return_dis(): return hi there dude Of course it returns it just fine except that I would like to escape the

Re: [web2py] Re: Long-running controllers

2011-01-20 Thread António Ramos
Please add to the book your suggestion. 2011/1/19 Massimo Di Pierro massimo.dipie...@gmail.com Your code does not block the server. Only blocks the session associated to your browser to guarantee integrity of the data in your session. If you know that the block function takes time and it does

[web2py] Checkboxes(multiple) and editing data

2011-01-20 Thread Johann Spies
I have the following in a model: def horizontal_checkbox(f,v): return SQLFORM.widgets.checkboxes.widget(f,v, cols=5) Field('q3_1_1', requires = IS_IN_SET(['Training', 'Visits', 'Materials', 'Other'], multiple = True),

[web2py] Re: plugin_wiki widget jqgrid: colnames or columns?

2011-01-20 Thread blackthorne
I haven't sorted this out, but I take the title to report something that could be documented, at least in the widget builder interface. we have: ``col_width`` is the width of each column (default) looking at the code, there is also: col_widths which is a list of widths for each column Best

[web2py] Re: plugin_wiki widget jqgrid: colnames or columns?

2011-01-20 Thread blackthorne
Concerning my question, this is a bug. Here is the patch: http://www.speedyshare.com/files/26373386/plugin_wiki_jqgrid_colnames_bug.patch apply it to /application/models/plugin_wiki.py the keyword to define jqgrid header names is now colnames and it's a list of strings, such as: colnames:

[web2py] Re: plugin_wiki widget jqgrid: colnames or columns?

2011-01-20 Thread blackthorne
Sorry, that link is wrong. This is the one: http://www.speedyshare.com/files/26373484/plugin_wiki_jqgrid_colnames_bug.patch On Jan 20, 12:31 pm, blackthorne francisco@gmail.com wrote: Concerning my question, this is a bug. Here is the

[web2py] Re: plugin_wiki widget jqgrid: colnames or columns?

2011-01-20 Thread blackthorne
sorry for the mess, this is the right link. I have to stop doing patchs manually ;/ http://www.speedyshare.com/files/26373627/plugin_wiki_jqgrid_colnames_bug.patch On Jan 20, 12:36 pm, blackthorne francisco@gmail.com wrote: Sorry, that link is wrong. This is the

[web2py] Re: plugin_wiki widget jqgrid: colnames or columns?

2011-01-20 Thread blackthorne
Concerning my question, this is a bug. Here is the patch: http://www.google.com/url?sa=Dq=http://www.speedyshare.com/files/26373627/plugin_wiki_jqgrid_colnames_bug.patch apply it to /application/models/plugin_wiki.py the keyword to define jqgrid header names is now colnames and it's a list of

[web2py] Re: plugin_wiki widget jqgrid: colnames or columns?

2011-01-20 Thread blackthorne
I would also adopt the title to report something missing in the docs. There is an undocumented features, it's the keyword col_widths which is a list of numbers that defines specific widths for each jqgrid column. example: .. col_widths: 100,80,200 .. I think this should be, at least, documented

[web2py] mysql integration with web2py

2011-01-20 Thread jgp
I have developed a portal in web2py that uses sqlite and now i want to shift the database to mysql. I am trying to integrate mysql with web2py, but i am getting tickets related to inconsistency issues. Please help me in this regard. Thanks in advance JGP

[web2py] db list of blobs?

2011-01-20 Thread Jacob Gur
Hi- Is there a way to do list of blobs in db? Looks like only options are list of strings, numbers and references. GAE supports list of anything, but it looks like web2py has not implemented a way to serialize all types into a string to store in the other databases it supports. Obviously, I can

Re: [web2py] mysql integration with web2py

2011-01-20 Thread rochacbruno
Can you show the traceback or any other message you are getting? Em 20/01/2011, às 07:31, jgp jgp...@gmail.com escreveu: I have developed a portal in web2py that uses sqlite and now i want to shift the database to mysql. I am trying to integrate mysql with web2py, but i am getting tickets

Re: [web2py] mysql integration with web2py

2011-01-20 Thread Thadeus Burgess
Can you share one of the tickets? Another thing, you can add check_reserved to you DAL instantiation to make sure your not using any reserved mysql keywords. -- Thadeus On Thu, Jan 20, 2011 at 7:13 AM, rochacbruno rochacbr...@gmail.com wrote: Can you show the traceback or any other message

[web2py] Re: JSON Data

2011-01-20 Thread DenesL
You either return the json yourself or you let web2py do it. If you do it: response.headers['Content-Type']='application/json' return json.dumps(dict(id=ag.agenda.id, ...)) or if you want web2py to do it: return dict(id=ag.agenda.id, ...) and call it with .../index.json in this case

[web2py] Re: Checkboxes(multiple) and editing data

2011-01-20 Thread Massimo Di Pierro
should be: Field('q3_1_1','list:string', requires = IS_IN_SET(['Training', 'Visits', 'Materials', 'Other'], multiple = True), widget = horizontal_checkbox) because multiple requires a string. On Jan 20, 4:43 

[web2py] Re: plugin_wiki widget jqgrid: colnames or columns?

2011-01-20 Thread Massimo Di Pierro
thanks. Will process this asap. On Jan 20, 6:51 am, blackthorne francisco@gmail.com wrote: Concerning my question, this is a bug. Here is the patch:http://www.google.com/url?sa=Dq=http://www.speedyshare.com/files/263... apply it to /application/models/plugin_wiki.py the keyword to

Re: [web2py] Re: Bug? SQLFORM.factory and SQLFORM differ in handling of hidden form fields

2011-01-20 Thread Nathan VanHoudnos
Done: http://code.google.com/p/web2py/issues/detail?id=162 http://code.google.com/p/web2py/issues/detail?id=162Thanks! On Tue, Jan 18, 2011 at 4:29 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: This is a bug. Would you please post your bug report email on googlecode? I will fix it

Re: [web2py] Re: Checkboxes(multiple) and editing data

2011-01-20 Thread Johann Spies
Thank you very much! Regards Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord! His divine power has given us everything we need for life and godliness through the full knowledge of the one who called us by his own glory and excellence.

Re: [web2py] Re: JSON Data

2011-01-20 Thread contatogilson...@gmail.com
I want it to be rendered directly in the javascript: ... events: [{{}} = jsonData] _ *Gilson Filho* *Web Developer Blog:* blog.gilsondev.com *Twitter:* twitter.com/gilsonfilho 2011/1/20 DenesL denes1...@yahoo.ca You either return the json

[web2py] Re: db list of blobs?

2011-01-20 Thread Massimo Di Pierro
I am not sure I fully understand. Can you please provide an example? On Jan 20, 6:52 am, Jacob Gur ja...@camdenbody.com wrote: Hi- Is there a way to do list of blobs in db? Looks like only options are list of strings, numbers and references. GAE supports list of anything, but it looks like

[web2py] Re: geo spatial GIS in web2py

2011-01-20 Thread KK
I would really be interested in getting the code or if you can post the code somewhere. If I do something based off of that I will contribute back to the community. Thanks.

Re: [web2py] web2pyslices migration

2011-01-20 Thread Offray Vladimir Luna Cárdenas
Hi Bruno, Thanks for your work. I will insist on my idea :) of creating a web2py minimalist self-contained distributed network using it with fossil-scm and recommend keep us updated with your advances so newbies like me can learn from that process. Cheers, Offray El 18/01/11 20:16, Bruno Rocha

[web2py] Change URL

2011-01-20 Thread walter
Is there possibility to change the standard URL of the form http://my_site.net/application/default/action to something like http://my_site.net/default/action?

Re: [web2py] Change URL

2011-01-20 Thread Bruno Rocha
See autoroutes.py in the scripts folder. You need this: http://snipt.net/rochacbruno/routesconf/ and this: http://snipt.net/rochacbruno/routespy/ -- Bruno Rocha http://about.me/rochacbruno/bio 2011/1/20 walter wdv...@gmail.com Is there possibility to change the standard URL of the form

[web2py] Re: reply-to setting in Mail()

2011-01-20 Thread cjrh
On Jan 19, 12:45 am, Anthony abasta...@gmail.com wrote: the book and/or the admin interface). Also, rather than label it Epydoc (which is actually the name of the tool used to generate it), maybe call it something more descriptive, like API Documentation or Source Code Documentation. +1

[web2py] Should I store miscellaneous user data in auth_user?

2011-01-20 Thread scausten
I've got a few items of supplementary data about my users relating to my e-commerce app, including current balance, total earnings, and other bits and pieces. Because these are not directly related to access control, I have a gut feeling that I should store them in a different table and have a

Re: [web2py] Temporary changing default values of a Form

2011-01-20 Thread Arun K.Rajeevan
Does anybody know how to do it for a select box? Select box is rendered because it's a foreign key that reference another table.

[web2py] Re: web2pyslices migration

2011-01-20 Thread Arun K.Rajeevan
Great. We really need a location to point to apart from web2py.com.

Re: [web2py] Should I store miscellaneous user data in auth_user?

2011-01-20 Thread Bruno Rocha
I think the best pratice is a different table, then you make a reference between tables using the user_id. It is easy with DAL because you can do traversing, for example db.define_table('userinfo',Field('user_id',db.auth_user,requires=IS_IN_DB(...)),Field(''),Field('...')) userlist =

Re: [web2py] Re: web2pyslices migration

2011-01-20 Thread Bruno Rocha
Everything is a '*Slice*' of web2py so we want to create a place where these slices have a meeting. People, Plugins, Articles, Links, Apps, Projects etc, All in one place. We just started the work, hope to release the alpha.web2pyslices.com in few days Bruno Rocha

Re: [web2py] Temporary changing default values of a Form

2011-01-20 Thread Kenneth Lundström
Does anybody know how to do it for a select box? Select box is rendered because it's a foreign key that reference another table. After you have created the form but before if form.accepts define your default. form = SQLFORM(db...) form.vars.type = 'cleaner' if form.accepts..

[web2py] Re: Use the source, Luca

2011-01-20 Thread Arun K.Rajeevan
Source is great documentation by itself I agree. But when I started to go through source, I can see a couple of functions with no docstrings, there may be more like so. And for a total newbie to source, just be there to troubleshoot something it'll be hard. Because there's no docstrings he must

Re: [web2py] Re: Shell controllers views

2011-01-20 Thread Arun K.Rajeevan
I too was wondering after I read flame wars on reddit about web2py vs django. Do everything in the shell philosophy... ;) Also, I wanted to test my controllers and templates in the shell itself. yesterday I read the tests for the first time and saw something that does what I want. But I

Re: [web2py] Should I store miscellaneous user data in auth_user?

2011-01-20 Thread Bruno Rocha
But, if you want a customized auth_user table, here is a good example https://bitbucket.org/hc/scanme/src/743ed270faae/models/db_scanme.py Bruno Rocha http://about.me/rochacbruno/bio

[web2py] displaying process output to the screen

2011-01-20 Thread mart
Hi, Does anyone have a quick ad dirty trick to display process output to a web age (a panel or something)? Thanks, Mart :)

[web2py] Re: [off-topic] - Jquery Panels/dashboard Plugin

2011-01-20 Thread Arun K.Rajeevan
I saw a reference about jpolite when I was reading source. It's in some todo section, stating to merge jpolite with kpax (if I'm right.) Since then I was wondering what it's. I liked the app (haven't looked the source) Is it simpler than going the pyjamas way (which is complete js ui and no SEO

[web2py] pyQT web2py

2011-01-20 Thread mart
Hi, has anyone considered using pyQT within their apps? and if yes, any comments on its use? Thanks, Mart :)

[web2py] Re: sqlform.factory, inserting variable number of records in an other table

2011-01-20 Thread Arun K.Rajeevan
The more dynamic the site develops into, I think it's better to use something like GWT (or pyjams) You don't have to sacrifice SEO by building complete site in GWT but only parts of it. That way, you can utilize best of both worlds. If you are using gwt you utilize many other grate libraries

Re: [web2py] Re: web2pyslices migration

2011-01-20 Thread Arun K.Rajeevan
Is that secret is making everything slice ?!! :D

[web2py] Re: Should I store miscellaneous user data in auth_user?

2011-01-20 Thread scausten
Thanks Bruno - just out of interest, why do you prefer to use db[auth.settings.table_user_name] over db.auth_user? On Jan 20, 8:01 pm, Bruno Rocha rochacbr...@gmail.com wrote: But, if you want a customized auth_user table, here is a good example

[web2py] Re: pyQT web2py

2011-01-20 Thread blackthorne
yes, I fully recommend it. i think it's the best way of developing gui in a portable and native-respectful way. you also have Pyside. Qt creator is great. you can use Qt designer with pyuic for translation. make your questions, I will try to answer even though it is fairly offtopic. On Jan 20,

Re: [web2py] Re: sqlform.factory, inserting variable number of records in an other table

2011-01-20 Thread Richard Vézina
I am hacking a lot to build a function to parse the resultant form to insert as many rows as there is added with the js I write... It is quite tricky for me since I am not so experienced in the web2py dev... I dev app... But dev web2py is something else. I will propose something far from be

[web2py] Obtain label for field with IS_IN_SET

2011-01-20 Thread Álvaro J . Iradier
I found thread where someone asked exactly the same question I'm trying to solve: http://groups.google.com/group/web2py/browse_thread/thread/ba58ec07a23b0393/ but the question wasn't answered, quoting from the last post: --- ... In a controller I defined a form:

[web2py] Re: Obtain label for field with IS_IN_SET

2011-01-20 Thread Massimo Di Pierro
I am still not sure but I will give it a try: options=[(2,'Fitnesscentrum'),(3,'Fysiofitnesscentrum'),(4,'Personal Trainer'),(5,'Dietist(e)'),(6,'Voedingsconsulent(e)'), (7,'Yogaschool')] def index(): form=SQLFORM.factory(Field('bedrijf',requires=IS_IN_SET(options)),

[web2py] Re: pyQT web2py

2011-01-20 Thread mart
This is great to hear! I was looking at making a few pieces (with a UI) that would have both web version and non-web version! So, I made a note that blackthorne knows all about this when I get stuck! :) Thanks for that! Mart :) On Jan 20, 3:46 pm, blackthorne francisco@gmail.com wrote:

Re: [web2py] displaying process output to the screen

2011-01-20 Thread Philippe ENTZMANN
Via the Python logging module. This is a code snippet I use to set a log file (if your process is in Python) : log = logging.getLogger(checkmail) log.setLevel(logging.DEBUG) fh = logging.FileHandler(../logs/checkmail.log) fh.setLevel(logging.DEBUG) # create formatter and add

[web2py] Re: sqlform.factory, inserting variable number of records in an other table

2011-01-20 Thread mart
I would really look at the Massimo's audit trail sample to do what you are saying (or a mix of both?)... This is how I manage the request app I mentioned (Like a recipe : many tables with few Fields (like name:value) are put together... with a large enough inventory of tables it becomes easy to

[web2py] Re: displaying process output to the screen

2011-01-20 Thread mart
yeah, its all python... Are you able to refresh quickly enough (like with large file processing) ? I log everything to a few tables, so, I should be able to use what you're saying but by querying the DB instead of open/read/close a file repeatedly? This a great idea! Thanks :) On Jan 20, 4:42 

[web2py] Re: Obtain label for field with IS_IN_SET

2011-01-20 Thread Álvaro J . Iradier
Thanks Massimo, that worked perfectly. I wasn't aware of the [('id1', 'label1'), ('id2', 'label2')] syntax for IS_IN_SET. Thanks for the quick response! On 20 ene, 22:30, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I am still not sure but I will give it a try:

Re: [web2py] Re: sqlform.factory, inserting variable number of records in an other table

2011-01-20 Thread Richard Vézina
Client Address 1 client can have many address... In web2py as far as I know you will do form creating client 1 in Client table Then go in form address and add as many address you need to to a client that you pick in a dropdown. I would like to add the many address in one form : Here the

[web2py] SQLFORM not working on GAE

2011-01-20 Thread Tito Garrido
I'm using the latest version of web2py and I'm not sure why the SQLFORM is not working on GAE. Out of GAE webserver the form works as expected, but on gae it doesn't return anything, just refreshs the page... *

Re: [web2py] Re: displaying process output to the screen

2011-01-20 Thread Philippe ENTZMANN
'quickness' depends on how fast your log is filling. Log size matters too. I usually offer two views of my logs. One is a full/slow/not refreshing view of the entire file. The other is a partial/fast/auto-refreshing view of the last 20-50 lines (via a tail command). For specific realtime needs,

[web2py] Re: web2py and external editors

2011-01-20 Thread Mike Rans
Thanks very much Niphlod and Plumo. I will check out these possible solutions.

[web2py] Re: SQLFORM not working on GAE

2011-01-20 Thread Martin.Mulone
db definition?. exception message?.

[web2py] Re: displaying process output to the screen

2011-01-20 Thread mart
Good point for the use if the DB, But in this case, its for a build process, so its all about capturing and storing data. Every build creates a throw away DB, so most are short lived. Only part of the collected data throughout the build will make it to the central DB, and even then, only if it

[web2py] Re: pyQT web2py

2011-01-20 Thread blackthorne
wrong note! I like it, I consider it the best way of making GUI's for many reasons but I am beginner on it. However, I think it may be interesting the creation of systems with multiple interfaces. In fact, I had the idea of the web 6.0 :) as I called it, by defining metadata threw the web that

Re: [web2py] Re: web2pyslices migration

2011-01-20 Thread Martin.Mulone
:O the rumors run fast

[web2py] Re: pyQT web2py

2011-01-20 Thread Stefaan Himpe
Hello, It's not clear to me how you would combine PyQt (or PySide) with web2py in the same application, it doesn't seem to make much sense to me. Provided you could actually make this work, a PyQt UI embedded in a web2py application would only be visible on the server (e.g. some google data

[web2py] Adding restructuredtext support for plugin_wiki or translating to markmin

2011-01-20 Thread Offray Vladimir Luna Cárdenas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, It has been a lot of fun getting my web2py server on-line. I have tried before Zope/Plone/Cynin and MoinMoin as places for collective memory and interaction, but definitively I feel more comfortable with web2py over others and now I would

Re: [web2py] Re: SQLFORM not working on GAE

2011-01-20 Thread Tito Garrido
db.define_table('jogo', Field('nome',requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db, 'jogo.nome')]), Field('console',requires=IS_IN_SET(['PS3','Xbox','Wii'])), Field('descricao','text',requires=IS_NOT_EMPTY()), Field('foto','upload',autodelete=True, label='Capa'),

[web2py] Re: Should I store miscellaneous user data in auth_user?

2011-01-20 Thread howesc
i agree with brunounless you are running on GAE. in that case join's are not supported and are implemented as additional queries under the covers. in the GAE case i extend my auth table so that i don't have to run so many queries. db[auth.settings.table_user_name] is better than

[web2py] Re: Using mysqldb instead of pymysql

2011-01-20 Thread drayco
Hi, I did my test with trunk version this is the issue Traceback (most recent call last): File /home/drayco/web2py/gluon/restricted.py, line 188, in restricted exec ccode in environment File /home/drayco/web2py/applications/iscada/models/cfedb.py, line 16, in module migrate = False)

[web2py] index called twice

2011-01-20 Thread Art Zemon
Hello, I have a simple function in a controller and it seems to be getting called twice. Any ideas why, and what to do about it? def index(): try: rows = db( (db.gtsign.auth_user_id==request.vars['c']) \ (db.gtsign.id==request.vars['s']) \

[web2py] Re: pyQT web2py

2011-01-20 Thread blackthorne
well, I think he didn't made it clear but I see many ways: - create a component for web2py that instead of generating the html/ css/js source you use to see it in a website, it would generate the GUI application (controllers+view) as well as linking it to a shared model. This is a lot of work but

[web2py] get_or_create() for Web2py?

2011-01-20 Thread dominatus
I have a table in one of my models that I am trying to either create or update based on the current date when the user logs in. I noticed there is no explainable way to check if a current record exists in a model from within a controller function. Do we have to use: crud.create(db.schedule) or

[web2py] Re: index called twice

2011-01-20 Thread Massimo Di Pierro
Look in the view for an incorrect link like img src=xxx/ if it is a relavive url it would actually call /app/default/index/xxx and index is called twice. On Jan 20, 8:44 pm, Art Zemon a...@hens-teeth.net wrote: Hello, I have a simple function in a controller and it seems to be getting

[web2py] Re: get_or_create() for Web2py?

2011-01-20 Thread Massimo Di Pierro
what is the condition to decide whether is exists or not? On Jan 20, 7:24 pm, dominatus ffly...@gmail.com wrote: I have a table in one of my models that I am trying to either create or update based on the current date when the user logs in.  I noticed there is no explainable way to check if a

[web2py] Re: Table of Contents for plugin_wiki pages

2011-01-20 Thread blackthorne
I found this awesome! Please take a look until the final result: http://www.jankoatwarpspeed.com/post/2009/08/20/Table-of-contents-using-jQuery.aspx On Jan 17, 4:25 pm, Massimo Di Pierro massimo.dipie...@gmail.com wrote: http://code.google.com/p/samaxesjs/wiki/TableOfContentsPlugin On Jan 17,

[web2py] python web2py.py stops any any comman

2011-01-20 Thread Martin Weissenboeck
Hi, I have started web2py with the following command python web2py.py ... and I get: web2py Enterprise Web Framework use kill -SIGTERM 14688 to shudown the web2py server and nothing more! There is no prompt and I cann't input anything - seems it hangs. Anyhow web2py works: I can