[web2py] Re: criticism of web2py

2011-10-06 Thread Gour-Gadadhara Dasa
On Wed, 5 Oct 2011 10:46:01 -0700 (PDT) Massimo Di Pierro massimo.dipie...@gmail.com wrote: We need to do this +1 When I asked in Django about some CMS, the answer was: build one your self!* * situation in the meantime has changed a bit and now there are some decentt * CMS engines like

[web2py] Re: Would there be an advantage to having more discussion on Stackoverflow?

2011-10-06 Thread Gour-Gadadhara Dasa
On Wed, 5 Oct 2011 17:17:32 -0700 (PDT) James M. sipajah...@gmail.com wrote: There is alot of activity on this newsgroup, which can make it challenging to find answers to previously asked questions... signal to noise mismatch. Hmm...I'm total noob here and can easily select/filter threads

Re: [web2py] Re: Sending Email Under Linux

2011-10-06 Thread Johann Spies
On 6 October 2011 06:42, pbreit pbreitenb...@gmail.com wrote: Check /var/log/mail.log You might want to review Postfix install instructions for your version of Linux. The Linode help docs are usually really good: http://library.linode.com/email/postfix/gateway-ubuntu-10.10-maverick But I

[web2py] Re: table, grid, smartgrid, getting better

2011-10-06 Thread guruyaya
Hummm... multiple databases won't work this way. On Aug 18, 7:28 pm, Massimo Di Pierro massimo.dipie...@gmail.com wrote: basically we almost get rid of appadmin completely and just do @auth.requires_membership('admin') def appadmin():      return dict(form=SQLFORM.grid(db[request.args(0)]))

[web2py] Generic Roll Base Authontication

2011-10-06 Thread ramkrishan bhatt
Hello This is Ramkrishan Bhatt .We are implementing the ERP at the Google App Engine platform.Where we need generic RBAC, like in webex we can give permission through admin interface.In web2py we can do that when we are using saprate crud function for each table or in db.py it self we can give

[web2py] On demond migrations

2011-10-06 Thread guruyaya
Let me start by saying that I LOVE migrations. It makes development so much easier. For me, it's the number 1 web2py killer feature: the fact I don't have to think of databses while developing. But in a production enviroment, migrations takes time and reasources. I wouldn't want to run migration

[web2py] Re: Form output format

2011-10-06 Thread miroslavgojic
Hi, I know for firebug and mozilla addons, and I use them. I try to use CDUR, crud.settings.formstyle = ('divs') and it is work after some figuring out how to get that work I don't see problem to make form in more lines, just put CR (\n) or what is notation for new line in python/web2py

[web2py] Re: Would there be an advantage to having more discussion on Stackoverflow?

2011-10-06 Thread pbreit
On one hand, that might be beneficial. On the other, it may dissipate and slow down answers. How do you really steer people there anyway?

[web2py] [SOLVED] how to do db administration of default auth tables?

2011-10-06 Thread stefaan
Near the top of the scaffolding application, it said: db = DAL('sqlite://storage.sqlite') Near the bottom of the application i had copied from my old application the following: db = SQLDB('sqlite://db.db') So the variable db was used twice to indicate different tables. I have no idea now how

Re: [web2py] Re: Form output format

2011-10-06 Thread Farsheed Ashouri
Chrome development tools is way better than firebug in my experience. On Thursday, October 6, 2011, miroslavgojic wrote: Hi, I know for firebug and mozilla addons, and I use them. I try to use CDUR, crud.settings.formstyle = ('divs') and it is work after some figuring out how to get that

Re: [web2py] Re: Form output format

2011-10-06 Thread Miroslav Gojic
You have right, Chroma developer toll is better than Firefox addons On Thu, Oct 6, 2011 at 10:56, Farsheed Ashouri farsheed.asho...@gmail.comwrote: Chrome development tools is way better than firebug in my experience. On Thursday, October 6, 2011, miroslavgojic wrote: Hi, I know for

[web2py] Re: Form output format

2011-10-06 Thread Anthony
On Thursday, October 6, 2011 3:46:04 AM UTC-4, miroslavgojic wrote: For what need web2py use next code in form on end of form definition. div class=hidden input name=_next type=hidden value=/moje0/default/people / input name=_formkey type=hidden value=335f257a-843c-4c20-8e02-

[web2py] Re: On demond migrations

2011-10-06 Thread Anthony
You could do something like this: DEVMODE = request.is_local db = DAL(..., migrate_enabled=DEVMODE) When the migrate_enabled argument to DAL() is set to False, all migrations are disabled (regardless of the 'migrate' setting for each individual define_table() call). You can either change it

[web2py] Re: table, grid, smartgrid, getting better

2011-10-06 Thread Anthony
On Thursday, October 6, 2011 3:15:41 AM UTC-4, guruyaya wrote: Hummm... multiple databases won't work this way. Can add the db as a request argument -- something like: @auth.requires_membership('admin') def appadmin(): db = globals().get(request.args(0)) if db and isinstance(db, DAL):

[web2py] Re: Sending Email Under Linux

2011-10-06 Thread horridohobbyist
It would seem that Postfix is configured correctly after all. The problem seems to be the server I've chosen -- 'smtp.gmail.com:587' works, but 'smtp.broadband.rogers.com:25' doesn't. WTF. If 'smtp.broadband.rogers.com:25' works under Windows, why the hell wouldn't it work under Linux?? Oh well.

[web2py] Re: Sending Email Under Linux

2011-10-06 Thread MidGe
If 'smtp.broadband.rogers.com:25' works under Windows, why the hell wouldn't it work under Linux?? Oh well. Maybe because windows runs a 'smtp.broadband.rogers.com:25' whereas Linux has not set such a server by default?!

[web2py] Overriding Grid/Smartgrid's 'Edit/Delete/View'

2011-10-06 Thread Johann Spies
How do I override the views/controllers triggered by the buttons mentioned in the subject line when using SQLFORM.grid/smartgrid? 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

[web2py] Room and Resource Reservation

2011-10-06 Thread António Ramos
Hello, i´d like to suggest this app Room and Resource(auto, projector etc) Reservation with a nice callendar like fullcalendar. IT think it would be very usefull for an intranet use Does anyone have something like this in web2py?

[web2py] ajax function : None returned

2011-10-06 Thread Vineet
I was studying ajax function. Exactly reproduced the code from web2py book. =default/one.html {{extend 'layout.html'}} form input id=name onkeypress=ajax('echo', ['name'], 'target') / /form div id=target /div ==default.py=== def one(): return dict() def echo():

[web2py] Re: ajax function : None returned

2011-10-06 Thread juanduke
Hi Vineet: You need to change this line; input id=name onkeyup=ajax('echo', ['name'], 'target') / for this line: input name=name onkeyup=ajax('echo', ['name'], 'target') / (change id='name' for name=name) HTH!!! Bye

[web2py] Cannot Register at wiki.web2py.com. Invalid Password

2011-10-06 Thread zanyzebra
Hello Fellow users and administrators, I was trying to register on the web2py wiki today, but could not. The password field keeps giving me a invalid error. What are the requirements for a password. I have tried using alphanumeric with special characters, with length of over 10 letters, but to

[web2py] Cannot serve any pages after fresh install of Python2.5

2011-10-06 Thread Peter G.
I had a clean install of Ubuntu 11.04 + Python 2.7.1 running web2py and it was working fine. Then I installed Python 2.5.6 by source, tried visiting http://127.0.0.1:8000/ and I get the following errors via Terminal: DEBUG_c: Exception (type 'exceptions.Exception', AttributeError('NoneType' object

[web2py] Re: Cannot Register at wiki.web2py.com. Invalid Password

2011-10-06 Thread Anthony
Don't bother -- that wiki has not been maintained for a long time. Use the book and www.web2pyslices.com. On Thursday, October 6, 2011 7:30:06 AM UTC-4, zanyzebra wrote: Hello Fellow users and administrators, I was trying to register on the web2py wiki today, but could not. The password

[web2py] Re: Overriding Grid/Smartgrid's 'Edit/Delete/View'

2011-10-06 Thread apple
You can add your own buttons using: links = [lambda row: A('Edit',_href=URL(controller,edit, args=[update, tablename, a.id])) and set editable, deletable, details to False. On Oct 6, 12:48 pm, Johann Spies johann.sp...@gmail.com wrote: How do I override the views/controllers  triggered by

[web2py] Many to many query with two left joins - how to do in Web2py?

2011-10-06 Thread Cliff
Here is the model, simplified: db.define_table('purchase_orders', Field('issue_date', 'date', comment = SPAN(a_comment, _style='color:orange;')), Field('number', length=24, requires=IS_NOT_EMPTY(), required=True, notnull=True, comment=SPAN('Required',

Re: [web2py] Re: Overriding Grid/Smartgrid's 'Edit/Delete/View'

2011-10-06 Thread Johann Spies
On 6 October 2011 14:36, apple simo...@gmail.com wrote: You can add your own buttons using: links = [lambda row: A('Edit',_href=URL(controller,edit, args=[update, tablename, a.id])) and set editable, deletable, details to False. Thanks! Johann -- May grace and peace be yours in

Re: [web2py] Re: Overriding Grid/Smartgrid's 'Edit/Delete/View'

2011-10-06 Thread Javier Pepe
Hello Along with the question of Johann, you can add new buttons to the grid / SmartGrid, because the links are render as links, and not as buttons. Thanks On Thu, Oct 6, 2011 at 9:36 AM, apple simo...@gmail.com wrote: You can add your own buttons using: links = [lambda row:

[web2py] Email Form

2011-10-06 Thread Web2Py Freak
Dear all , can anyone tell me how can i make a email form to send to my email am using webfaction for hosting .. so tell me what to do ??

[web2py] Re: Email Form

2011-10-06 Thread Anthony
Look at http://web2py.com/book/default/chapter/08#Auth-and-Mail for details on sending email. You can create a regular form, and once the form is accepted, use the form.vars (i.e., email address, message body, etc.) to send an email as per the above instructions. Anthony On Thursday, October

[web2py] Re: Email Form

2011-10-06 Thread Web2Py Freak
ok , but i want to use my gmail hassanalna...@gmail.com to send mail so i did : mail.settings.server ='smtp.gmail.com:587' # your SMTP server mail.settings.sender = 'hassanalna...@gmail.com' # your email mail.settings.login = None # your credentials or None and :

[web2py] Re: Email Form

2011-10-06 Thread Anthony
You need: mail.settings.login = 'your_username:your_password' Anthony On Thursday, October 6, 2011 10:16:01 AM UTC-4, Web2Py Freak wrote: ok , but i want to use my gmail hassan...@gmail.com to send mail so i did : mail.settings.server ='smtp.gmail.com:587' # your SMTP server

[web2py] Re: Email Form

2011-10-06 Thread Web2Py Freak
what user name and password ??

Re: [web2py] Re: Email Form

2011-10-06 Thread Manuele
On 06/10/2011 16:31, Web2Py Freak wrote: what user name and password ?? the one of your gmail account

[web2py] Web2py/modj/tomcat

2011-10-06 Thread Sergio
Hi folks, I have successfully run web2py with jython, now I'd like to run it from Tomcat using modj. I ran into two problems so far: - web2py is looking for its version file in tomcat/bin. Why the hell? - my servlet gets in the way. Let's say its address is http://host:8080/myservlet/ When

[web2py] Re: ajax function : None returned

2011-10-06 Thread Vineet
Hi juanduke ! Thanks for the tip. It worked. I will do some more complicated work on this now. Cheers, Vineet On Oct 6, 5:03 pm, juanduke juan.fu...@gmail.com wrote: Hi Vineet: You need to change this line;    input id=name onkeyup=ajax('echo', ['name'], 'target') / for this line:    

[web2py] Re: Email Form

2011-10-06 Thread Anthony
The one associated with mail.settings.sender. web2py Mail assumes you have access to an smtp mail server and attempts to send an email from that server. In this case, you are sending email from your own Gmail account. On Thursday, October 6, 2011 10:31:41 AM UTC-4, Web2Py Freak wrote: what

[web2py] Re: Would there be an advantage to having more discussion on Stackoverflow?

2011-10-06 Thread monotasker
I may be different than others, but SO is usually the first place I go with questions. I asked my first couple of web2py questions on SO and then was steered here. Massimo seems to point people here quite deliberately when they post questions on SO, and the web2py site (as well as the book)

[web2py] Re: openid server

2011-10-06 Thread selecta
i'm on it so far the only implementation i have seen is https://bitbucket.org/bottiger/web2py-openid/overview but we cannot get it get it working :( tell me if you were more successful with something

[web2py] Re: Form output format

2011-10-06 Thread miroslavgojic
Thank you, this was helpful for me. In chroma developer tools is ease way to read code and it is sorted by tags. regards Miroslav On Oct 6, 12:02 pm, Anthony abasta...@gmail.com wrote: On Thursday, October 6, 2011 3:46:04 AM UTC-4, miroslavgojic wrote: For what need web2py use next code in

[web2py] Re: Many to many query with two left joins - how to do in Web2py?

2011-10-06 Thread Massimo Di Pierro
Why do you left join products if you do not select anything from it? On Oct 6, 7:40 am, Cliff cjk...@gmail.com wrote: Here is the model, simplified: db.define_table('purchase_orders',     Field('issue_date', 'date',           comment = SPAN(a_comment, _style='color:orange;')),    

[web2py] How to setup Web2py on live Linux server

2011-10-06 Thread miroslavgojic
I have server on my academic network on public IP address On server now I use ClearOS linux and for my needs it is good. Now I have intetion to install web2py on server, can I do this on ClearOS or I must change linux What linux for server should I use, does Centos can satisfied my needs. Is

[web2py] Re: openid server

2011-10-06 Thread Anthony
Do you specifically need to create an openid server? If you just need some kind of central single sign-on solution, web2py now has built in CAS client and server functionality -- see http://web2py.com/book/default/chapter/08#Central-Authentication-Service. Anthony On Thursday, September 1,

[web2py] Re: Would there be an advantage to having more discussion on Stackoverflow?

2011-10-06 Thread Anthony
Well, it's possible that at some point Google Groups will include QA functionality, as alluded to at the end of this announcement: https://groups.google.com/d/topic/googlegroups-announce/2ccywee6dE4/discussion. The idea for the new web2pyslices.com was that it would include QA functionality

[web2py] is it possible to update the html using elements?

2011-10-06 Thread apple
web2py elements allows me to parse the dom; change attributes; and insert elements. But is it possible to remove elements entirely or to replace elements with new html? e.g. I can hide the buttons in a grid by doing this: pagination=grid.elements('.web2py_paginator') if pagination:

[web2py] SELECT / OPTGROUP

2011-10-06 Thread Dominique
Hello All, First things first: congratulations to Massimo and all those who help. Web2py is really a great framework. Even for non-professional developers like me, it is both easy and powerful. A big big thank for providing such a nice framework. I am trying to learn web2py (with an average

[web2py] Re: Building up a Query from nothing

2011-10-06 Thread howesc
how about use bruno's suggestion, but leave out the default at the top. if the list of queries is empty when you get to the reduce step then set query=(db.table.id0) otherwise do the reduce?

[web2py] Re: Overriding Grid/Smartgrid's 'Edit/Delete/View'

2011-10-06 Thread apple
If you use jqueryui then the links are rendered as buttons. On Oct 6, 1:42 pm, Javier Pepe javierp...@gmail.com wrote: Hello Along with the question of Johann, you can add new buttons to the grid / SmartGrid, because the links are render as links, and not as buttons. Thanks On Thu,

[web2py] Re: is it possible to update the html using elements?

2011-10-06 Thread Anthony
HTML helpers act as Python lists with respect to their components, so if you know the indexes, you can do things like: grid[i][j][k] = some_other_html_element del grid[i][j][k] I'm not sure if you can do assignments or deletions via .elements(), though. Anthony On Thursday, October 6, 2011

[web2py] Schema Changes in GAE

2011-10-06 Thread Joseph Jude
Hello All, As much as I wanted to avoid, eventually I had to add two columns and rename a column to an existing table in GAE which contain data. Is there a way (after much search, I'm not even asking for an easy way) to do that? Thanks, Joseph

[web2py] Re: vote for Pycharm support for Web2py

2011-10-06 Thread mikech
Bump again. The new Pycharm Early Access Program has released a new version discussed at: http://blog.jetbrains.com/pycharm/2011/10/new-pycharm-2-0-eap-build-cython-coffeescript-code-coverage/ It now has support for Cython and Coffeescript. The latter sounds very interesting.

[web2py] Re: SELECT / OPTGROUP

2011-10-06 Thread puercoespin
For selected, try (_name=region_to_search, value=bla bla bla SubRegion 3) instead of (_name=region_to_search, selected=bla bla bla SubRegion 3) On 6 oct, 18:27, Dominique mydom...@gmail.com wrote: Hello All, First things first:  congratulations to Massimo and all those who help.

[web2py] Re: SELECT / OPTGROUP

2011-10-06 Thread Dominique
Thanks for replying. value=bla bla bla SubRegion 3 already tried without success ... Any other idea ? On Oct 6, 7:27 pm, puercoespin jzaragoza.puercoes...@gmail.com wrote: For selected, try  (_name=region_to_search, value=bla bla bla  SubRegion 3) instead of (_name=region_to_search,

Re: [web2py] new feature - need help

2011-10-06 Thread Richard Vézina
A la Access?! Great... I will try to give a ride to the new smartgrid to see that... Do you have a test app or do the code you publish earlier to try the new smartgrid enable automatically the searhcable function?... I try anyway. Richard On Thu, Oct 6, 2011 at 12:01 AM, Massimo Di Pierro

[web2py] Re: Many to many query with two left joins - how to do in Web2py?

2011-10-06 Thread Cliff
Actually 'name' comes from products. Maybe it would be clearer this way: SELECT purchase_orders.issue_date, purchase_orders.number, products.name FROM purchase_orders LEFT JOIN purchase_order_products ON purchase_order_products.purchase_order_id = purchase_orders.id LEFT JOIN products ON

[web2py] Help for creating template

2011-10-06 Thread miroslavgojic
I'm trying to create, or figure-out, how to create my template for site but not go so well for now. I see some examples, main code of template is in layout.html. - is this correct Head information are manually created or with some variables. - this I understood hear I can give title to my page,

Re: [web2py] new feature - need help

2011-10-06 Thread Richard Vézina
Ok, not exactly a la access... Pretty good I notice this : = create : name = 'something' should be name == 'something' I don't think about to much about the background complexity of what you try to achieve, but I don't understand why menu is an appropriate way to display this query building

[web2py] Re: Help for creating template

2011-10-06 Thread pbreit
The default layout.html is configured with a Header, Body and Footer. It's well-commented so that's a good place to start.

[web2py] CRUD and Auth

2011-10-06 Thread miroslavgojic
Can I apply CURD to Authentication I use gluon.tools Auth but can I use CURD to Auth exactly can I use curd.settings.formstyle = 'divs' on Auth and how

Re: [web2py] new feature - need help

2011-10-06 Thread Richard Vézina
I just think for 2 min about it... A popup grid seems to me the appropriate display for this query builder... Grid : Field to search Wich type of constrainer Searched value Add createria button Drop box =, , , etc. User input + button New row Maybe a

Re: [web2py] Re: Help for creating template

2011-10-06 Thread Miroslav Gojic
I didn't find any simple example, I look at my layout.html but it is to much complicated for my needs, or I must my template from beginning to end that I can understood. I look in the book but nothing helpful for beginners, and where is that thing commented, here on the group. - - Miroslav

[web2py] SourceTree Mac hg/git client free for limited time

2011-10-06 Thread pbreit
http://www.sourcetreeapp.com/

[web2py] Re: Building up a Query from nothing

2011-10-06 Thread pbreit
I like the query = fragment approach better but am not sure how or if you can set up the default. Does anyone know if an extraneous db.item.id0 impacts the query performance at all?

[web2py] Re: Dealing with UTC and converting to local time

2011-10-06 Thread TheSweetlink
For those interested in timezones and your international site I found a nice js script after much hunting to detect utc timezone offset, whether or not it is DST, and the hemisphere of the client. https://bitbucket.org/pellepim/jstimezonedetect Another plus: Provided under the Do Whatever You

[web2py] Re: How to setup Web2py on live Linux server

2011-10-06 Thread pbreit
Should work OK I think. There are no costs or licensing needs just to run Web2py so go for it. You could review the Fedora setup script: http://code.google.com/p/web2py/source/browse/scripts/setup-web2py-fedora.sh I'm not sure it would run successfully on your setup but you can manually enter

[web2py] Re: Sending Email Under Linux

2011-10-06 Thread pbreit
It's hard to say. The problem in establishing SMTP connections frequently has to do with ports or SSL/TLS. Does Rogers have any information about connecting to it?

[web2py] Re: Cannot serve any pages after fresh install of Python2.5

2011-10-06 Thread pbreit
I'd suggest starting over with a clean install if possible. Is there some reason you are installing 2.5? If not, I'd avoid it and use what your server comes with. I use Ubuntu 10.04 which is a long term support release and comes with Python 2.6. But 11.04 should work fine, too.

[web2py] Re: On demond migrations

2011-10-06 Thread pbreit
It does seem like a button or function to run migrations might be a nice idea. Not sure how it would interact with migrate/fake_migrate settings, though. Override them all?

[web2py] Re: manual file upload using SQLFORM.factory

2011-10-06 Thread Alex
Hi David, works great, thanks! I'm now manually uploading with these few lines: field = Field('invoice_logo', 'upload', uploadfolder=os.path.join(request.folder,'uploads/')) field._tablename = 'admin_setting' uploaded_invoice_logo_filename = field.store(request.vars.invoice_logo.file,

[web2py] Re: Web2py/modj/tomcat

2011-10-06 Thread Chris Clark
On Oct 6, 7:57 am, Sergio guillaume.se...@gmail.com wrote: I have successfully run web2py with jython, now I'd like to run it from Tomcat using modj. That is awesome! What version of web2py and Jython have you got working? Could you share your patches? I ran into two problems so far:  -

Re: [web2py] Re: Help for creating template

2011-10-06 Thread Anthony
- Header: http://code.google.com/p/web2py/source/browse/applications/welcome/views/layout.html#90 - Status Bar: http://code.google.com/p/web2py/source/browse/applications/welcome/views/layout.html#100 - Main Body (including two optional sidebars):

[web2py] Re: CRUD and Auth

2011-10-06 Thread Anthony
auth.settings.formstyle = 'divs' Also, in the 'user' function, auth() returns a form object -- you can customize that as desired via the methods described here: http://web2py.com/book/default/chapter/07#Custom-forms. Note, auth() returns a different kind of form (e.g., login, registration,

[web2py] SQLFORM.grid() problem - latest trunk

2011-10-06 Thread Jim Steil
Hi I installed the latest from trunk today and am now getting the following. Traceback(most recent call last): FileC:\dev\web2py\gluon\restricted.py,line194,inrestricted execccodeinenvironment FileC:/dev/web2py/applications/FoodPantry/controllers/default.py

[web2py] Delete plugin will also delete default theme

2011-10-06 Thread Omi Chiba
See attached screen shot. 1. Download layout plugin 2. Upload to your app 3. Click delete plugin 4. Now I'm naked like attached screen. attachment: layout_plugin.JPG

Re: [web2py] Re: How to setup Web2py on live Linux server

2011-10-06 Thread Miroslav Gojic
I will tray to instal Centos and then to put web2py in online usage. After that linux installation it will be more questions - - Miroslav Gojic - - On Thu, Oct 6, 2011 at 21:51, pbreit pbreitenb...@gmail.com wrote: Should work OK I think. There are no costs or licensing needs just to

Re: [web2py] Re: CRUD and Auth

2011-10-06 Thread Miroslav Gojic
Just simple instead CRUD i put Auth and get my settings for form. I know that there is more than one form (there is three forms: login, registration, and lost password) - - Miroslav Gojic - - On Thu, Oct 6, 2011 at 22:27, Anthony abasta...@gmail.com wrote: auth.settings.formstyle = 'divs'

Re: [web2py] Re: Help for creating template

2011-10-06 Thread Miroslav Gojic
For now I have problem to put different view in specific position on page/layout I don't have to much problems with HTML/CSS - three or more columns - at 2006 I resolved this :) My problem is how to have more than one include, but I see that is possible to use include page.html and I will tray

[web2py] Re: Delete plugin will also delete default theme

2011-10-06 Thread Anthony
Have you confirmed the default theme files have actually been deleted? When using the layout plugin, had you modified your layout.html to extend the plugin layout.html, and if so, did you change it back after deleting the plugin? Anthony On Thursday, October 6, 2011 4:34:17 PM UTC-4, Omi

Re: [web2py] Re: Help for creating template

2011-10-06 Thread pbreit
Generally you only need one include, {{include}}, which is going to incorporate the content from your view. But you can also use include to specify another view file to incorporate: http://web2py.com/book/default/chapter/05#Page-Layout Example: {{include 'page.html'}} You also might check out

[web2py] Re: Many to many query with two left joins - how to do in Web2py?

2011-10-06 Thread Massimo Di Pierro
Here is your SQL: SELECT purchase_orders.issue_date, purchase_orders.number, products.name FROM purchase_orders LEFT JOIN purchase_order_products ON purchase_order_products.purchase_order_id = purchase_orders.id LEFT JOIN products ON purchase_order_products.product_id = products.id

[web2py] Re: new feature - need help

2011-10-06 Thread Massimo Di Pierro
My problem is the css. The rest we can discuss later. Anyway, field = value is correct. The search string is not DAL syntax, it is english. You can even write field equals value and otherfield starts with something without = and without quotes around values. We can add OR support later but AND

[web2py] Re: SourceTree Mac hg/git client free for limited time

2011-10-06 Thread Massimo Di Pierro
:-) On Oct 6, 2:37 pm, pbreit pbreitenb...@gmail.com wrote: http://www.sourcetreeapp.com/

[web2py] Re: Building up a Query from nothing

2011-10-06 Thread howesc
if an extraneous db.item.id0 impacts the query performance at all? depending on the system it definitely does for sufficiently complex queries. on GAE, probably no effect, on oracle,mysql, postgres it depends on how you setup your indexes - you can probably write indexes so it has close to no

[web2py] Re: Delete plugin will also delete default theme

2011-10-06 Thread Omi Chiba
Have you confirmed the default theme files have actually been deleted? Not sure where it's located... When using the layout plugin, had you modified your layout.html to extend the plugin layout.html No. It's a brand new app. I think you can also re-produce it very easily. By the way, web2py

[web2py] Opening TB Modal Window in View from Controller Form On_submit

2011-10-06 Thread D.P. Clark
I have a form created in my controller and passed by dictionary to my view. When the submit is clicked for the form, I need to open a modal window (showing a generic progress indicator) while python is processing some loops. I don't need to do any callbacks with the progress, I'm just showing a

[web2py] Re: Schema Changes in GAE

2011-10-06 Thread howesc
adding columns is a no-op. just add them in the model and viola. keep in mind that if there is no data in the columns for existing records they will not be returned in queries that filter on those columns. to rename the column (and pretty similarly to add data to a new column): - create a

[web2py] Re: GAE BULK UPLOAD AND DOWNLOAD

2011-10-06 Thread howesc
is this a one-time or a many-time operation? you can consider using the GAE bulkloader for database backup/restore: http://code.google.com/appengine/docs/python/tools/uploadingdata.html if you want the user to upload a CSV file and then process that file creating datastore records i suggest:

[web2py] Re: Delete plugin will also delete default theme

2011-10-06 Thread Anthony
Which layout plugin did you install? On Thursday, October 6, 2011 6:27:27 PM UTC-4, Omi Chiba wrote: Have you confirmed the default theme files have actually been deleted? Not sure where it's located... It would be /views/layout.html and /static/css/base.css. When using the layout

[web2py] Re: Opening TB Modal Window in View from Controller Form On_submit

2011-10-06 Thread Anthony
Can't you do it with jQuery: $(function() { $('input[type=submit]').click(function() { [code to open your modal window] }); } On Thursday, October 6, 2011 6:18:27 PM UTC-4, D.P. wrote: I have a form created in my controller and passed by dictionary to my view. When the

[web2py] Google Cloud SQL

2011-10-06 Thread pbreit
http://googlecode.blogspot.com/2011/10/google-cloud-sql-your-database-in-cloud.html

[web2py] Re: manual file upload using SQLFORM.factory

2011-10-06 Thread TheSweetlink
My pleasure Alex. I am glad that worked out for you. Now that I look at your code you got it to work in a way I didn't even think of. May we see a more complete example of your SQLFORM.factory? Massimo, I don't think I would know how to make it better other than Alex's suggestion of adding

[web2py] Re: Windows + Apache + mod_proxy

2011-10-06 Thread Paolo Caruccio
The following istructions have been adapted from http://jdoe.asidev.com/2009/02/26/configure-web2py-to-run-behind-apache-with-wsgi-mod_wsgi/ for my dev enviroment Windows + Apache + mod_wsgi. I succesfully tested connection to db2 express from IMB through pyodbc. Maybe it could help you. I

[web2py] Re: criticism of web2py

2011-10-06 Thread TheSweetlink
+1 Coming from PHP months ago I had never touched python or anything python related but was drawn to it by an article on how Disqus used python and the whole MVC concept. Tried Django but was met with less than nice responses when asking questions while reading their book. Found web2py as I

[web2py] Re: Google Cloud SQL

2011-10-06 Thread Massimo Di Pierro
I guess this finally relieves me from the non-disclosure agreement ;-) web2py has already been running on GAE+SQL since March: http://web2py-tests.appspot.com/mysql/tests All web2py apps can now run GAE. Just use a connection string like:

[web2py] question about preferred represenation and filtering

2011-10-06 Thread niknok
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 format, but it doesn't unless I define it explicitly (like in the mother

[web2py] date picker on v1.99

2011-10-06 Thread niknok
The new date picker looks very good. Is there a way to input dates by typing it directly (similar to default behaviour in older versions), in addition to selecting dates thru the calendar interface? /r Nik P.S. Though I couldn't type in a date, I could paste one. (which is a behavior I don't

[web2py] error: lambda() takes exactly 1 argument (2 given)

2011-10-06 Thread niknok
When I try form=SQLFORM.grid(db.person) with a defined represent parameter, I get the following error: lambda() takes exactly 1 argument (2 given) The person table is defined as: db.define_table('person' ,Field('birth_date', 'date', requires=IS_DATE())

[web2py] Re: Schema Changes in GAE

2011-10-06 Thread Joseph Jude
Thank you for your reply. Is there a way to run gae specific code (with gae objects) within web2py? or should this be executed only within gae environment (may be I need to modify app.yaml too then?) Thank you in advance, Joseph

[web2py] Help! import winrandom gives dll load failed error under Apache on Vista, but works under Rocket.

2011-10-06 Thread dlypka
My web2py app which uses paramiko sftp, works fine under the Rocket webserver, but fails here when run under the Apache 2.2 webserver, under WINDOWS VISTA Enterprise: • File C:\Python27\lib\site-packages\Crypto\Random\OSRNG\nt.py, line 28 import winrandom -- failing to load some DLL

[web2py] Re: date picker on v1.99

2011-10-06 Thread Massimo Di Pierro
Which browser? When I tried it, if I remember, I was able to type. On Oct 6, 8:48 pm, niknok nikolai...@gmail.com wrote: The new date picker looks very good. Is there a way to input dates by typing it directly (similar to default behaviour in older versions), in addition to selecting dates

[web2py] Re: error: lambda() takes exactly 1 argument (2 given)

2011-10-06 Thread Massimo Di Pierro
OLD syntax: represent=lambda id: settings.gender[id][1][:1]) new syntax represent=lambda id, row: settings.gender[id][1][:1]) Notice we did not break backward compatibilty because the new syntax is ONLY enforced in te new grid and smartgrid tools. On Oct 6, 8:53 pm, niknok

  1   2   >