[web2py:18482] Re: Full documentation

2009-03-23 Thread cjparsons

A lot of free documentation is available, including example code in
the posts on this mailing list.

The web2py book is very reasonably priced, especially in PDF form. As
I understand it, the documentation is in the form of a proper
publication because Massimo has developed web2py in the context of his
job as a lecturer at DePaul University. As an associate professor, his
employers judge his performance mainly on the number of publications
he makes. Unfortunately free documentation wouldn't count, hence the
deal with Wiley to publish the book.

There is an effort to develop a comprehensive web2py wiki that is in
its early stages. It's available here https://mdp.cti.depaul.edu/wiki

Chris
On Mar 23, 3:10 am, Álvaro Justen [Turicas] 
wrote:
> Hello,
> firstly, congratulations for the job in web2py, Massimo!
>
> I downloaded and printed web2py's manual and only when I was reading I
> see that it was incomplete.
> That is a reason for doesn't exist a free full documentation?
> Free documentation is very good, but I want to learn more advanced
> features of web2py and have some troubles in buying in international
> shops (I'm from Brazil).
>
> Thanks,
>
> --
>  Álvaro Justen
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18480] Re: How to hide the console window?

2009-03-23 Thread cjparsons

I have renamed web2py.py to web2py.pyw and then start web2py using a
shortcut with target set to
\web2py.pyw -t
You need to have .pyw appropriately set up as a file type in windows
explorer for this to work I think. I had installed a windows
distribution of Python before I had web2py, and I the installation
process set this up.

The extra 'w' on the Python file extension means 'don't open a console
window'

Chris

On Mar 22, 3:52 pm, Iceberg  wrote:
> Tried but that does not help. :-P
>
> We need something similar to the effect of hstart.exe's:
>   hstart /NOCONSOLE "web2py.exe -i 0.0.0.0 -a  -t"
>
> On Mar22, 11:06pm, mdipierro  wrote:
>
>
>
> > try
>
> > web2py -a blah -p 8000
>
> > Not sure.
>
> > On Mar 21, 10:44 pm, Iceberg  wrote:
>
> > > Hi pals,
>
> > > I am using web2py 's windows distribution. Is there some way to hide
> > > the console window (a.k.a. the black dos window) in which web2py is
> > > running?  I already know about:
> > >   web2py.exe -a blah -t
> > > can start web2py in the systray of Microsoft Windows system, but the
> > > console itself is still there and it is somewhat annoying and
> > > meaningless to end users.
>
> > > I heard this can be done if using source code, just rename the main
> > > web2py.py to web2py.pyw, on Windows platform.
>
> > > And this can also be done if using py2exe to build windows
> > > distribution package, like 
> > > this:http://ubuntuforums.org/showthread.php?t=728170
>
> > > But I don't know how things go in current web2py world. Can we just
> > > have a web2py.exe as current situation, and one more web2pyw.exe that
> > > does not have a console window?
>
> > > Thanks for any hint.
>
> > > Regards,
> > > Iceberg- Hide quoted text -
>
> - Show quoted text -
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18481] jquery jqGrid JSON url problem

2009-03-23 Thread ed

Hi,
I've been trying to execute a jquery jqGrid url to return JSON data
but failed. Only a blank table with exact headings is displayed. I
tried changing the url several times but no data is displayed. The
following is part of the code.
--





[web2py:18483] Re: Qusestion about the book?

2009-03-23 Thread Baron

> I would stay away from this kind of posting.  At worst, you are presuming a
> legal position on how to take copyrighted material without consequences.

Perhaps Massimo could step in to clarify his position to prevent
speculation. So far I've read that he needs to publish for the
university, but it is possible to publish and give away
simultaneously, as the Django Book shows.

Clearly a lot of time was spent on the manual so it is understandable
for a person to want to maintain ownership. However Massimo also spent
a lot of time on web2py but still gave it away.

The wiki right now is still pretty empty and doesn't look like
approaching the coverage of the manual for a long time. So, would it
be possible to kick start the documentation effort by allowing the
copying of text sections from the manual?

Baron
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18484] Re: How to hide the console window?

2009-03-23 Thread Iceberg

Thanks Chris but that is not the case. I already know the py and pyw
difference but that only works when you have python distribution
installed on the target PC. What I am talking about is trying to
achieve same pyw effect on a PC with no python available but only
web2py_win package is installed. Thanks anyway.

On Mar23, 5:12pm, cjparsons  wrote:
> I have renamed web2py.py to web2py.pyw and then start web2py using a
> shortcut with target set to
> \web2py.pyw -t
> You need to have .pyw appropriately set up as a file type in windows
> explorer for this to work I think. I had installed a windows
> distribution of Python before I had web2py, and I the installation
> process set this up.
>
> The extra 'w' on the Python file extension means 'don't open a console
> window'
>
> Chris
>
> On Mar 22, 3:52 pm, Iceberg  wrote:
>
> > Tried but that does not help. :-P
>
> > We need something similar to the effect of hstart.exe's:
> >   hstart /NOCONSOLE "web2py.exe -i 0.0.0.0 -a  -t"
>
> > On Mar22, 11:06pm, mdipierro  wrote:
>
> > > try
>
> > > web2py -a blah -p 8000
>
> > > Not sure.
>
> > > On Mar 21, 10:44 pm, Iceberg  wrote:
>
> > > > Hi pals,
>
> > > > I am using web2py 's windows distribution. Is there some way to hide
> > > > the console window (a.k.a. the black dos window) in which web2py is
> > > > running?  I already know about:
> > > >   web2py.exe -a blah -t
> > > > can start web2py in the systray of Microsoft Windows system, but the
> > > > console itself is still there and it is somewhat annoying and
> > > > meaningless to end users.
>
> > > > I heard this can be done if using source code, just rename the main
> > > > web2py.py to web2py.pyw, on Windows platform.
>
> > > > And this can also be done if using py2exe to build windows
> > > > distribution package, like 
> > > > this:http://ubuntuforums.org/showthread.php?t=728170
>
> > > > But I don't know how things go in current web2py world. Can we just
> > > > have a web2py.exe as current situation, and one more web2pyw.exe that
> > > > does not have a console window?
>
> > > > Thanks for any hint.
>
> > > > Regards,
> > > > Iceberg- Hide quoted text -
>
> > - Show quoted text -
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18485] Change Control Process for web2py

2009-03-23 Thread dbb

All:

It is very important to have change control process for web2py, this
change control process  will include :
   - formal submission of idea or improvement using a form
   - voting on the idea or improvement with supporting reasonings
   - incorporating the the idea or improvements into the next
release
   - every release must be deposited in a storage area and kept
there for  certain time
   - removing old versions from the official storage will when
support for that version is
 no longer feasible
   - annoucement is sent to all members when old version is no
longer supported
   - There must be board of directors selected from the exiting
members to decide the
  direction of web2py

web2py Documentation :
- all releases must have documentations for each new feature
and stored in an
   official site togther with web2py framework
 - access to web2py should be limited to members only
web2py members:
  - all members must pay a fee to hire students to write
documentations, to test
 integrate applications into web2py framework, and to
cover some of Massimo's
 expenses
   - the fee will be determined by the board of directors, my
suggestion is 20 USD
 per month
   - all fee paying members will have all access to
documentation and real time
 anwers for the creator, of course , that is Massimo
Any suggestions!!


Best Regards:
dbb

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18486] problems with a query

2009-03-23 Thread Marco Prosperi

hi all, I would like to make a query to fetch records in reverse
order. The manual says to use ˜ by I get this error (everything works
if a eliminate ˜). On web2py (maybe not after pasting the message in
googlegroups) the arrow indicating the problems point to ˜. Am I
missing something or is a problem with my Italian settings? thanks,
Marco

Error ticket for "X"
Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c-
fb62-423d-81a8-27058eccb348


Error traceback



Traceback (most recent call last):
  File "gluon/restricted.py", line 97, in restricted
  File "C:/web2py_win159/web2py/applications/crm/controllers/
default.py", line 66
for i,r in enumerate(db().select
(db.allineamento_erp.data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)):
 
^
SyntaxError: invalid syntax



In file: C:\web2py_win159\web2py\applications\crm/controllers/
default.py


#!/usr/bin/python
# -*- coding: utf-8 -*-

response.title = "New X"
response.application = "X"


if auth.user: response.menu=[
['-Logout-',False,URL(r=request,f='user',args=['logout'])],
['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict
(query='db.contatti.id>0'))],
['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict
(query='db.operatori.id>0'))],
['Tipi attività',False,URL(r=request,f='select',args=
['db'],vars=dict(query='db.tipiattivita.id>0'))
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18487] under load

2009-03-23 Thread AchipA

I have an interesting situation, where while in a Apache/WSGI 1
process environment, running under high load (which makes this a
likely race condition/lock issue) web2py just explodes:

[Mon Mar 23 14:19:44 2009] [error] Traceback (most recent call last):
[Mon Mar 23 14:19:44 2009] [error]   File "/var/www/web2py/gluon/
sql.py", line 859, in define_table
[Mon Mar 23 14:19:44 2009] [error] query = t._create(migrate=args
['migrate'])
[Mon Mar 23 14:19:44 2009] [error]   File "/var/www/web2py/gluon/
sql.py", line 1183, in _create
[Mon Mar 23 14:19:44 2009] [error] sql_fields_old = cPickle.load
(tfile)
[Mon Mar 23 14:19:44 2009] [error] EOFError

If I moderate myself and lower the load on the particular instance,
everything works nice. Anybody encounter anything similar ?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18488] Re: Web2py in Debug mode ?

2009-03-23 Thread Kent Borg

DenesL wrote:
> Despite its misleading name Winpdb is a platform independent GPL
>   

[...]

> In a hurry? just read:
> http://groups.google.com/group/web2py/msg/ee46125b7c93fdd4
>   

In quickly trying it, it seems to work great!


Thanks,

-kb


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18489] html META error

2009-03-23 Thread notabene

META('',_http-equiv='content-type',_content='text/html',
_charset='utf-8')
or
TAG.meta('',_http-equiv='content-type',_content='text/html',
_charset='utf-8')
or
META(_charset='utf-8')

returns

SyntaxError:  tags cannot have components
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18490] Re: Full documentation

2009-03-23 Thread Tito Garrido
Alvaro you should check http://mdp.cti.depaul.edu/AlterEgo
There is some documentation there...

On Mon, Mar 23, 2009 at 6:33 AM, cjparsons  wrote:

>
> A lot of free documentation is available, including example code in
> the posts on this mailing list.
>
> The web2py book is very reasonably priced, especially in PDF form. As
> I understand it, the documentation is in the form of a proper
> publication because Massimo has developed web2py in the context of his
> job as a lecturer at DePaul University. As an associate professor, his
> employers judge his performance mainly on the number of publications
> he makes. Unfortunately free documentation wouldn't count, hence the
> deal with Wiley to publish the book.
>
> There is an effort to develop a comprehensive web2py wiki that is in
> its early stages. It's available here https://mdp.cti.depaul.edu/wiki
>
> Chris
> On Mar 23, 3:10 am, Álvaro Justen [Turicas] 
> wrote:
> > Hello,
> > firstly, congratulations for the job in web2py, Massimo!
> >
> > I downloaded and printed web2py's manual and only when I was reading I
> > see that it was incomplete.
> > That is a reason for doesn't exist a free full documentation?
> > Free documentation is very good, but I want to learn more advanced
> > features of web2py and have some troubles in buying in international
> > shops (I'm from Brazil).
> >
> > Thanks,
> >
> > --
> >  Álvaro Justen
> >
>


-- 
Linux User #387870
.
 _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:___

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18491] Re: jquery jqGrid JSON url problem

2009-03-23 Thread Mike

Hey Ed,

We're using jqGrid with XML data. Something thoughts (if you haven't
tried them already):

1.) Try your grid with the FireBug plugin for FireFox and look at the
response being returned to the grid. I've had web2py tickets thown at
that point and the only to see it is via Firebug. Or just check for
tickets from the admin app

2.) Did you set the response headers? in my case I had to
use...response.headers["Content-Type"]="text/xml"

3.) What does your controller look like? In my controller that serves
up the XML I just return a string with the XML data "return xml"
instead of "return dict(xml = xml)"

Hope that helps. I like jqGrid since it has excellent documentation
and hope more of us can make it work with web2py.

Mike

On Mar 23, 5:27 am, ed  wrote:
> Hi,
> I've been trying to execute a jquery jqGrid url to return JSON data
> but failed. Only a blank table with exact headings is displayed. I
> tried changing the url several times but no data is displayed. The
> following is part of the code.
> ---­---
>
>  type="text/javascript">
> 
> 
> 

[web2py:18492] Re: Full documentation

2009-03-23 Thread dbb

That is why like all  other new applications ( framework)let us pay
membership fee for web2py to grow and be a household name.
The fee will help take some of the trivial work to a payed student and
Massimo be available to the difficult task what is ahead.
I know Yaro and others, whom I am learning their names as I progress
with web2py, are people that help web2py be at this stage; the fee
will help them too focus on the demanding task ahead.

Best Regards:

Debebe Asefa,Ph.D.


On Mar 22, 11:10 pm, Álvaro Justen [Turicas] 
wrote:
> Hello,
> firstly, congratulations for the job in web2py, Massimo!
>
> I downloaded and printed web2py's manual and only when I was reading I
> see that it was incomplete.
> That is a reason for doesn't exist a free full documentation?
> Free documentation is very good, but I want to learn more advanced
> features of web2py and have some troubles in buying in international
> shops (I'm from Brazil).
>
> Thanks,
>
> --
>  Álvaro Justen
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18493] Re: html META error

2009-03-23 Thread DenesL


Try:

META(**{'_http-equiv':'content-type','_content':'text/
html','_charset':'utf-8'})

note: you need the dictionary syntax since _http-equiv is an invalid
identifier in Python and can not be used as a keyword argument.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18494] Re: html META error

2009-03-23 Thread notabene

Thats it - Thank You!

On 23 Mar., 18:57, DenesL  wrote:
> Try:
>
> META(**{'_http-equiv':'content-type','_content':'text/
> html','_charset':'utf-8'})
>
> note: you need the dictionary syntax since _http-equiv is an invalid
> identifier in Python and can not be used as a keyword argument.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18495] Re: problems with a query

2009-03-23 Thread Hilbert Markus

hi,

this looks like a scripting error to me.
i'm not a web2py-developer right now, but have some knowledge on  
python...

the linebreak after select makes the mess:
for i,r in enumerate(db().select(db.allineamento_erp.data_allineamento,

orderby=˜db.allineamento_erp.data_allineamento)):
whatever stuff you want to do with i and r

the way you wrote it a variable called 'select' on db() is expected  
not the method db().select()

regards
iham

On Mar 23, 2009, at 3:18 PM, Marco Prosperi wrote:

>
> hi all, I would like to make a query to fetch records in reverse
> order. The manual says to use ˜ by I get this error (everything works
> if a eliminate ˜). On web2py (maybe not after pasting the message in
> googlegroups) the arrow indicating the problems point to ˜. Am I
> missing something or is a problem with my Italian settings? thanks,
> Marco
>
> Error ticket for "X"
> Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c-
> fb62-423d-81a8-27058eccb348
>
>
> Error traceback
>
>
>
> Traceback (most recent call last):
>  File "gluon/restricted.py", line 97, in restricted
>  File "C:/web2py_win159/web2py/applications/crm/controllers/
> default.py", line 66
>for i,r in enumerate(db().select
> (db 
> .allineamento_erp 
> .data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)):
>
> ^
> SyntaxError: invalid syntax
>
>
>
> In file: C:\web2py_win159\web2py\applications\crm/controllers/
> default.py
>
>
> #!/usr/bin/python
> # -*- coding: utf-8 -*-
>
> response.title = "New X"
> response.application = "X"
>
>
> if auth.user: response.menu=[
>['-Logout-',False,URL(r=request,f='user',args=['logout'])],
>['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict
> (query='db.contatti.id>0'))],
>['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict
> (query='db.operatori.id>0'))],
>['Tipi attività',False,URL(r=request,f='select',args=
> ['db'],vars=dict(query='db.tipiattivita.id>0'))
> >


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18496] Re: How to hide the console window?

2009-03-23 Thread Fran

On Mar 22, 3:44 am, Iceberg  wrote:
> I am using web2py 's windows distribution. Is there some way to hide
> the console window (a.k.a. the black dos window) in which web2py is
> running?

I run as a service using:
http://mdp.cti.depaul.edu/AlterEgo/default/show/77

I get no console window.

PS This thread may also be useful:
http://groups.google.com/group/web2py/browse_thread/thread/733896d0aec07d3e

F
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18497] Re: problems with a query

2009-03-23 Thread Marco Prosperi

thanks for the time you spent on my question but I don't have any
linebreak in my code after 'select'. It appears in my post after
copying the error message from web2py and pasting it to googlegroups.
If I cancel the character ˜  everything works fine in my application

Marco


On 23 Mar, 19:14, Hilbert Markus  wrote:
> hi,
>
> this looks like a scripting error to me.
> i'm not a web2py-developer right now, but have some knowledge on  
> python...
>
> the linebreak after select makes the mess:
> for i,r in enumerate(db().select(db.allineamento_erp.data_allineamento,
>                                                         
> orderby=˜db.allineamento_erp.data_allineamento)):
>         whatever stuff you want to do with i and r
>
> the way you wrote it a variable called 'select' on db() is expected  
> not the method db().select()
>
> regards
> iham
>
> On Mar 23, 2009, at 3:18 PM, Marco Prosperi wrote:
>
>
>
> > hi all, I would like to make a query to fetch records in reverse
> > order. The manual says to use ˜ by I get this error (everything works
> > if a eliminate ˜). On web2py (maybe not after pasting the message in
> > googlegroups) the arrow indicating the problems point to ˜. Am I
> > missing something or is a problem with my Italian settings? thanks,
> > Marco
>
> > Error ticket for "X"
> > Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c-
> > fb62-423d-81a8-27058eccb348
>
> > Error traceback
>
> > Traceback (most recent call last):
> >  File "gluon/restricted.py", line 97, in restricted
> >  File "C:/web2py_win159/web2py/applications/crm/controllers/
> > default.py", line 66
> >    for i,r in enumerate(db().select
> > (db
> > .allineamento_erp
> > .data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)):
>
> > ^
> > SyntaxError: invalid syntax
>
> > In file: C:\web2py_win159\web2py\applications\crm/controllers/
> > default.py
>
> > #!/usr/bin/python
> > # -*- coding: utf-8 -*-
>
> > response.title = "New X"
> > response.application = "X"
>
> > if auth.user: response.menu=[
> >    ['-Logout-',False,URL(r=request,f='user',args=['logout'])],
> >    ['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict
> > (query='db.contatti.id>0'))],
> >    ['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict
> > (query='db.operatori.id>0'))],
> >    ['Tipi attività',False,URL(r=request,f='select',args=
> > ['db'],vars=dict(query='db.tipiattivita.id>0'))
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18498] Re: problems with a query

2009-03-23 Thread Yarko Tymciurak
Hello Marco -

Try this and tell us what you get:

$ python web2py.py -S crm -M

>>> result=db().select( db.allineamento_erp.data_allineamento, \
  orderby=˜db.allineamento_erp.data_allineamento)
>>> str(result)

On Mon, Mar 23, 2009 at 4:29 PM, Marco Prosperi
wrote:

>
> thanks for the time you spent on my question but I don't have any
> linebreak in my code after 'select'. It appears in my post after
> copying the error message from web2py and pasting it to googlegroups.
> If I cancel the character ˜  everything works fine in my application
>
> Marco
>
>
> On 23 Mar, 19:14, Hilbert Markus  wrote:
> > hi,
> >
> > this looks like a scripting error to me.
> > i'm not a web2py-developer right now, but have some knowledge on
> > python...
> >
> > the linebreak after select makes the mess:
> > for i,r in enumerate(db().select(db.allineamento_erp.data_allineamento,
> >
> orderby=˜db.allineamento_erp.data_allineamento)):
> > whatever stuff you want to do with i and r
> >
> > the way you wrote it a variable called 'select' on db() is expected
> > not the method db().select()
> >
> > regards
> > iham
> >
> > On Mar 23, 2009, at 3:18 PM, Marco Prosperi wrote:
> >
> >
> >
> > > hi all, I would like to make a query to fetch records in reverse
> > > order. The manual says to use ˜ by I get this error (everything works
> > > if a eliminate ˜). On web2py (maybe not after pasting the message in
> > > googlegroups) the arrow indicating the problems point to ˜. Am I
> > > missing something or is a problem with my Italian settings? thanks,
> > > Marco
> >
> > > Error ticket for "X"
> > > Ticket 127.0.0.1.2009-03-23.15-02-46.51e8621c-
> > > fb62-423d-81a8-27058eccb348
> >
> > > Error traceback
> >
> > > Traceback (most recent call last):
> > >  File "gluon/restricted.py", line 97, in restricted
> > >  File "C:/web2py_win159/web2py/applications/crm/controllers/
> > > default.py", line 66
> > >for i,r in enumerate(db().select
> > > (db
> > > .allineamento_erp
> > > .data_allineamento,orderby=˜db.allineamento_erp.data_allineamento)):
> >
> > > ^
> > > SyntaxError: invalid syntax
> >
> > > In file: C:\web2py_win159\web2py\applications\crm/controllers/
> > > default.py
> >
> > > #!/usr/bin/python
> > > # -*- coding: utf-8 -*-
> >
> > > response.title = "New X"
> > > response.application = "X"
> >
> > > if auth.user: response.menu=[
> > >['-Logout-',False,URL(r=request,f='user',args=['logout'])],
> > >['Contatti',False,URL(r=request,f='select',args=['db'],vars=dict
> > > (query='db.contatti.id>0'))],
> > >['Operatori',False,URL(r=request,f='select',args=['db'],vars=dict
> > > (query='db.operatori.id>0'))],
> > >['Tipi attività',False,URL(r=request,f='select',args=
> > > ['db'],vars=dict(query='db.tipiattivita.id>0'))
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18499] Re: auth questions

2009-03-23 Thread Fran

On Mar 23, 3:27 am, ctalley  wrote:
> There's still one thing I don't get.  "Table Name:" in the appadmin
> form is a drop down list and the only tables selectable from the list
> are auth_user, auth_group, auth_membership, and auth_permission.  To
> me, this implied that it was only possible to set permissions on those
> four tables.  auth.add_permission() above indicates that any table can
> be named, not just the four in the dropdown list.  Should the dropdown
> be populated with the names of all my tables?

See:
http://groups.google.com/group/web2py/browse_thread/thread/7a68e6cde4e0e3d9

F
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18500] Re: Change Control Process for web2py

2009-03-23 Thread Anand Vaidya

Hi dbb,

You bring up several good ideas... I have some (hopefully useful)
comments below:

On Mar 23, 9:44 pm, dbb  wrote:
> All:
>
> It is very important to have change control process for web2py, this
> change control process  will include :
>        - formal submission of idea or improvement using a form
>        - voting on the idea or improvement with supporting reasonings
>        - incorporating the the idea or improvements into the next
> release
>        - every release must be deposited in a storage area and kept
> there for  certain time

The svn and bzr take care of this

>        - removing old versions from the official storage will when
> support for that version is
>          no longer feasible

Why? The code is GPL. Let the old code live in SVN

>        - annoucement is sent to all members when old version is no
> longer supported

Currently, the website and this forum get the announcements , if we
are on this forum, looks good...
I have just registered the project on freshmeat (http://freshmeat.net/
projects/web2py) so the announcements should start appearing on FM
too... Maybe we should announce on icewalkers too?


>        - There must be board of directors selected from the exiting
> members to decide the
>           direction of web2py

While governance is good, it comes with the risk of bureaucracy and
slow decisions and sometimes arguments.

>
> web2py Documentation :
>         - all releases must have documentations for each new feature
> and stored in an
>            official site togther with web2py framework

There is an official book, several videos, wiki pages etc. The
community around web2py is trying to build up an excellent new wiki.
This group is very active and usually you can get response in < day.
So while more is better wrt docs, the current status is reasonably
good


>          - access to web2py should be limited to members only
> web2py members:

This goes against the philosophy of OSS.. Sorry, not feasible.

>           - all members must pay a fee to hire students to write
> documentations, to test
>              integrate applications into web2py framework, and to
> cover some of Massimo's
>              expenses
>            - the fee will be determined by the board of directors, my
> suggestion is 20 USD
>              per month
>            - all fee paying members will have all access to
> documentation and real time
>              anwers for the creator, of course , that is Massimo

I don't think Massimo will take money to answer to forum posts or
provide support. The commercial companies around web2py have to
fulfill that role. I guess Massimo is more keen on developing web2py
code, building a community and teaching. I'd also think any book
revenues are 'side-effects' but not done for the purpose of profit.

Moreover, while $20 looks ok to you, many people in developing
countries can have 30 meals with $20. To them it may be very
expensive. They may have the time to read code and learn hands-on...

My $0.02

Regards
Anand

> Any suggestions!!
>
> Best Regards:
> dbb
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18501] balancing

2009-03-23 Thread desfrenes

hi web2py people,

I'm still balancing between Django and Web2py, althought I think I
start to like web2py more and more because it really eases the process
of writing an app.

I tried to expose my views in my blog, if any french-spoken is
interested: http://www.desfrenes.com/blog/post/quel-framework-web-python-choisir

Just to help me clear my mind, what would you, as a web2py user,
consider being weaknesses of it ? I understand this is not an easy
question for a fan, but at least it could give directions to the
project.

See you,
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18502] Multi Column Unique Key, how to code best in web2py?

2009-03-23 Thread Hans

Massimo and web2py.experts,

After initial successful tests with web2py we are trying to get the
first 'little' enterprise application done with it. And like
enterprises do we need to life with extensive use of multi column
unique keys. Despite reading through various threads on this we could
not get it working already with a 'simple' 2 column unique key. Either
we loose the "drop box" option/functionality or we can't use it as one
column of a multi column unique key. See the last 3 lines of the
following code example. I'm sure someone here can share a working
example of how to implement such a basic enterprise requirement in
web2py code.

Beyond that I would appreciate help on how a good code for a 3 column
unique key would be implemented (a good example would be shapename
+colorname+month below).

Thanks,
Hans

db=SQLDB('sqlite://test.db')

db.define_table('shape',
  SQLField('name'),
  migrate='shape.table')

db.define_table('color',
  SQLField('name'),
  migrate='color.table')

db.define_table('shapecolor',
  SQLField('shapename'),
  SQLField('colorname'),
  SQLField('month','date',requires=IS_DATE('%Y-%m')),
  migrate='shapecolor.table')

db.shapecolor.shapename.requires=IS_IN_DB(db,db.shape.name,'%(name)
s')

# 1st try
db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name)
s'),IS_NOT_IN_DB(db
(db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname')
#<<< this breaks db.color.name dropdown
# 2nd try
db.shapecolor.colorname.requires=[IS_IN_DB(db,db.color.name,'%(name)
s'),IS_NOT_IN_DB(db
(db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname')]
#<<< this breaks db.color.name dropdown as well
# 3rd try
db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name)
s')  #<<< dropdown working but no multi column unique key!

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18503] Re: How to hide the console window?

2009-03-23 Thread Iceberg

On Mar24, 5:20am, Fran  wrote:
> On Mar 22, 3:44 am, Iceberg  wrote:
>
> > I am using web2py 's windows distribution. Is there some way to hide
> > the console window (a.k.a. the black dos window) in which web2py is
> > running?
>
> I run as a service using:http://mdp.cti.depaul.edu/AlterEgo/default/show/77
>
> I get no console window.
>
> PS This thread may also be 
> useful:http://groups.google.com/group/web2py/browse_thread/thread/733896d0ae...
>
> F

Hi Fran,

Actually I had read your first link, and then I was the person who
posted your second  link. :-)

Running web2py as a service is a usual answer for the "no-console"
need. But somehow that can only be done when using web2py's source
code distribution (and therefore python is a precondition on the
target PC, perhaps pywin32 too).

I am seeking a way to do the same thing with web2py_win.zip binary
distribution, so that eventually any MS Windows user do not need to
install anything else, but just use web2py like every other "normal"
windows programs.

The goal is almost achieved now, with the help of "Hidden Start". I
even write a mail to Massimo for suggesting him to try to apply a free
permission of using "Hidden Start" in web2py, because of its license
policy: http://www.ntwind.com/software/utilities/hstart/distribution.html

Regards,
Iceberg
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18504] Re: Multi Column Unique Key, how to code best in web2py?

2009-03-23 Thread Yarko Tymciurak
Hello Hans -

On Mon, Mar 23, 2009 at 5:23 PM, Hans <
johann.scheibelho...@easytouch-edv.com> wrote:

>
> Massimo and web2py.experts,
>
> After initial successful tests with web2py we are trying to get the
> first 'little' enterprise application done with it. And like
> enterprises do we need to life with extensive use of multi column
> unique keys. Despite reading through various threads on this we could
> not get it working already with a 'simple' 2 column unique key. Either
> we loose the "drop box" option/functionality or we can't use it as one
> column of a multi column unique key. See the last 3 lines of the
> following code example. I'm sure someone here can share a working
> example of how to implement such a basic enterprise requirement in
> web2py code.
>
> Beyond that I would appreciate help on how a good code for a 3 column
> unique key would be implemented (a good example would be shapename
> +colorname+month below).
>
> Thanks,
> Hans
>
> db=SQLDB('sqlite://test.db')
>
> db.define_table('shape',
>  SQLField('name'),
>  migrate='shape.table')


>
> db.define_table('color',
>  SQLField('name'),
>  migrate='color.table')
>
> db.define_table('shapecolor',
>  SQLField('shapename'),
>  SQLField('colorname'),
>  SQLField('month','date',requires=IS_DATE('%Y-%m')),
>  migrate='shapecolor.table')


You probably mean to have these be a table holding many-to-many
relationships.  If so, these should be references (that is, they should
implement foreign keys), something like this:

db.define_table('shapecolor',# note every web2py table by default
creates a unique field, 'id'
  SQLField('shape_id', db.shape),
  SQLField('color_id', db.color ))
# I leave the date off just because the way you have it is ok...
#  I only want to show correction where I think there is a problem


>
> db.shapecolor.shapename.requires=IS_IN_DB(db,db.shape.name,'%(name)
> s')
>

Now, since a reference to another table is a reference to a row id, here is
how
this should look:

  db.shapecolor.shape_id.requires=IS_IN_DB(db, db.shape.id, %(name)s )

Here is how this "reads":

   shape_id  must be the same as shape.id, and shape.id must exist
  (but, from that row, display db.shape.name as a string, instead of
shape.id)

Try to re-phrase all of the following in a similar way, recognizing that the
foreign
key is a reference to another table's 'id' field (and so the IS_IN_DB test
will also be
against the id of that table) --- display the name for selection, as you
have.

Let us know how it goes.

Regards,
Yarko


> # 1st try
> db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name)
> s'),IS_NOT_IN_DB(db
> (db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname')
> #<<< this breaks db.color.name dropdown
> # 2nd try
> db.shapecolor.colorname.requires=[IS_IN_DB(db,db.color.name,'%(name)
> s'),IS_NOT_IN_DB(db
> (db.shapecolor.shapename==request.vars.shapename),'shapecolor.colorname')]
> #<<< this breaks db.color.name dropdown as well
> # 3rd try
> db.shapecolor.colorname.requires=IS_IN_DB(db,db.color.name,'%(name)
> s')  #<<< dropdown working but no multi column unique key!
>
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18505] Auth Wiki example

2009-03-23 Thread Oscar

Hi all,

I followed the example posted at the WiKi about auth, I extended Auth
class with:

db.py ->
class MyAuth(Auth):
def __init__(self, environment, T, db = None):
Auth.__init__(self, environment, db)
self.messages.logged_in = T("Logged in")
self.messages.email_sent = T("Email sent")
self.messages.email_verified = T("Email verified")
self.messages.logged_out = T("Logged out")
self.messages.registration_successful = T("Registration 
successful")
self.messages.invalid_email = T("Invalid email")
self.messages.invalid_login = T("Invalid login")
self.messages.verify_email_subject = T("Password verify")
self.messages.username_sent = T("Your username was emailed to 
you")
self.messages.new_password_sent = T("A new password was emailed 
to
you")
self.messages.password_changed = T("Password changed")
self.messages.retrieve_username = str(T("Your username is"))+": 
%
(username)s"
self.messages.retrieve_username_subject = T("Username retrieve")
self.messages.retrieve_password = str(T("Your password is"))+": 
%
(password)s"
self.messages.retrieve_password_subject = T("Password retrieve")
self.messages.profile_updated = T("Profile updated")

auth = MyAuth(globals(), T, db)

Then I enabled user at controllers:

def user(): return dict(form=auth())

When I try to call user it returns the following:

Error ticket for "welcome"
Ticket 127.0.0.1.2009-03-23.23-19-06.ea037521-4005-40f4-ac29-
ef8af121182a


Error traceback

Traceback (most recent call last):
  File "/Users/Ra/codigo_fuente/web2py/gluon/restricted.py", line 98,
in restricted
exec ccode in environment
  File "/Users/Ra/codigo_fuente/web2py/applications/welcome/
controllers/default.py", line 14, in 
  File "/Users/Ra/codigo_fuente/web2py/gluon/globals.py", line 75, in

self._caller = lambda f: f()
  File "/Users/Ra/codigo_fuente/web2py/applications/welcome/
controllers/default.py", line 8, in user
def user(): return auth()
  File "/Users/Ra/codigo_fuente/web2py/gluon/tools.py", line 399, in
__call__
return self.login()
  File "/Users/Ra/codigo_fuente/web2py/gluon/tools.py", line 529, in
login
if 'username' in user.fields:
AttributeError: 'NoneType' object has no attribute 'fields'


In file: /Users/Ra/codigo_fuente/web2py/applications/welcome/
controllers/default.py

def index():
response.flash = T('Welcome to web2py')
return dict(message=T('Hello World'))


# # uncomment the following if you have defined "auth" and "crud" in
models
#def user(): return dict(form=auth())
def user(): return auth()
# def data(): return dict(form=crud())
def download(): return response.download(request,db)
# # tip: use @auth.requires_login, requires_membership,
requires_permission


response._vars=response._caller(user)

I guess that the problem is at db = None when variables are
initialized.

So... how I can fix it?

Thanks in advance.

BTW: My python skills are poor and sorry for my english.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18506] Re: Multi Column Unique Key, how to code best in web2py?

2009-03-23 Thread Yarko Tymciurak
On Mon, Mar 23, 2009 at 9:17 PM, Yarko Tymciurak  wrote:

> Hello Hans -
> *snip*
> You probably mean to have these be a table holding many-to-many
> relationships.  If so, these should be references (that is, they should
> implement foreign keys), something like this:
>
> db.define_table('shapecolor',# note every web2py table by default
> creates a unique field, 'id'
>   SQLField('shape_id', db.shape),
>   SQLField('color_id', db.color ))
>
>
It may not be clear what these say:
shape_id is a foreign key, and it references the table db.shape, that is
it holds a reference to db.shape.id

Another way to write references (useful when you have forward references, or
a self-reference) is:

SQLField('shape_id', 'reference shape')

A self reference might look like:

db.define_table('mine',
  SQLField('name'),
  SQLField('related_mine_id', 'reference mine'))

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[web2py:18507] MVC question

2009-03-23 Thread Joseph Jude

All,
Just a question on the best practice - in terms of development &
continuous maintenance. web2py (like django) allows to define forms in
controller itself. And it allows having 'business logic' embedded in
views too. To bring out the application quickly, such mixing is fine.
But what about long term maintenance and also to call the application
truly MVC? What are your thoughts basis of your experience.

Thank you for sharing your thoughts on this,
Joseph
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---