[web2py] LOB variable no longer valid after subsequent fetch - again

2010-05-25 Thread JC11
Hello, I am migrating a web2py app. to Oracle. It works fine on postgresql and sqlite, but my firm demands Oracle. There is a large field in my db ( > 4000 chars) so can not be a string. Oracle creates this a clob. Often (but not always) I get the dreaded error: 'LOB variable no longer valid af

[web2py] Re: Anybody going to PyCon?

2010-05-26 Thread JC11
I sang the praises of web2py at Euro-Python last spring. My talk was not about web2py or web frameworks but about a (very corporate) application written with web2py. Perhaps more talk of what has been built with web2py rather than framework comparisons and moaning is the way to go ? John C.

[web2py] Re: turnkeylinux help

2010-03-28 Thread JC11
Is there any progress on turnkey or a vmware appliance for web2py ? I have been trying - and failing to install web2py on our (old) Red Hat Linux that has a very old Python version. A vmware appliance would be ideal. Anything I can do to help ? John C. On Mar 21, 4:21 pm, "Mark Breedveld" wro

[web2py] How to install and run web2py on Jython ?

2010-04-07 Thread JC11
Hello, Are there instructions anywhere for installig and running web2py on Jython ? A few questions I have so far: + which version of web2py (source code ?) + how and where to install database drivers ? - my attempt fails to find psycopg2. Does one use python db drivers or java drivers ?

[web2py] Re: How to install and run web2py on Jython ?

2010-04-07 Thread JC11
Thanks, I am sure I searched in the 'book', how silly of me not to find it. What about Oracle and Jython ? The last line of the entrie reads: 'You will be able to use DAL('sqlite://...') and DAL('postgres://...') only.' John C. On Apr 7, 11:54 am, Kuba Kucharski wrote: > Hi, > > here they

[web2py] Re: How to install and run web2py on Jython ?

2010-04-07 Thread JC11
> preventing excessive backtracking under Jython. If anyone runs into that > problem again, they should report it. I'm pretty sure I understand how to > avoid at least the problem we had then, by making alternations mutually > exclusive. > > > > > On Apr 7, 6:14 am, JC

[web2py] Re: How to install and run web2py on Jython ?

2010-04-08 Thread JC11
If you want me to test it, I will gladly do so. John C. -- 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

[web2py] Postgresql connection from Jython not working for me

2010-04-08 Thread JC11
The next Jython challenge ! The line: db = DAL('postgres://stubo:st...@10.220.17.77/stubo_remote', pool_size=10) works fine when running in python, but fails from Jython (see below). >From Jython I can run: 'from com.ziclix.python.sql import zxJDBC', so I think that is installed OK Tracebac

[web2py] response.render

2010-09-16 Thread JC11
Is it possible to call response.render(view, vars) in a controller, but have the view not a file, but as a string ? The reason I want to do this is that I am getting the view from a database table and replacing bits of it with python code snippets {{some code}} which response.render will evaluate.

[web2py] Re: response.render

2010-09-17 Thread JC11
Thanks, :) On Sep 16, 6:04 pm, mdipierro wrote: > from gluon.template import render > def index(): >     return render() > > look at the source code of that function it has lots of options. > > On Sep 16, 11:47 am, JC11 wrote: > > > Is it possible to call re

[web2py:18972] Save a view as a file ?

2009-04-02 Thread JC11
Hello, I would like to use the excellent template facilities in web2py views {{}} but save the results to a file rather than present them as a web page. How would this be possible ? This is just for one of several views in my application and should happen always for the one view without the

[web2py:18993] Re: Save a view as a file ?

2009-04-02 Thread JC11
; def save_file(): >      filename='bla.html' >      response.headers['Content-Disposition']='attachment; > filename="%s"' % filename >      return dict(var='whatever') > > On Apr 2, 2:07 am, JC11 wrote: > > > Hello, > &g

[web2py:19007] Re: Save a view as a file ?

2009-04-03 Thread JC11
Super, thanks. This works but with 'write' rather than 'save'. I am getting more and more impressed with web2py as I use it more. JC On Apr 2, 11:39 pm, mdipierro wrote: > open(filename,'wb').save(response.render(view_filename,dict(a=3))) > > On Apr 2,

[web2py] Anyone using memCache ? Two issues

2010-12-01 Thread JC11
Hello, I have used the local web2py cache such as: msg = cache.ram(cacheKey, lambda: getResponse(reqBody), time_expire=10), and sometimes cache.ram.clear(cacheKey) which works fine. (easy and fast !) I am now trying to use memcached and getting two errors. The first is : cache.r

[web2py] Adding application specific data to httpserver.log ?

2012-02-05 Thread JC11
Hello, I need to add logging to my application. Out of the box, httpserver.log supplies 90% of what I want, but I'd love to add another piece or two of data to it. The data to add is specific to my application and present on the incoming URLs. Any advice on where I should start ? Thanks, Joh

[web2py] Re: Adding application specific data to httpserver.log ?

2012-02-07 Thread JC11
Thank you, Would there be any harm in adding environ['QUERY_STRING'] httpserver.log as a change in your main.py source code ? This would solve my issue and perhaps help others by giving a little more detail in the logs which for REST type applications will be very useful. One line added and t