[web2py:20230] Re: Form for adding db line does not work; input text instead of select

Massimo, thank you for a blitz reply, the problem with insertion has been solved. :) Please, have you any recommendation regarding the second thing - text input field instead of select box for foreign key? David --~--~-~--~~~---~--~~ You received this message be

[web2py:20229] Re: Compliments

also note that you can extend the Auth class (see http://web2py.com/examples/default/tools ) On Tue, Apr 21, 2009 at 7:06 PM, waTR wrote: > > CAS = Central Authentication System > You can find the plugin on the web2py website or by searching the > userg

[web2py:20228] Re: Custom auth_user problem

You need to uncomment auth.define_tables() and move it after the definition of your custom auth_user table. Massimo On 21 Apr, 22:25, TheDude wrote: > Traceback (most recent call last): >   File "/home/daniel/web2py/gluon/restricted.py", line 98, in > restricted >     exec ccode in environ

[web2py:20227] Custom auth_user problem

Traceback (most recent call last): File "/home/daniel/web2py/gluon/restricted.py", line 98, in restricted exec ccode in environment File "/home/daniel/web2py/applications/tapthat/controllers/ default.py", line 13, in File "/home/daniel/web2py/gluon/globals.py", line 75, in self._ca

[web2py:20226] Re: db.Field or SQLField??

Good to know... Those can be good subject in the new version of the book since it can be confusing for new user... I didn't know that b4. Thanks for the thread, Yannick P. On Apr 16, 10:27 pm, mdipierro wrote: > There is also the issue of form_factory. You have no DB there and must > use SQLFie

[web2py:20225] Re: Compliments

CAS = Central Authentication System You can find the plugin on the web2py website or by searching the usergroup. http://www.web2py.com/AlterEgo/default/show/49 I ended up rolling my own, as this project I am working on is also being used by me to learn the ins and outs of the framework. T2 is exc

[web2py:20224] Re: Form for adding db line does not work; input text instead of select

Can you try replace SQLField('info','blob')) with SQLField('info','blob',default='')) On 21 Apr, 16:53, dvid wrote: > Hi, > > I'm going to run a web app with database backend. I decided, that I > need something more suitable than Zope, which runs several of my > content-based site

[web2py:20223] Re: dynamically changing page headers

One option is make response.scripts=['jquery.js','whatever.js',...] and in the layout {{for script in response.scripts or []:}} {{pass}} Massimo On 21 Apr, 16:52, Tim Michelsen wrote: > Hello, > is it possible to dynamically change web page headers in view? > > I am using openlayers.org, an e

[web2py:20222] Re: Cant get db.select to work in View

Figured out it was because the line should read as follows: {{=db(db.users.id == result.author).select()[0].name}} On Apr 21, 2:43 pm, waTR wrote: > I am trying toselecta name in a table called users and display it in > a view for loop. However, I get thrown an error in the view regarding > synt

[web2py:20221] Form for adding db line does not work; input text instead of select

Hi, I'm going to run a web app with database backend. I decided, that I need something more suitable than Zope, which runs several of my content-based sites. Pylons interested me and seems to be OK for the purpose. But finally I decided to give the first try to web2py, which looks really amazing.

[web2py:20220] Re: automatically customising query result

>>> db.define_table('table1',SQLField('name',label='Name')) >> But in the output table I still get: >> table1.id table1.name. I am talking of the representation in view / html output. But the second header should be at least: ID Name ... As written in http://groups.google.com/group/web2py/browse

[web2py:20219] Re: csv export of a join select, how to?

> No API - just access to csv module settings. I think a wrapper class > would handle this well, as I tried enough other ways, and played with > the csv module enough to be convinced this is the way to go. > > I will just do it as part of web2conf upgrades, and give you a patch. > You can co

[web2py:20211] Re: csv export of a join select, how to?

Hello, > Note that returning str or select result calls a bunch of library > things, and represents this as a CSV for you. (see > gluon/sql.py/export_to_csv_file() ). > > While you may not have trouble with it (and most people, most of the > time won't), also note that this uses the csv libra

[web2py:20215] Re: automatically customising query result

Hello, sorry for comming of with this again. I defined my table like: > db.define_table('table1',SQLField('name',label='Name')) But in the output table I still get: table1.id table1.name. Why can this be? Here comes an improvement suggestion for the db admin: we can define default values for

[web2py:20214] Cant get db.select to work in View

I am trying to select a name in a table called users and display it in a view for loop. However, I get thrown an error in the view regarding syntax. I have tried displaying the contents of "result" and it does contain rows. The only thing that does not work is the line below. If I remove it, the r

[web2py:20218] Re: automatically customising query result

On 21 Apr, 16:45, Tim Michelsen wrote: > Hello, > sorry for comming of with this again. > > I defined my table like: > > > db.define_table('table1',SQLField('name',label='Name')) > > But in the output table I still get: > table1.id table1.name. > > Why can this be? tables have a unique id by d

[web2py:20217] dynamically changing page headers

Hello, is it possible to dynamically change web page headers in view? I am using openlayers.org, an external javascript library which demands to embed * a library script reference in the header * a custom css in the header How can this be done dynamically? So far, I just created new layout.htm

[web2py:20212] Re: Compliments

> As someone who started coding an app in web2py 2 weeks ago, I can say > that it is by-far the easiest framework to use. For the app I am > working on I have looked at numerous frameworks in numerous languages, > including ruby + rails, python + django/turboGears/etc, PHP + Zend, > perl + gantry

[web2py:20216] Re: Cant get db.select to work in View

I have to also mention that if I remove the [0] it displays no problem, however, it displays the header row and the data row. I want to only show the data row. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py

[web2py:20213] Re: transpose a SQLTABLE in view

> Isn't what you are trying to do similar to a matrix transform? Numpy > may have your answer. Yes, such functionality is in numpy. But I would rather not have this dependency. Maybe Massimo could help us here: What is the most elegant way to transpose a SQLTABLE in view? I think rebuilding it c

[web2py:20210] Re: Compliments

I think the only thing holding back web2py is the documentation. I have not seen any framework that rivals the simplicity and regularity of web2py, but the information about how to use it is scattered and disheveled. The wiki was a valiant try but it seems to have stalled before it became useful

[web2py:20209] Re: default values for request.vars

This is elegant. On 21 Apr, 14:57, desfrenes wrote: > Hi ! > > I was looking for a way to set default values to request.vars. I use > this: > > if request.vars.offset == None: request.vars.offset = 0 > > But maybe there is a more elegant solution ? --~--~-~--~~~---~--

[web2py:20208] Re: Compliments

It is the same but if send me patches please use the Linux/Unix convention for endlines. On 21 Apr, 14:59, Omar Munk wrote: > Windows isn't much used in the "Web-Framework-Scene":(. Do you recommend > Ubuntu or Windows for W2P developping? > > Omar > > 2009/4/21 mdipierro > > > > > Mac mostly.

[web2py:20207] Re: Compliments

Windows isn't much used in the "Web-Framework-Scene":(. Do you recommend Ubuntu or Windows for W2P developping? Omar 2009/4/21 mdipierro > > Mac mostly. > > Massimo > > On 21 Apr, 14:50, Omar Munk wrote: > > BTW, are you using MAC, Ubuntu or Windows? What are you recommend Ubuntu > or > > Wind

[web2py:20206] default values for request.vars

Hi ! I was looking for a way to set default values to request.vars. I use this: if request.vars.offset == None: request.vars.offset = 0 But maybe there is a more elegant solution ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[web2py:20205] Re: Compliments

Mac mostly. Massimo On 21 Apr, 14:50, Omar Munk wrote: > BTW, are you using MAC, Ubuntu or Windows? What are you recommend Ubuntu or > Windows? > > 2009/4/21 Omar Munk > > > We need indeed more "users". Then there can be blogs with screencasts like > > railscasts etc. But Web2Py team! This is

[web2py:20204] Re: Compliments

BTW, are you using MAC, Ubuntu or Windows? What are you recommend Ubuntu or Windows? 2009/4/21 Omar Munk > We need indeed more "users". Then there can be blogs with screencasts like > railscasts etc. But Web2Py team! This is the best looking web-framework > ever! And I even didn't use it :P. > >

[web2py:20203] Re: Compliments

We need indeed more "users". Then there can be blogs with screencasts like railscasts etc. But Web2Py team! This is the best looking web-framework ever! And I even didn't use it :P. 2009/4/21 mdipierro > > I do not know. Probably not. > > Massimo > > On 21 Apr, 13:34, mikech wrote: > > Are ther

[web2py:20202] Re: csv export of a join select, how to?

On Tue, Apr 21, 2009 at 2:12 PM, mdipierro wrote: > > This has come up before. I am not sure it is the job of web2py to do > any CSV manipulation. This is not about CSV manipulation - it is about configuring the csv library using csv library configuration methods - web2py embeds the library and

[web2py:20201] Re: Compliments

I do not know. Probably not. Massimo On 21 Apr, 13:34, mikech wrote: > Are there any blogs out there that reference web2py and also show up > on Planet Python?  I can't recall seeing any entries on my reader > about it.  This would be a good way to get the info out there. > > Mike > > On Apr 21

[web2py:20200] Re: csv export of a join select, how to?

This has come up before. I am not sure it is the job of web2py to do any CSV manipulation. If one needs a different output format it is very easy to write a handler using SQLRows and the csv module. I am not convinced we need an API for it. Massimo On 21 Apr, 13:48, Yarko Tymciurak wrote: > We

[web2py:20199] Re: csv export of a join select, how to?

Well, and that's a good (and a bad) thing... Note that returning str or select result calls a bunch of library things, and represents this as a CSV for you. (see gluon/sql.py/export_to_csv_file() ). While you may not have trouble with it (and most people, most of the time won't), also note that t

[web2py:20198] Re: Compliments

Are there any blogs out there that reference web2py and also show up on Planet Python? I can't recall seeing any entries on my reader about it. This would be a good way to get the info out there. Mike On Apr 21, 10:38 am, mdipierro wrote: > LOL. I find myself in the same situation sometime. I

[web2py:20197] Re: Compliments

All my friends are PHPers. I told them about Web2Py but they said "PHP is the most used web language". So they want to: 1. Work 4 weeks on a blog in OOP? Without the design? # W2P is already OOP. Your blog is created in less then 2 hours. 2. Cleaner # Your whole website in one file, you cant find

[web2py:20196] Re: db.table.field.represent question

You can make your own class MYSQLTABLE(SQLTABLE): def xml(self): return # look into the code for SQLTABLE and write your own representation for it. On 21 Apr, 12:42, Hans wrote: > Thanks Fran for your good hint. > Unfortunately in my case I need different field.rep

[web2py:20195] Re: db.table.field.represent question

Thanks Fran for your good hint. Unfortunately in my case I need different field.represents within one select, that's why I use the aliases. Looks like I need to alter the SQLTABLE columns content before passing it on. Hans On Apr 20, 9:46 pm, Fran wrote: > On Apr 20, 6:38 pm, mdipierro wrote:

[web2py:20194] Re: Compliments

LOL. I find myself in the same situation sometime. Isn't that fascinating? What bothers me is that there are many smart young people but the teachers do not understand it, do not appreciate it and do not foster it. If you have been on this list long enough, asked/asnwered questions and need a le

[web2py:20193] Re: Compliments

I do hope web2py will become an industry standard. I might be needing qualified web2py developers myself in a couple of years if one of my web2py based projects pans out. I'm only beginning to work with web2py but so far I'm really impressed. On Wed, Apr 22, 2009 at 1:13 AM, mdipierro wrote: >

[web2py:20192] How do I make a restricted page that I go to return after I login.

I have auth setup, but after entering my information to log into a restricted page, I get back to the index page. Wouldn't it be natural to go to the page I was at rather than to index? Basically, I need the user to login before they can see their profile. Regards, Jason Brower --~--~-

[web2py:20191] Re: web2py + pyjamas

I have updated the tutorial at http://mdp.cti.depaul.edu/AlterEgo/default/show/203 My revision works with pyjamas 0.5p1 and it uses the built-in json-rpc gateway of web2py. Please try my code and see if it works for you. On Tue, Apr 21, 2009 at 6:13 PM, Nazgi wrote: > > Hi, > >     I'm new to

[web2py:20190] Re: Compliments

Just to tell you, I am graduating from college, but I ask a 14 year old for help with my web2py. He is from Poland. Good luck and have fun! Regards, Jason Brower On Tue, 2009-04-21 at 03:39 -0700, Pynthon wrote: > Hello > > Im Pynthon and I'm 14 years old, sorry for my bad English but I come >

[web2py:20189] Re: Compliments

I expect we'll pass 1000 registered users within the next 2 weeks. If you like web2py tell your friends. The more users the more we guarantee it long term existence. I know of a company that have switched from web2py to PHP because they could not find enough qualified people. Massimo On 21 Apr,

[web2py:20188] Re: Compliments

As someone who started coding an app in web2py 2 weeks ago, I can say that it is by-far the easiest framework to use. For the app I am working on I have looked at numerous frameworks in numerous languages, including ruby + rails, python + django/turboGears/etc, PHP + Zend, perl + gantry, etc. I m

[web2py:20187] Re: if..else not working

Just to add to Yarko's reply, the tablename.fieldname syntax to access row members (as in club[0].bedrijf.status) is required when the rows come from joined tables. If the rows come from a single table then only the fieldname is used. The reason being that the resulting rows object is of type SQL

[web2py:20186] Re: transpose a SQLTABLE in view

Tim, a quick & dirty way would be as follows (note that this code is not formal, i.e. it does not use represent, formatter, etc. and neither takes into account field types such as blob and upload which need alternate handling, see the SQLTABLE source in gluon/sqlhtml.py for details. Joins are not

[web2py:20185] Re: csv export of a join select, how to?

WOW Massimo! That's almost too simple to believe it ;-) def my_exporter(): response.headers['Content-Type']='text/x-csv' response.headers['Content-Disposition']='attachment; filename=yourpreferredfilename.csv' return str(db(...).select(...)) On Apr 21, 4:57 pm, mdipierro wrote: > th

[web2py:20184] Re: web2py + pyjamas

>From a ground up development perspective is there anything about a pyjamas-web2py marriage that can't be done in web2py alone? Even for reuse this looks like a lot of work. On Apr 21, 8:21 am, mdipierro wrote: > I suggest you ask this question to the pyjamas mailing list since it > is a pyjama

[web2py:20183] Re: Compliments

I know, I have now the cutted PDF file with 70 pages. Hopefully this is easier then Rails. Rails also looked very simple but when you starting its really really hard. However Friday I'm going to buy the book hopefully! 2009/4/21 Michal Jursa > > SO SAY WE ALL!!! : > > Michal > > Pynthon wrot

[web2py:20182] Re: Validating in the server

On 21 abr, 11:59, mdipierro wrote: > I think I understand now. you do not need to worry about use of > sessions. I think the issue is that you did not write a view "default/ > show_form.html" for your action yet so you are getting the > "generic.html" one by default. > > This view includes the

[web2py:20181] any workflow engine can usage in web2py?

in my project, need WorkFlow support now, but can not found one Python WorkFlow Engine(not base Zope); any suggest? i just notice tow item: Workflow and REST How-to http://www.rexx.com/~dkuhlman/workflow_howto.html spiff-workflow - Google Code http://code.google.com/p/spiff-workflow/ but can no

[web2py:20180] Re: Validating in the server

I think I understand now. you do not need to worry about use of sessions. I think the issue is that you did not write a view "default/ show_form.html" for your action yet so you are getting the "generic.html" one by default. This view includes the session variables for debugging purposes. If you

[web2py:20179] Re: csv export of a join select, how to?

the str(..) in str(db(...).select(...)) converts the result of the slect into CSV. when you call the action "http:///my_exporter"; it returns a text page containing CSV. If you want the browser to automatically save it in a file you may want to add two lines: def my_exporter(): respons

[web2py:20178] Re: Referring url

Mind that in using http_referrer you are trusting that the browser is putting it there. On 21 Apr, 09:27, TeamBlack wrote: > Ah, yes, I understand now. It wasn't clear to me at first from looking > at the example. I've got it working now, thank you for your help > Yarko. > > TeamBlack > > On Apr

[web2py:20177] Re: Issue with module accessing redirect() method

from gluon.http import redirect from gluon.html import URL On 21 Apr, 09:25, waTR wrote: > Thanks for the great link! > > Anyone know the answer to the redirect issue? > > On Apr 21, 4:40 am, "jquery <<>> technicalbloke.com" > > wrote: > > That's a really informative link thanks! :) > > > Rog

[web2py:20176] Re: Validating in the server

On 21 abr, 11:16, mdipierro wrote: > I understand what you say but to me your form below shows (as it > should be) > > form: td> method="post">Question: class="hidden"> > value="5817fd21-660c-4004-8d52-3f4b700af1f9" /> type="hidden" value="default" /> div> > > It does not show the answers. > >

[web2py:20175] Re: csv export of a join select, how to?

how do I get my_exporter() into csv? is there a web2py function which can be called? On Apr 21, 4:17 pm, mdipierro wrote: > def my_exporter(): >     return str(db(...).select(...)) > > On 21 Apr, 08:52, Hans wrote: > > > I would like to make a controller function that does csv export of a > > j

[web2py:20174] Re: Referring url

Ah, yes, I understand now. It wasn't clear to me at first from looking at the example. I've got it working now, thank you for your help Yarko. TeamBlack On Apr 20, 11:31 pm, Yarko Tymciurak wrote: > sorry - I was "too swift" in typing (but you can see it in the link): > > You want request.env.h

[web2py:20173] Re: Issue with module accessing redirect() method

Thanks for the great link! Anyone know the answer to the redirect issue? On Apr 21, 4:40 am, "jquery <<>> technicalbloke.com" wrote: > That's a really informative link thanks! :) > > Roger. > > On Apr 21, 1:13 am, Mariano Mara wrote: > > > On 20.04.09 22:03, waTR wrote: > > > > Also, could s

[web2py:20172] Re: csv export of a join select, how to?

def my_exporter(): return str(db(...).select(...)) On 21 Apr, 08:52, Hans wrote: > I would like to make a controller function that does csv export of a > join select (similar like SQL below but into csv - temporary table ok > if necessary) . How can this be done in web2py? > > SELECT Perso

[web2py:20171] Re: Validating in the server

I understand what you say but to me your form below shows (as it should be) form:Question: It does not show the answers. I cannot reproduce your problem. Can you email me a minimalist app that exhibit the problem? If you modify a SQLFORM using append and insert it is possible that weird thing

[web2py:20170] csv export of a join select, how to?

I would like to make a controller function that does csv export of a join select (similar like SQL below but into csv - temporary table ok if necessary) . How can this be done in web2py? SELECT Persons.LastName,Orders.OrderNo INTO Persons_Order_Backup FROM Persons INNER JOIN Orders ON Persons.P_I

[web2py:20169] Re: Validating in the server

On 21 abr, 00:51, DenesL wrote: > Jose, if I understand correctly you don't want to show the drop down > with the options from the IS_IN_SET. > You can do this by changing the input widget of the field: > > db.my_table.my_field.widget=lambda self,value: >        INPUT(_type='text', _id='%s_%s'

[web2py:20168] Re: Compliments

SO SAY WE ALL!!! : Michal Pynthon wrote: > Hello > > Im Pynthon and I'm 14 years old, sorry for my bad English but I come > from Holland. However, I started to learn Python 2/3 weeks ago for > Django. When I started Django I had a lot of problems. Then I saw Grok > some of the people said t

[web2py:20167] Re: Compliments

Thank you for your comments. Mind that the "real" book is the same as the pdf book on lulu. If you have one there is no reason to spend money on the other. Massimo On 21 Apr, 05:39, Pynthon wrote: > Hello > > Im Pynthon and I'm 14 years old, sorry for my bad English but I come > from Holland. H

[web2py:20166] Re: transpose a SQLTABLE in view

Timmie, Isn't what you are trying to do similar to a matrix transform? Numpy may have your answer. On Apr 20, 1:35 pm, Tim Michelsen wrote: > >> instead of: > > >> header1              header2              header3 > >> value_row1         value_row1         value_row1 > >> value_row2         v

[web2py:20164] Compliments

Hello Im Pynthon and I'm 14 years old, sorry for my bad English but I come from Holland. However, I started to learn Python 2/3 weeks ago for Django. When I started Django I had a lot of problems. Then I saw Grok some of the people said that hosting is a big problem so they recommend me Web2Py. F

[web2py:20165] Nginx Mod_WSGI Errors

It seems like nginx mod_wsgi would not work with wsgihandler.py, or am i missing something in my setup? Or is it a known bug? Nginx is definitely calling up wsgihandler.py, as it logs error below in web2py Version 1.61.3 (Default Welcome Application). Error traceback Traceback (most recent call

[web2py:20163] Re: web2py + pyjamas

I suggest you ask this question to the pyjamas mailing list since it is a pyjamas configuration issue. Massimo On 21 Apr, 05:13, Nazgi wrote: > Hi, > >      I'm new to both web2py and pyjamas. I'm trying to write a simple > interactive form which can autopopulate select boxes based on the user

[web2py:20162] Re: Issue with module accessing redirect() method

That's a really informative link thanks! :) Roger. On Apr 21, 1:13 am, Mariano Mara wrote: > On 20.04.09 22:03, waTR wrote: > > > Also, could someone give me a link to the python doc that explains the > > use of @ such as > > > @cache... > > def myfunc(): ... > > I always recommend this article

[web2py:20161] Re: SQLFORM - inserting value for a field that isn't shown?

Great, that worked a treat :-) Now I can unhack my copy of sqlhtml.py, well partly at least! Thanks v.much, Roger On Apr 21, 6:36 am, ls1 wrote: > In your controller: > > fields=[...] > form=SQLFORM(...,fields=fields) > form.vars.hiddenField = value > > On 21 Kwi, 11:37, "web2py <<>> technica

[web2py:20160] Re: Auth - disable registration

You can call the decorator directly, or just wrap it in an internal func. On Apr 21, 11:06 am, vihang wrote: > Even better would be to be able to use decorators on it, like > @auth.requires_permission on register(). This may be asking too much, > but just wanted to see how much the auth module c

[web2py:20159] Re: SQLFORM - inserting value for a field that isn't shown?

In your controller: fields=[...] form=SQLFORM(...,fields=fields) form.vars.hiddenField = value On 21 Kwi, 11:37, "web2py <<>> technicalbloke.com" wrote: > Hi All, > > I have table with a field that I don't want to show to the user > however, I do want to set it to a value I receive in a (well

[web2py:20158] web2py + pyjamas

Hi, I'm new to both web2py and pyjamas. I'm trying to write a simple interactive form which can autopopulate select boxes based on the user selections. I tried using the application in http://mdp.cti.depaul.edu/AlterEgo/default/show/203 I've corrected the syntax errors and few ot

[web2py:20157] SQLFORM - inserting value for a field that isn't shown?

Hi All, I have table with a field that I don't want to show to the user however, I do want to set it to a value I receive in a (well vetted) get request. To this end I am calling SQLFORM with the list of fields I want rendered and deliberately missing that one out. I have tried storing the value

[web2py:20156] Re: Auth - disable registration

Even better would be to be able to use decorators on it, like @auth.requires_permission on register(). This may be asking too much, but just wanted to see how much the auth module can be stretched before one has to start tweaking the auth code... On Apr 21, 12:58 pm, vihang wrote: > I had a loo

[web2py:20155] Auth - disable registration

I had a look at the auth code, but could not find any flags to disable registration. Is there a way I can do it my have something like auth.settings.register flag in the model with other settings?? --~--~-~--~~~---~--~~ You received this message because you are subs