[web2py] Model and Controller with Web2Py, View with Excel ??

2013-11-27 Thread Py Dev
Hi, the combination web2py-DAL with python code (controller) and Excel to manipulate and chart table data would be wonderful. That would mean rapid prototyping with a lot of databases and the option to go to web later. So, is it possible to use „only“ the model and controller level from web

[web2py] Re: Create a drop-down menu from a database

2013-10-11 Thread Py Dev
Massimo, thank you very much for your example, but it does not work, here is my complete code: model: db.define_table('cities', Field('name'), Field('mystate'), format = '%(name)s' ) #db.cities.requires=IS_IN_DB(db, 'cities.id', '%(name)s')#IS_IN_DB(db,db.cities.id,'%(name)s') cont

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-10-07 Thread Py Dev
Hi Simon, I just found the problem: The line: has to be inserted after(!) {{include 'web2py_ajax.html'}} which adds jquery.js Changing that, first my inline changes were reverted, but when I adapted the location in the line jQuery('.dog_name').editable("{{=URL('jeditable', 'up

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-10-07 Thread Py Dev
Hi Simon, thanks for your quick answer! There is some progess, an other error message: :-) Error Message: Traceback *(*most recent call last*):* * *File "/Users/myname/PycharmProjects/DataBaseExamples/web2py/gluon/restricted.py"*, *line 217*, **in *restricted *

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-10-07 Thread Py Dev
Hi Tim, thanks for your tip with the jQuery Grid code. My question referred to the code from "Simon Ashley" how to use "jeditable", see best marked answer... This code is not on web2pyslices Cheers! pd my questi

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-10-05 Thread Py Dev
Hi, thank you for sharing the idea and the code! When I tried the code, I had some errors: First the second line in populate does not fit to the model: #db.fleas.truncate() #AttributeError: 'DAL' object has no attribute 'fleas' Second, the "dogs" view shows a web2py grid, I can edit it normal

[web2py] DAL: read tagged data with handle?

2013-10-03 Thread Py Dev
Hi, here is some code, that should write and read some tags, it is a slightly different version as the code in the book (5th Edition) on page 316: The write test works, but I do not get the handle to read it back. What is wrong with this code, marked in read? Thanks for your help! Cheers! pd

Re: [web2py] Re: Forcing SSL mode (on GAE)

2013-10-02 Thread Py Dev
Hi, you use the yaml configuration to force ssl, such as: handlers: - url: /youraccount/.* script: accounts.py login: required secure: always see https://developers.google.com/appengine/docs/python/config/appconfig#Python_app_yaml_Secure_URLs Cheers! pd Am Donnerstag, 7. Februar 2013

[web2py] SQLFORM.smartgrid with linked tables on gae? Search query not supported, Tickets, Debugging on gae?

2013-09-18 Thread Py Dev
Hi, first: Thank you for creating web2py, I am starting to love it :-) I tried an app with a smartgrid on gae, some questions came up: 1.) How can I make the search in smartgrid work on gae (Google App Engine)? I only get the message "query not supported" 2.) Why does the upload for a pict