[web2py] Re: Limitby not working with Oracle with joins

2010-02-27 Thread SergeyPo
SELECT headers1.name, alarms1.komment FROM (SELECT w_tmp.*, ROWNUM w_row FROM (SELECT headers1.name, alarms1.komment FROM headers1, alarms1 WHERE headers1.id=alarms1.header ORDER BY headers1.id, alarms1.id) w_tmp WHERE ROWNUM<=5) headers1, alarms1 WHERE headers1.id=alarms1.header AND w_row > 0; Tr

[web2py] Is the web2py site down?

2010-02-27 Thread Neno
http://www.web2py.com/ doesn't seem to be responding... -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.

[web2py] Re: Is the web2py site down?

2010-02-27 Thread Mengu
it is up now. On 27 Şubat, 10:30, Neno wrote: > http://www.web2py.com/doesn't seem to be responding... -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group

Re: [web2py] Is the web2py site down?

2010-02-27 Thread nakul mishra
Yes u are right. I also checked but its not responding On Sat, Feb 27, 2010 at 9:30 AM, Neno wrote: > http://www.web2py.com/ doesn't seem to be responding... > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send e

[web2py] Re: Is the web2py site down?

2010-02-27 Thread DenesL
It works for me. On Feb 27, 4:17 am, nakul mishra wrote: > Yes u are right. > I also checked but its not responding > > On Sat, Feb 27, 2010 at 9:30 AM, Neno wrote: > >http://www.web2py.com/doesn't seem to be responding... > > -- > Regards > Nakul -- You received this message because you are s

[web2py] Re: Cron issue with recent web2py?

2010-02-27 Thread Magnitus
Running on Windows Vista here. I notice that the CPU spikes at about 60% for a fraction of a second every minute or so, but it does that whether web2py is running or not (probably my anti-virus or another process running in the background). I don't notice multiple python processes spawning or the

[web2py] Re: Ladies and Gentelmen... the web2py book is online

2010-02-27 Thread mdmcginn
When I try to register, I get a flash "Unable to send email" On Feb 15, 9:20 am, mdipierro wrote: > Create a wiki page under preface callederrata. It would be nice if > somebody where to move overerratafrom wiki.web2py.com. > As people fix these problems, we'll mark theerrataentries as fixed. --

[web2py] Re: Is the web2py site down?

2010-02-27 Thread ionel anton
It doesn't work for me :( On Feb 27, 6:15 am, DenesL wrote: > It works for me. > > On Feb 27, 4:17 am, nakul mishra wrote: > > > Yes u are right. > > I also checked but its not responding > > > On Sat, Feb 27, 2010 at 9:30 AM, Neno wrote: > > >http://www.web2py.com/doesn'tseem to be responding.

[web2py] Re: Is the web2py site down?

2010-02-27 Thread Neno
Same here, still down. On Feb 27, 7:24 am, ionel anton wrote: > It doesn't work for me :( > > On Feb 27, 6:15 am, DenesL wrote: > > > > > It works for me. > > > On Feb 27, 4:17 am, nakul mishra wrote: > > > > Yes u are right. > > > I also checked but its not responding > > > > On Sat, Feb 27, 2

[web2py] Re: Is the web2py site down?

2010-02-27 Thread Brian M
Yep, down - noticed it was down last night too, so it's been like 12hrs! http://downforeveryoneorjustme.com/web2py.com On Feb 27, 9:37 am, Neno wrote: > Same here, still down. > > On Feb 27, 7:24 am, ionel anton wrote: > > > > > It doesn't work for me :( > > > On Feb 27, 6:15 am, DenesL wrote

Re: [web2py] Re: Limitby not working with Oracle with joins

2010-02-27 Thread Thadeus Burgess
Just going out on a limb here. Have you tried the query where it selects all columns instead of just name and komment? -Thadeus 2010/2/27 SergeyPo : > SELECT headers1.name, alarms1.komment FROM (SELECT w_tmp.*, ROWNUM > w_row FROM (SELECT headers1.name, alarms1.komment FROM headers1, > alarm

[web2py] Re: Limitby not working with Oracle with joins

2010-02-27 Thread SergeyPo
If you remove limitby it works. I reported this error about 6 months ago, tried many workarounds and thought we fixed it. But somehow it appeared at my client's site. Versions 1.65 and current 1.75 downloaded this week. On Feb 27, 8:20 pm, Thadeus Burgess wrote: > Just going out on a limb here. >

Re: [web2py] Re: Iterate through form input

2010-02-27 Thread Yarko Tymciurak
You can accomplish this with a text field - you then parse the input. You can see a (somewhat messy - as it evolved incrementally over several manual efforts - and really needs some refactoring into smaller functions) - in the batch registration processing for PyCon 2010: I wanted to take a list

[web2py] Re: Web2py Scalability and demos

2010-02-27 Thread waTR
If you want to ensure your site works flawlesly and can scale, build it to work on the cloud. Check out this video for interesting info about what to watch out for: http://pycon.blip.tv/file/3257303/ http://us.pycon.org/2010/conference/schedule/event/148/ There is also this: http://pycon.blip.tv/f

Re: [web2py] Re: mail sending no functioning from Chrome

2010-02-27 Thread Jonathan Lundell
On Feb 26, 2010, at 8:52 AM, LBarret wrote: > It depends on the browser. > > IE8, FF/Linux, FF/Windows do the checks (like if the email is a real > email) > Chrome/Linux, Chrome/Windows don't . > > I get the emails from FF & IE, not from chrome. > > I don't have any errors due to this behavior.

[web2py] webform actions

2010-02-27 Thread Tomas Pelka
Hi all, have some troubles with web form which have more than one button. It is obvious that one button (action connected with button) correspond with one function. According manual this should work: controler - def index(): form = FORM('blah blah', INPUT(_type='submit', _value=

Re: [web2py] webform actions

2010-02-27 Thread Tiago Almeida
Don't know why functions reset, reset_all are not called but they reference a "form" variable which is not in scope? Do you have any global "form"? Regards, Tiago -- On Sat, Feb 27, 2010 at 10:15 PM, Tomas Pelka wrote: > Hi all, > > have some troubles with web form which have more than one butt

Re: [web2py] webform actions

2010-02-27 Thread Jonathan Lundell
On Feb 27, 2010, at 3:00 PM, Tiago Almeida wrote: > Don't know why functions reset, reset_all are not called but they reference a > "form" variable which is not in scope? Do you have any global "form"? The logic below can't work, for lots of reasons. One is the one Tiago mentions. Another is th

Re: [web2py] webform actions

2010-02-27 Thread Thadeus Burgess
If your running the latest version of web2py, look at controllers/appadmin.py in ccache function. It defines a form with three buttons, (one toc lear ram, one to clear disk, and one to clear both). Click the different submit button executes the appropriate function. -Thadeus On Sat, Feb 27, 2

Re: [web2py] webform actions

2010-02-27 Thread Jonathan Lundell
On Feb 27, 2010, at 4:03 PM, Thadeus Burgess wrote: > If your running the latest version of web2py, look at > controllers/appadmin.py in ccache function. It defines a form with > three buttons, (one toc lear ram, one to clear disk, and one to clear > both). Click the different submit button execut

[web2py] Re: webform actions

2010-02-27 Thread mr.freeze
Why not just do this?: def index(): form = FORM('blah blah', INPUT(_type='submit', _value='Apply',_name="apply"), INPUT(_type='submit', _value='Reset',_name="reset"), INPUT(_type='submit', _value='Reset all',_name="resetall")) if request.vars.apply:

[web2py] translation of the online book

2010-02-27 Thread Vidul Petrov
Hi all, Some days ago I was happy to found out the online book, thank you Massimo! My intention is to translate it in Bulgarian. Which is the best way to do this (probably there is a read / write repository for the website, but I didn't find a link for it)? -- You received this message because

[web2py] Re: webform actions

2010-02-27 Thread Iceberg
I think Jonathan have given enough reason of why not. There is another post to discuss the same thing. http://groups.google.com/group/web2py/msg/79c1f847890a6b60 In short, do resist the temptation of using multiple submit buttons, pal. :) On Feb28, 9:36am, "mr.freeze" wrote: > Why not just do

[web2py] Re: webform actions

2010-02-27 Thread mr.freeze
I disagree, the behavior seems controllable to me and I use it often. In IE, a submit done via the enter key on a text input doesn't send any of the wrote: > I think Jonathan have given enough reason of why not.  There is > another post to discuss the same > thing.http://groups.google.com/group/w

[web2py] sql between function

2010-02-27 Thread Stelios Koroneos
Hi, I'm trying to make a query function that accepts two datetime.date object(start_date and end_date), and returns all records that are between start_date and end_date. However, I found nothing like a between function in the web2py manual, so I was wondering what's the best way to achieve this. I

Re: [web2py] Re: webform actions

2010-02-27 Thread Jonathan Lundell
On Feb 27, 2010, at 6:25 PM, mr.freeze wrote: > I disagree, the behavior seems controllable to me and I use it often. > In IE, a submit done via the enter key on a text input doesn't send > any of the done with the enter key will send the first submit value. Just make > your default submit the fi

Re: [web2py] sql between function

2010-02-27 Thread Thadeus Burgess
#and db(db.table.field >= '2009-12-28')(db.table.field <= '2009-12-30').select() #or db(db.table.field == '2010-01-01' | db.table.field == request.now).select() db(db.table.field.year() > '2008').select() db(db.table.field.day() < '5').select() -Thadeus On Sat, Feb 27, 2010 at 3:52 PM, Stel

[web2py] Re: sql between function

2010-02-27 Thread mr.freeze
def datesearch(): matches=None form = SQLFORM.factory(Field('start_date','date',requires=IS_NOT_EMPTY()), Field('end_date','date',requires=IS_NOT_EMPTY())) if form.accepts(request.vars,session): (sy,sm,sd) = (int(x) for x in form.vars.start_date.split('-')) (ey,em,ed)

[web2py] Re: GAE delete() has subtle difference compared to native Web2Py

2010-02-27 Thread Richard
On Feb 4, 12:16 pm, mdipierro wrote: > do you use 2.5 or something else locally? it would be because GAE uses 2.5: http://code.google.com/appengine/docs/python/gettingstarted/devenvironment.html -- You received this message because you are subscribed to the Google Groups "web2py-users" group.

[web2py] Re: Iterate through form input

2010-02-27 Thread mr.freeze
Try this. It builds the form dynamically on the client and server so you get to keep the benefits of SQLFORM (validation, etc): def invite(): fields = [Field('email',requires=IS_EMAIL())] for r in range(1, len(request.vars)): if 'email%s' % str(r) in request.vars.keys():