Re: [web2py] Re: To DAL or not to DAL, that is the question!

On 8 October 2011 17:19, Massimo Di Pierro wrote: > Almost any query an be build using the dal. > > How would this type of postgresql-query be translated into DAL? WITH regional_sales AS ( SELECT region, SUM(amount) AS total_sales FROM orders GROUP BY region ), top_re

Re: [web2py] Re: Web2py and LaTeX

I did not know for this, but I will check and tray... Thanks - - Miroslav Gojic - - On Mon, Oct 10, 2011 at 07:24, mdipierro wrote: > Did you look into gluon/contrib/markmin/markmin2latex.py and gluon/ > contrib/markmin/markmin2pdf.py? > > http://web2py.com/examples/static/markmin.html > > >

[web2py] Re: Google Cloud SQL

I took a second look at this today. I had it working in April but somehow it broke along the way since nobody else had access or tested it. I fixed it now in trunk. Here are some instructions: 1) read the docs: http://code.google.com/apis/sql/docs/before_you_begin.html#enroll 2) apply for a SQL i

[web2py] Re: Web2py and LaTeX

Did you look into gluon/contrib/markmin/markmin2latex.py and gluon/ contrib/markmin/markmin2pdf.py? http://web2py.com/examples/static/markmin.html On Oct 10, 12:05 am, miroslavgojic wrote: > I have some date i database, that is text and formulas in LaTeX > notation, > > From database data I wi

[web2py] Web2py and LaTeX

I have some date i database, that is text and formulas in LaTeX notation, >From database data I will extract with SQL.select -> Aray How from array I can get pdf file (i must run some latex compiler) for download. I have some list of checks, when I apply filter I need to get pdf file for downloa

Re: [web2py] Re: Threads :-)

Thanks for the response, > There are two problems: > - do not do print, breaks mod_wsgi > - do not start threads from an action because the threads are > controller by the web server and it may kill it. > Good warnings. > you should queue the task in database or cache and then run a > backgrou

[web2py] Re: Threads :-)

There are two problems: - do not do print, breaks mod_wsgi - do not start threads from an action because the threads are controller by the web server and it may kill it. you should queue the task in database or cache and then run a background task. If pushing data to redis takes too long it defies

[web2py] Threads :-)

Ok, I need to push data in a redis database. And my problem is that it takes a while while the data is pushed in. So the screen would be waiting and a user would be irritated. My solution would be something like this. if framequeue.check_frame_lock() == False: if session.deployment ==

[web2py] Re: checkboxes.widget rendering

Done. http://code.google.com/p/web2py/issues/detail?id=463 Thanks. On Monday, October 10, 2011, Massimo Di Pierro wrote: > Please open a ticket. > > On Oct 9, 3:39 am, niknok > wrote: > > When using checkboxes.widget the expected selection box disappears, > > instead a complete list is shown. I

[web2py] Re: checkboxes.widget rendering

Please open a ticket. On Oct 9, 3:39 am, niknok wrote: > When using checkboxes.widget the expected selection box disappears, > instead a complete list is shown. I couldn't explain it better, please > see this screenshot > > This happens in all my browsers: Chromium, Epiphany and Firefox. > >  che

[web2py] Re: looking for suggestions - large number of selections

Yes, actually I'm playing with them right now. Thanks. My kung-fu is not very good, and I couldn't make them work the way I like it. That's why I'm asking, just in case, there are any other suggestions. For example, adding new entries on the fly ... On Monday, October 10, 2011, Bruno Rocha wrot

Re: [web2py] looking for suggestions - large number of selections

Have you tried one of these plugins ? http://dev.s-cubism.com/web2py_plugins On Sun, Oct 9, 2011 at 5:39 AM, niknok wrote: > ** > I anticipate a huge number of entries in a person table and expect users > find it difficult to do two things: > >- selecting or viewing multiple entries >- a

[web2py] Re: Debug web2py service?

I would like to know how to enable logging.conf using Python logging. Or is it set as default waiting to be discovered useful? :) I am testing winpdb. It took sometime to set it up and figure it out. When I made it work for the first time, it was a surprise to me. I am not sure I am using it in a

[web2py] looking for suggestions - large number of selections

I anticipate a huge number of entries in a person table and expect users find it difficult to do two things: * selecting or viewing multiple entries * adding a new entry on the fly The initial person table design used a traditional mother/father set-up but same-sex parent concept m

[web2py] Re: question about preferred represenation and filtering

*bump* any inputs? On Friday, October 7, 2011, niknok wrote: > ** > I have a self-referencing table [1] with a defined format for representing > a record in this fashion: "Lastname, Firstname [-mm-dd]". In the father > field, I expect it to display the drop-down list of persons as defined in

[web2py] Re: date picker on v1.99

manual entry doesn't work on the ff browsers: - Chromium 15.0.871.0 - Epiphany/GNOME Web Browser 2.30.2 - Mozilla Firefox 3.6.22 I'm running ubuntu 10.04 On Friday, October 7, 2011, Massimo Di Pierro wrote: > Which browser? When I tried it, if I remember, I was able to type. >

Re: [web2py] Re: webfaction clean install unable to save any files in admin edit mode

Any progress with uwsgi? I am about to give up on this project and will have to wait for another to try web2py again. I have a deadline of having to renew a hosting arrangement and that date is pretty much fixed. It is now nearly two weeks since I decided to give web2py a shot and unfortunate

Re: [web2py] Re: HTML validation

Should I be able to put response.meta.test = 'test' in a controller or view? Doesn't seem to be working for me.

Re: [web2py] Re: HTML validation

On Sun, 2011-10-09 at 17:22 -0700, Jonathan Lundell wrote: > ...though I don't really understand the "if you use the .htaccess" comment. I guess "the .htaccess" AKA "custom webserver configuration" sets the http X-UA-Compatible header to "IE=edge,chrome=1"; so if that is working there's no need o

[web2py] Re: HTML validation

The nested comment issue is fixed in trunk but I did not try revalidate. On Oct 9, 7:22 pm, Jonathan Lundell wrote: > On Oct 9, 2011, at 4:29 PM, pbreit wrote: > > > Advice to beginners: don't get too hung up on stuff like that. > > Us geezers, on the other hand, worry about it, because even when

Re: [web2py] Re: HTML validation

On Oct 9, 2011, at 4:29 PM, pbreit wrote: > Advice to beginners: don't get too hung up on stuff like that. Us geezers, on the other hand, worry about it, because even when it's harmless the noise obscures real errors. In the case of the welcome app, there's a real error:

[web2py] Re: Email Verification Issue

It might be one of Google's temporary locks: https://mail.google.com/support/bin/answer.py?answer=43692 You might try the unlock captcha: https://www.google.com/accounts/UnlockCaptcha

[web2py] Re: HTML validation

Advice to beginners: don't get too hung up on stuff like that.

[web2py] Re: two SQLFORM.grid in one view?

Some code: view {{extend 'layout.html'}} {{=servers}} {{=server_capabilities}} ** controller ** def index(): links = [lambda row: A('Check status',_href=URL(c='administration', f='check_server_status/%s' % row.id))] servers = SQLFORM.grid( db.se

[web2py] Re: two SQLFORM.grid in one view?

And noticed another thing: the export button always returns results for the first table, even when clicked on the second table.

[web2py] Re: two SQLFORM.grid in one view?

Also, performing a search in one of the two grids actually results in both grids searching for the same keyword.

[web2py] two SQLFORM.grid in one view?

Hello list, I try to add two SQLFORM.grid in one view. They refer to separate tables. I have given them a separate formname. The edit and update buttons behave weird: when i press view/edit in either grid, *both* the grids display the same (expected) view/edit form. Can two SQLFORM.grid be us

[web2py] Re: [OT] python. pyc virus

For people reading and not following this. A vulnerability is a situation that allows users to do something that they should not be allowed to do. The fact that people hacked into a web site is a security issue and it can and should be prevented. The fact that after people hack into a web site the

Re: [web2py] Re: [OT] python. pyc virus

Theres nothing to be alarmed about. Any EXE can be infected. Any Libraries can be infected. In the hacking underground scene , there are infected SSH libs that behaves exactly like openssh but logs all the passwords. And there was a case where repos get hacked and replaced with trojan sshlibs. I

[web2py] HTML validation

Hello, As a beginner I find it strange that the web2py welcome app does not seem to conform with HTML. When I enter http://www.web2py.com/welcome into the form at http://validator.w3.org/ I get four errors!

Re: [web2py] Debug web2py service?

On Oct 9, 2011, at 1:40 AM, seongjoo wrote: > I use web2py providing JSONRPC services without web interface. I am > trying to find a way to debug the services so if there is one good > method, I would love to know. Thank you. web2py rocks! I've been using Python logging (via web2py logging.conf)

[web2py] Re: new feature - need help

I'm glad you like it, but it is necessary to point out that the css rules must be adapted to single layout. Especially with regard to positioning. As you can see from the picture, I used as a reference the layout of your application "issue tracker". Ciao. Paolo

[web2py] Re: Feature request - DD/DT for views

I generally opposed to adding new helpres since we can do tag.DD and tag.DT. Yet I would not oppose to modify the UL and OL logic to understand tag.DD and tag.TD On Oct 9, 12:14 pm, Guy Nesher wrote: > Hi, > > While LI are supported in the views ({{=LI()}} DD and DT dont seem > to be. > (Th

[web2py] Re: new feature - need help

Looks fantastic! I will review and add to trunk. Massimo On Oct 9, 12:13 pm, Paolo Caruccio wrote: > Hi Massimo, > > I modified the search_menu function and appended the attached css rules to > base css. > I also attached an image to show the result. > > Please note that I didn't use menu to ach

[web2py] Re: How to create SQLFORM forms in a "for" loop

I've made something like this work. Perhaps something like this is what you're looking for? *UNTESTED CODE* but same exact concept as what I got to work for me when making a list of forms. tags = db(db.tags).select() # For readability or if you need to do calculations or append more to your # SQ

[web2py] Feature request - DD/DT for views

Hi, While LI are supported in the views ({{=LI()}} DD and DT dont seem to be. (The tags DD/DT/DL are designed for definition lists and often come quite handy). This can probably wait, but can be a nice addition. Guy

[web2py] Re: Error displaying db record from admin panel

Thats what I get for blindly copying code... my bad On Oct 9, 4:05 pm, Anthony wrote: > What is the definition of the 'project' table? Does it include a 'title' > field (which is referenced in your IS_IN_DB validator)? > > > > > > > > On Sunday, October 9, 2011 10:51:59 AM UTC-4, Guy Nesher wrote

[web2py] Re: Email Verification Issue

Astonishing! A different Gmail address *did* work! I cannot understand this. Something bizarre is going on behind the scene... Richard On Oct 9, 9:59 am, Bruno Rocha wrote: > i use gmail in many sites and never had a problem. > > can you try with a different gmail address¿ > > http://zerp.ly/ro

[web2py] Re: clueTip + Web2Py Not Caching

Hello Anthony Yes I want the content to be cached by the browser. And thanks to you now I can control exactly how much time the pages are cached! The link was very usefull and the efficency has improve dramatically. Imho a must if you want to do dinamics web apps. Im still doing some tests and fo

[web2py] Re: [OT] python. pyc virus

I agree. Any program source or binary, written in any language, can be infected by worms. There are plenty of tools to do this. As a teacher, I would expect any CS graduate to know how to do this for any binary (exe) file and any good python programmed to know how to do it to Python (pyc) files. Th

[web2py] Re: Major vulnerability in Janrain+AOL

It would not be a valid email. On Oct 9, 12:43 am, Bruno Rocha wrote: > it is a bad idea to populate the email field with a dummy email generated > based in registration_id ?

[web2py] Re: Windows + Apache + mod_proxy

Paolo, Thank you again. >so it's simple compare it with your, downloading uniform server (that >is portable and install less) I will try uniform server next monday and tuesday, then update the result here. On Oct 9, 2:46 am, Paolo Caruccio wrote: > My enviroment > windows7 64 bit > Apache/2.2.

[web2py] Re: Error displaying db record from admin panel

What is the definition of the 'project' table? Does it include a 'title' field (which is referenced in your IS_IN_DB validator)? On Sunday, October 9, 2011 10:51:59 AM UTC-4, Guy Nesher wrote: > > Thats the table I'm using : > > db.define_table('file', > Field('filelink','upload'), > F

[web2py] Re: Error displaying db record from admin panel

Thats the table I'm using : db.define_table('file', Field('filelink','upload'), Field('name', requires=IS_NOT_EMPTY()), Field('filename'), Field('description', 'string'), Field('project_id',db.project), Field('createdby', db.auth_user, default=auth.user_id), Field('crea

Re: [web2py] [OT] python. pyc virus

On Sun, 2011-10-09 at 10:54 -0300, Bruno Rocha wrote: > symantec found a worm which infects. pyc files[1] > > the virus source code is in [2] > > [1] http://www.symantec.com/connect/blogs/python-has-venom > > [2] https://github.com/maurobaraldi/Pytroj I don't see where the exact risk is, a part

[web2py] Re: Error displaying db record from admin panel

What's your model code?

[web2py] Error displaying db record from admin panel

Hi, While trying to access a db record (sqllite) I'm getting this error : TRACEBACK Traceback (most recent call last): File "gluon/restricted.py", line 194, in restricted File "/Applications/web2py.app/Contents/Resources/applications/ project_tracking/controllers/appadmin.py", line 410, in

[web2py] Re: web2py book version

Keeping the online manual up to date is obviously a priority, but I think that simply forking it and keeping older version of the manual online + assigning a "major release" to each of the versions would help avoid confusion and allow users with an older web2py to still access a manual that fits th

Re: [web2py] Email Verification Issue

i use gmail in many sites and never had a problem. can you try with a different gmail address¿ http://zerp.ly/rochacbruno Em 09/10/2011 09:04, "horridohobbyist" escreveu: > I think I found a serious issue with email verification... > > I changed the following in db.py for the scaffolding app: >

[web2py] [OT] python. pyc virus

symantec found a worm which infects. pyc files[1] the virus source code is in [2] [1] http://www.symantec.com/connect/blogs/python-has-venom [2] https://github.com/maurobaraldi/Pytroj

Re: [web2py] Re: problem displaying db query result in view, inside {{for}}

Thanks Anthony. That worked. I shouldn’t be working so late on my project I make silly copy and paste mistakes. On 9 October 2011 12:25, Anthony wrote: > On Sunday, October 9, 2011 12:51:32 AM UTC-4, IK wrote: >> >> Out of 6 listing_item records, 2 didn't had price records. I deleted >> those

[web2py] Email Verification Issue

I think I found a serious issue with email verification... I changed the following in db.py for the scaffolding app: ## configure email mail=auth.settings.mailer mail.settings.server = 'smtp.gmail.com:587' mail.settings.sender = 'joeb...@gmail.com' mail.settings.login = 'joeblow:somepassword' ##

[web2py] Re: Localhost and web2py

No, nothing else, just the Seaside app. You're probably right. Richard On Oct 9, 6:18 am, Kenneth Lundström wrote: > Do you have anything else running on that webserver? If you had only > Seaside before all defaults where pointing to Seaside but after taking > web2py into your configuration file

[web2py] Re: clueTip + Web2Py Not Caching

web2py provides server-side caching capability, but it sounds like you want the content to be cached by the browser. Browser caching is controlled by the response headers. By default, the response headers for static files are set so the browser will cache, but not for pages served dynamically by

[web2py] Re: problem displaying db query result in view, inside {{for}}

On Sunday, October 9, 2011 12:51:32 AM UTC-4, IK wrote: > > Out of 6 listing_item records, 2 didn't had price records. I deleted those > two listing_item records but I'm still getting the same problem. > > To recap > {{for item ... > > {{prices=db(db.price.listing==item.id).select(or

Re: [web2py] Re: Help for creating template

On Sunday, October 9, 2011 1:56:18 AM UTC-4, miroslavgojic wrote: > > What if I need more than one menu. > > Usually I have 2 or 3 menus (top, bottom, and side) > > Can I do someting like this: > in controller > var1 = (response .menu > =(...)) >

[web2py] Re: web2py book version

Massimo is currently updating the book. The new form.process() method has been added (as well as many other newer features), but the screenshots have not yet been updated -- hence the disparity. The idea with the online book is to keep it as up-to-date as possible (we could do a lot better with

Re: [web2py] web2py book version

If I have understood correctly the online book always, we a small delay, reflect the newest version. But as the manual is called a book it might not always be obvious. Kenneth Hi guys, Just spent several frustrated hours trying to figure why the following line: "if form.process().accepted:"

Re: [web2py] Re: Localhost and web2py

Do you have anything else running on that webserver? If you had only Seaside before all defaults where pointing to Seaside but after taking web2py into your configuration files and depending on in what order different settings where loaded some default settings might have changed and not pointi

[web2py] Re: Localhost and web2py

I resolved the problem. It turns out that I needed to insert Location directives into the Apache configuration in order to grant access to the Seaside app. Why I didn't need these directives *before* I deployed web2py confounds me. Apparently, web2py did *something* to force my hand. Richard On O

[web2py] web2py book version

Hi guys, Just spent several frustrated hours trying to figure why the following line: "if form.process().accepted:" Luckly Anthony suggested I was using an older version of web2py and indeed upgrading to the latest version fixed the problem. This however brings up another problem. What version o

[web2py] Re: Problem with SQLFORM

Thanks, Upgrading solved the problem though the I was using a month old install, the book (at least the images) are much older so this really doesn't make sense... On Oct 5, 10:19 pm, Anthony wrote: > Are you using the current version of web2py? That syntax was only introduced > in the most recen

[web2py] Debug web2py service?

Hello, I use web2py providing JSONRPC services without web interface. I am trying to find a way to debug the services so if there is one good method, I would love to know. Thank you. web2py rocks!

[web2py] Re: Windows + Apache + mod_proxy

My enviroment windows7 64 bit Apache/2.2.21 (Win32) DAV/2 mod_ssl/2.2.21 OpenSSL/1.0.0e mod_wsgi/3.3 Python/2.7.2 PHP/5.3.8 pywin32-216.win32-py2.7 pyodbc-2.1.11.win32-py2.7 web2py 1.99.2 stable db2exc_974_WIN_x86_64 - IBM DB2 Express-C httpd.conf is the same as that one comes with uniform server,