[web2py] Re: JqGrid Plugin

2010-03-30 Thread parroit
Interesting, thank you. I will add autoencode parameters to the grid construnctor. I saw that setting the parameter to true will enable the encoding for all columns of the grid. Maybe, if we want to have some column with html data, it's better to encode the data in w2p? Massimo, you know an easy

[web2py] Re: appliance typo

2010-03-30 Thread hamdy.a.farag
On Mar 30, 1:41 am, Richard richar...@gmail.com wrote: would be good not to have a catch all except too, which can mask other errors. or catch them but in the same time log them via a logging system -- You received this message because you are subscribed to the Google Groups web2py-users

[web2py] Re: Cache - how to prevent session object to be cached?

2010-03-30 Thread David Zejda
I tried to move the part which asks session for the ctime value into a model: def sestime(): return session.ctime In controller there is: class Blah: def sessiontime(self): return sestime() def cache_test(): import time session.ctime = time.ctime() def blah():

[web2py] DAL Oracle Query problems

2010-03-30 Thread Jason Lotz
I'm sorry if I am repeating an existing discussion. I searched and found similar issues but nothing that helped. I am trying to query an oracle db. raw sql: SELECT fld1, fld2 FROM tbl1 WHERE fld1 20; I can successfully run the query in SQLPlus and using cx_Oracle directly in web2py. import

[web2py] Re: HTML tags in string

2010-03-30 Thread abiggs
I've made some progress by using replace to replace lt; with etc which then works in XML(). However the same approach doesn't work with the UK#39;s second for some reason. Any ideas? Cheers On Mar 27, 11:06 am, abiggs andrew.d.bi...@gmail.com wrote: Thanks, thats great. I've tried that and

[web2py] Re: Help with a query

2010-03-30 Thread Jose
On 30 mar, 04:17, weheh richard_gor...@verizon.net wrote: You need a left outer join. Here are a couple of examples that I think should work (caveat: I didn't test them): ... #way2 qry1=(db.t1.f12==10) leftjoin=db.t2.on(db.t2.f22==db.t1.id) rows=db(qry1).select(db.t2.ALL,left=leftjoin)

Re: [web2py] Re: webserver slow, misreported

2010-03-30 Thread Timothy Farrell
I don't think upgrading will help much since Cherrypy was also slow. However, doing so would help cover all your bases. If you want to use the http log from Rocket you can do this. I'm assuming you invoke web2py.py from a bash script or just run it manually. Paste the following code into

[web2py] Re: DAL Oracle Query problems

2010-03-30 Thread DenesL
On Mar 30, 4:09 am, Jason Lotz jayl...@gmail.com wrote: I'm sorry if I am repeating an existing discussion. I searched and found similar issues but nothing that helped. I am trying to query an oracle db. raw sql: SELECT fld1, fld2 FROM tbl1 WHERE fld1 20; I can successfully run the

[web2py] Re: JqGrid Plugin

2010-03-30 Thread mdipierro
For strings import cgi cgi.escape(string) On Mar 30, 1:40 am, parroit andrea.par...@ebansoftware.net wrote: Interesting, thank you. I will add autoencode parameters to the grid construnctor. I saw that setting the parameter to true will enable the encoding for all columns of the grid.

[web2py] Generic Template in AJAX response

2010-03-30 Thread Skiros
Hello! I have a strange error when loading dynamic content with AJAX. When the controller receives a parameter in the URL and made a call with AJAX the result is formatted with generic template. As example can prove the correct behavior (without parameter):

[web2py] Re: how to troubleshoot admin errors?

2010-03-30 Thread ciastek
Yarko, thanks for detailed description, but it's not a problem. If there were no parameters_xxx.py file, I could not log in admin interface. The problem is, that I can log in, but admin is unable to create new application. At the end of setup-web2py-ubuntu.sh file we can find: cd

[web2py] Re: Generic Template in AJAX response

2010-03-30 Thread mdipierro
Yes the problem is that the callback URL in the example is not written by the book. You will find that this: http://web2py.com/examples/simple_examples/ajaxwiki works fine but this http://web2py.com/examples/simple_examples/ajaxwiki/ does not. Because the example contains (for short)

[web2py] Re: how to troubleshoot admin errors?

2010-03-30 Thread mdipierro
web2py.w2p is built when you first install web2py or when you upgrade. This is trigggered by the presence of an empty file called NEWINSTALL, If this file is present welcome.w2p is created and then file is deleted. On Mar 30, 9:46 am, ciastek ciasteczk...@gmail.com wrote: Yarko, thanks for

[web2py] Re: file upload / download

2010-03-30 Thread topher.baron
Hi again, I've solved my problem. I took a look at the appadmin file download example to find a solution. Thanks rubber duck! On Mar 30, 10:01 am, topher.baron topher.ba...@gmail.com wrote: Hi all, I have XML being generated on the client side using javascript - more specifically its SVG

Re: [web2py] Re: Survey: Functionality of the Drop Boxes widget

2010-03-30 Thread Thadeus Burgess
Here are the results from two sources, A) The survey, and B) Listing of community members speaking for one or the other. A) Survey - 12 Responses ( No way to determine if anybody spammed responses ) There are no significant differences in usage scales, the hypothesis is that it only matters for

Re: [web2py] Inserting into multiple related tables.

2010-03-30 Thread Thadeus Burgess
user_id = db.users.insert(.) contact = db.contacts.insert(user = user_id, user_recording='/hi/') So insert returns the id of the newly inserted record.. If you want the actual object of what you just inserted you need user = db.user[db.users.insert(...)] Now you can perform,

[web2py] Models in YAML

2010-03-30 Thread blackthorne
Do you consider interesting to be able to define web2py models in YAML that shall be translated to DAL Python code and then SQL according to your DBMS ? thank you, Best Regards -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this

Re: [web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-30 Thread Thadeus Burgess
Any status on xls2web2py? -Thadeus On Wed, Mar 17, 2010 at 9:38 AM, mdipierro mdipie...@cs.depaul.edu wrote: The problem with appadmin is that it is designed for the administrator and has security issues. A user can execute any python code he/she wants in the query string. This is a

[web2py] Stored Procedures DAL

2010-03-30 Thread Thadeus Burgess
Is it possible? -Thadeus -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit

[web2py] Here's a theory question

2010-03-30 Thread Thadeus Burgess
How do you MVC a javascript client application? So I have web2py acting as the server, and I write a Javascript GUI (based off extjs or similar library). So of course this goes in the View files... The interesting question is that these client side js have their own MCV on top of that (models

[web2py] Re: [web2py:38402] Re: SQLFORM without tables

2010-03-30 Thread Thadeus Burgess
Of course, the decoupling would require an entire re-write of how validation/forms/filters are written... See you explain this system that each part relies on another part working a certain way... when I analyze this through my programming filter to solve this problem this is what I see... A

[web2py] Re: [web2py:38394] Re: SQLFORM without tables

2010-03-30 Thread Thadeus Burgess
I have about two or three pages in my saved drafts about this subject :) I just havn't had the time to sit down and figure out a real workable solution that can integrate into everything else web2py does. Your right, the defaults are integrated into everything, everything from default widgets

[web2py] Re: [web2py:38474] Re: template, static files, routes.py

2010-03-30 Thread Thadeus Burgess
Alright, look at this example. helloworld always gets printed, the function is not being redefined as expected. This is a simple example, but in theory I would use this for say the websites sidebar not the page title... Any suggestions I have require changes to gluon and add support for blocks.

Re: [web2py] Stored Procedures DAL

2010-03-30 Thread Kuba Kucharski
I remember massimo's answer in this subject, calling them yes - with executesql, but writing no, as they are db platform specific -- Kuba -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to

Re: [web2py] Here's a theory question

2010-03-30 Thread Timothy Farrell
This is my best understanding (using ExtJS as an case-study): Models -- Stores (Generally these communicate with the server side) Views -- Layouts + Widgets (these generate and respond to events) Controllers -- Events that control interactions between widgets and stores Ext has simplified

Re: [web2py] Here's a theory question

2010-03-30 Thread Thadeus Burgess
Aye, this I understand, but for every web2py view, you need a js (model, view, controller). The question is how should these be physically laid out while still keeping symbolism as they all are apart of the same web2py view? -Thadeus On Tue, Mar 30, 2010 at 1:45 PM, Timothy Farrell

Re: [web2py] Here's a theory question

2010-03-30 Thread Timothy Farrell
I think you're trying to over-complicate things. web2py is built around the idea of the server-client (or request-response) relationship. While capable of Ajax, the default paradigm of web2py reloads pages on most requests. In this model (not to be confused with the Model portion of MVC),

[web2py] Re: Here's a theory question

2010-03-30 Thread Yarko Tymciurak
On Mar 30, 1:01 pm, Thadeus Burgess thade...@thadeusb.com wrote: How do you MVC a javascript client application? Here's the simple of it: An application is ... an application. Layered applications are partitioned into layers for (among other things) a clean interface between layers. This is

Re: [web2py] Re: Here's a theory question

2010-03-30 Thread Thadeus Burgess
If you are with me so far, then Thadeus's question sounds like where do I put the client-code, to keep it MVC-like in organization, to help me keep my sanity during development and revision You hit the nail on the head. In the simplest form of the issue. To take an idea from gaming. There

[web2py] Re: Inserting into multiple related tables.

2010-03-30 Thread mdipierro
Notice you can do user = db.users.insert(name=John) print user 1 print isinstance(user,int) True print user.name John magic! On Mar 30, 12:18 pm, Thadeus Burgess thade...@thadeusb.com wrote: user_id = db.users.insert(.) contact = db.contacts.insert(user = user_id,

[web2py] Re: Does fake_migrate work?

2010-03-30 Thread mdipierro
web2py.com/book or web2py.com/AlterEgo On Mar 30, 12:44 pm, Thadeus Burgess thade...@thadeusb.com wrote: Where would be the most appropriate places to place this explanation? -Thadeus On Fri, Feb 26, 2010 at 5:09 PM, villas villa...@gmail.com wrote: @Thadeus,  Thanks for such a

[web2py] Re: template, static files, routes.py

2010-03-30 Thread mdipierro
{{def title():}} helloworld {{return}} On Mar 30, 1:02 pm, Thadeus Burgess thade...@thadeusb.com wrote: Alright, look at this example. helloworld always gets printed, the function is not being redefined as expected. This is a simple example, but in theory I would use this for say the websites

[web2py] web layouts

2010-03-30 Thread elegant_hippie
I have a few questions 1) I'm a new user - I would like to learn how to change layouts in web2py and possibly add javacript, ajax etc. 2) How to I view the changes I make? I have been playing with the code but can't seem to understand how to view the changes I make. probably very basic question

[web2py] Re: Ajax and Auth API

2010-03-30 Thread Yannick
Thanks for the note I followed your instructions step by step unfortunately even this solution doesn't work... the Action dictate the display, I have NO control on the view... # #here is the view Register.html: # {{=form.custom.begin}} Full Name: input class=string id=auth_user_fullname

[web2py] Re: web layouts

2010-03-30 Thread mdipierro
look into http://gluonframework.wordpress.com/2010/03/22/skinning-web2py/ and this http://web2py.com/book/default/section/5/4 hope it helps. Massimo On Mar 30, 5:30 pm, elegant_hippie elegant.hip...@gmail.com wrote: I have a few questions 1) I'm a new user - I would like to learn how to

[web2py] Re: Ajax and Auth API

2010-03-30 Thread mdipierro
One more try.. closer to the solutions... view as before and action def register(): ... next = URL(r=request,f='index') return dict(form=auth.register(onaccept=lambda form: (updateInfo(form),response.headers.update({'web2py-component- command':document.location='%s'%next} On

[web2py] Integrating GeoModel on AppEngine

2010-03-30 Thread Dane
Hey all, I need to do some geospatial queries for my current project. Unfortunately, GAE doesn't allow multiple numerical comparisons in one query, so proximity queries based on latitude/longitude columns are out. GeoModel to the rescue (http://code.google.com/p/geomodel/). By extending