[web2py:19540] Re: BETWEEN functionality

2009-04-09 Thread jmvermeer
Denes, > OK but you should check if minmax is not empty first. I thought this wouldn't be necessary since the input comes from an auto-complete or drop-box, and these contain values that are in the zipcoderegions table for sure. However, that's my logic, now that you mention checking if minmax

[web2py:19539] Question about INPUT()

2009-04-09 Thread waTR
I have a field whose value I set to a user's email, from the DB. I need to have the field check the following: If user enters NEW email, check if email is already in DB and flash error message if it does, otherwise, if user doesn't change their email, process form normally. --~--~-~--~---

[web2py:19538] Return 10000 values to SQLFORM

2009-04-09 Thread shuval
Hello!!! I test SQLFORM. I found problem, when i returned 1 values to SQLFORM i got 7453. Is maximum in SQLFORM? thanks help! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post

[web2py:19537] Re: Sub query not registering accurately?

2009-04-09 Thread TheDude
Any luck on the matter? THis is the query that I am trying to perform: SELECT mb_posts.id, mb_posts.title, mb_posts.message, mb_posts.posted_by, mb_posts.date_posted, mb_posts.locked, mb_posts.sticky, mb_posts.last_edited, mb_posts.board_id, mb_posts.reply_to, mb_posts.views, auth_user.id, auth_u

[web2py:19536] Re: Apache config.

2009-04-09 Thread Speedbird
Technically that is an apache warning, I am deploying my second app tomorrow and will post an updated version of the configuration file, showing using 2 apps , one instance of web2py and apache proxying. Cheers, Julio On Apr 9, 2:27 pm, zxynax wrote: > I get an error when I use that setup as we

[web2py:19535] Re: sorry

2009-04-09 Thread mdipierro
Fixed and 1.60.2 posted On Apr 9, 3:55 pm, mdipierro wrote: > no I just types field instead of xfield. > > Massimo > > On Apr 9, 3:47 pm, desfrenes wrote: > > > anythong to do with the markup issue ? > > > On 9 avr, 16:53, mdipierro wrote: > > > > One of the recent patches broke SQLFORM in upd

[web2py:19534] Re: Coooooool!

2009-04-09 Thread mdipierro
LOL. It will go away. Promise. On Apr 9, 10:17 pm, Jeffield wrote: > > Isn't this cool? > > very! I have been dying to play with GWT but have not had the time > I figured it would make creating ajax interfaces easer. > > > Pros? Cons? Suggestions for improvement? > > I feel silly for saying this

[web2py:19533] Re: Coooooool!

2009-04-09 Thread Yarko Tymciurak
just doesn't work at all from a mobile browser... might need to start by doing some detection... (look forward to seeing what you've got when I get home) - Yarko On 4/6/09, mdipierro wrote: > > I just changed the layout > > http://www.web2py.com/events/default/index > http://www.web2py.co

[web2py:19532] Re: Coooooool!

2009-04-09 Thread Yarko Tymciurak
just doesn't work at all from a mobile browser... might need to start by doing some detection... (look forward to seeing what you've got when I get home) - Yarko On 4/6/09, mdipierro wrote: > > I just changed the layout > > http://www.web2py.com/events/default/index > http://www.web2py.co

[web2py:19531] Re: Coooooool!

2009-04-09 Thread Jeffield
> Isn't this cool? very! I have been dying to play with GWT but have not had the time I figured it would make creating ajax interfaces easer. > Pros? Cons? Suggestions for improvement? I feel silly for saying this... but think it warrents being said. "click me", "click me", "click me" has got

[web2py:19530] Re: Coooooool!

2009-04-09 Thread mdipierro
cj and I are working this. Then we need to focus on wirting specs for plugins. Massimo On Apr 9, 5:37 pm, Wes James wrote: > I registered, logged in then when I log out I got a ticket: > > Traceback (most recent call last): > File "/opt/20090331-w2p/gluon/restricted.py", line 98, in restricte

[web2py:19529] Re: Coooooool!

2009-04-09 Thread Wes James
I registered, logged in then when I log out I got a ticket: Traceback (most recent call last): File "/opt/20090331-w2p/gluon/restricted.py", line 98, in restricted exec ccode in environment File "/opt/20090331-w2p/applications/events/controllers/default.py", line 63, in File "/opt/2009

[web2py:19528] Re: Apache config.

2009-04-09 Thread zxynax
I get an error when I use that setup as well. Already used by another worker On Apr 7, 4:19 pm, bsnipes wrote: > Just came across this nice post and am going to try it tonight: > > http://groups.google.com/group/web2py/browse_thread/thread/8bab53777c... > > Brian --~--~-~--~~---

[web2py:19527] Re: Stability

2009-04-09 Thread Michal Jursa
Finally I placed my web2py application in inittab and init now watches it so if it crashes it is automatically respawned. Thats workaround but everything else failed..:( Michal Michal Jursa wrote: > and bad news again... Few minutes after optimistic mail Segmentation > fault came again... :

[web2py:19526] Re: sorry

2009-04-09 Thread mdipierro
no I just types field instead of xfield. Massimo On Apr 9, 3:47 pm, desfrenes wrote: > anythong to do with the markup issue ? > > On 9 avr, 16:53, mdipierro wrote: > > > One of the recent patches broke SQLFORM in update mode. am not at > > home so I reverted back to 1.59. Tonight I will get t

[web2py:19525] Re: sorry

2009-04-09 Thread desfrenes
anythong to do with the markup issue ? On 9 avr, 16:53, mdipierro wrote: > One of the recent patches broke SQLFORM in update mode.  am not at > home so I reverted back to 1.59. Tonight I will get this fixed. Do not > user 1.60 or 1.60.1 > > I apologize. > > Massimo --~--~-~--~~--

[web2py:19524] Re: Stability

2009-04-09 Thread Michal Jursa
and bad news again... Few minutes after optimistic mail Segmentation fault came again... :( So 2.0.9. runs better, lasts longer, but crashes too. Anyone can tell me how to trace it? I'd like to send bug report to psycopg developers? Michal Michal Jursa wrote: > Good news! > > psycopg2 2.0

[web2py:19523] Re: ssl, https

2009-04-09 Thread mdipierro
You can make a selft signed certificate for free (using openssl) and that is fine as long as you are the only one supposed to access the https site. If you want a public https site than you should buy one else visitors will not trust your site. Massimo On Apr 9, 2:07 pm, davidjensen wrote: > Ma

[web2py:19522] ssl, https

2009-04-09 Thread davidjensen
Massimo, thanks for the advice. All I had to do was use port 1000 and map 80 of the external to 1000 of the internal network. I would like to use https so I can remotely edit code and use the shell somewhat securely. I did comment out "raise HTTP(200, T('Admin is disabled because unsecure channel

[web2py:19521] Re: Stability

2009-04-09 Thread Michal Jursa
Good news! psycopg2 2.0.9 up and running and looks stable. So upgrade from 2.0.7 to 2.0.9 solved the trouble i hope. Pfew..:) Just have to build my deb package for production use. 2.0.9 is already accepted in 'testing' branch but it sometimes takes months to get to 'stable'. Michal Michal Ju

[web2py:19520] Re: between "vars" and "args"

2009-04-09 Thread DenesL
For more on this see: http://groups.google.com/group/web2py/browse_thread/thread/d7a5bdc7405820c4/e28d3b75fc0683f7?#e28d3b75fc0683f7 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To po

[web2py:19519] Re: BETWEEN functionality

2009-04-09 Thread DenesL
On Apr 9, 6:19 am, jmverm...@xs4all.nl wrote: > Denes, > > Problem solved: > > minimum=int(minmax.codemin) > maximum=int(minmax.codemax) > > Should read: > > minimum=int(minmax[0].codemin) > maximum=int(minmax[0].codemax) OK but you should check if minmax is not empty first. > > Why? As Massimo

[web2py:19518] Re: Stability

2009-04-09 Thread Michal Jursa
Just some progress info.. On my IBM notebook in same but 32bit environment looks everything stable and fine with psycopg2 2.0.9. Will try 64bit version soon and will report results. I just hope the bug was fixed in this minor version update. Michal Michal Jursa wrote: > I used default Debian

[web2py:19517] Re: web2py team & Geo/GIS project created at Launchpad

2009-04-09 Thread AchipA
The GIS topic is pretty complex - you have to decide early on whether you want a simple spatial interface which is basically a pretty picture viewer with some associated features OR do you want a real GIS level approach which encompasses a spatial operations and relations on data, projection, comp

[web2py:19516] sorry

2009-04-09 Thread mdipierro
One of the recent patches broke SQLFORM in update mode. am not at home so I reverted back to 1.59. Tonight I will get this fixed. Do not user 1.60 or 1.60.1 I apologize. Massimo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Goo

[web2py:19515] Re: auto_complete

2009-04-09 Thread DenesL
Annet, On Apr 9, 4:54 am, jmverm...@xs4all.nl wrote: > Denes, > > I adjusted the form: type='integer' and _type='integer' Only the first one needed adjustment. > > form=form_factory(SQLField('postcoderegio',type='integer', > requires=IS_NOT_EMPTY(),\ > widget=lambda self,value:TAG[''](INPUT

[web2py:19514] Re: web2py team & Geo/GIS project created at Launchpad

2009-04-09 Thread dbb
I may be missing something here, when we talked about polygon we mean the borders on a map; a map can be territory of a nation or a simple building with rooms or a piece of land. When we use google map, what we actually using is a map that was drawn using polygon and in turn each polygon is identi

[web2py:19513] Re: web2py 1.60.1 is out

2009-04-09 Thread mdipierro
It is backward compatible. Your project should work. Massimo On Apr 9, 8:19 am, "Zoom.Quiet" wrote: > On Thu, Apr 9, 2009 at 21:17, Alfonso de la Guarda > wrote: > > > > > > > Hello, > > > Checking > > > Saludos, > > > > > Alfonso de la Guarda > > Centro O

[web2py:19512] Re: web2py 1.60.1 is out

2009-04-09 Thread Zoom.Quiet
On Thu, Apr 9, 2009 at 21:17, Alfonso de la Guarda wrote: > > Hello, > > Checking > > Saludos, > > > Alfonso de la Guarda > Centro Open Source(COS) > alfonsodg.blogspot.com > alfonsodg.wordpress.com > Agenda:http://tinyurl.com/djmjol >   Telef. 997550914 > 102

[web2py:19511] Re: web2py 1.60.1 is out

2009-04-09 Thread Alfonso de la Guarda
Hello, Checking Saludos, Alfonso de la Guarda Centro Open Source(COS) alfonsodg.blogspot.com alfonsodg.wordpress.com Agenda:http://tinyurl.com/djmjol Telef. 997550914 1024D/B23B24A4 5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4 On Thu, Apr 9, 2009

[web2py:19510] web2py 1.60.1 is out

2009-04-09 Thread mdipierro
fixed a bug with french language and binary version on OSX. Please check it. Massimo --~--~-~--~~~---~--~~ 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@googlegro

[web2py:19509] Re: Stability

2009-04-09 Thread Michal Jursa
I used default Debian lenny version of psycopg 2.0.7-4 and read some information about fixind something aroud 64bit stability in 2.0.8 and 2.0.9 changelog, so will give it a try to install last psycopg from sources and we will see... Strange thing is i never had a trouble with psycopg before

[web2py:19508] Re: Form problem (passing arguments to another controller?)

2009-04-09 Thread mdipierro
redirect(URL(,vars=request.vars)) On Apr 9, 12:06 am, waTR wrote: > I ended up making it work via using a session variable I created > called c__register and passing the request.vars via that. > > However, it would be nice to avoid temporary session storage and > simply forward post_vars dir

[web2py:19506] Re: Can't get IS_EXPR to work properly with !=

2009-04-09 Thread mdipierro
because the return of a select is a SQLRows object. You are trying to compare a string (value) with it and it cannot be done. On Apr 8, 11:31 pm, waTR wrote: > Code: > requires=[IS_NOT_EMPTY(), IS_EXPR('value!=%s' % repr(db > (db.db_users.dbu_name==request.vars.nick).select()), "Username already

[web2py:19501] Re: web2py 1.60 is out

2009-04-09 Thread mdipierro
thanks On Apr 9, 4:16 am, Anand Vaidya wrote: > I have posted the update announcements > onhttp://freshmeat.net/projects/web2py/releases/297574 > andhttp://www.icewalkers.com > > The new release will appear on the front page and RSS feeds in a few > hours. > > -Anand > > On Apr 9, 2:09 am, mdip

[web2py:19504] Re: BETWEEN functionality

2009-04-09 Thread mdipierro
because in your example minmax = db(...).select(...) is SQLRows minmax[0] is a row and minmax[0].codemin is a field variable. On Apr 9, 5:19 am, jmverm...@xs4all.nl wrote: > Denes, > > Problem solved: > > minimum=int(minmax.codemin) > maximum=int(minmax.codemax) > > Should read: > > minimum=in

[web2py:19503] Re: web2py team & Geo/GIS project created at Launchpad

2009-04-09 Thread Timmie
> The big question is how web2py will evolve with regard to plugin/ > appliance architecture, because that would determine how to go about > adding geo stuff in a systematic manner. I'm        not sure I'd like > it as a t2-style addon, but then again adding it to the core would > mean way too man

[web2py:19502] Re: french translation integration trouble

2009-04-09 Thread fredg
Just in case it was a copy/paste error from the fr-fr.py file sent to you via launchpad, here it is again: http://pastealacon.com/2504 Best regards. ++ fredg On 9 avr, 14:21, fredg wrote: > Hi, > > Running Web2py-1.60 clean install and python-2.5.4. > Got a ticket if I want to edit fr-fr.py la

[web2py:19498] Re: web2py on GoDaddy?

2009-04-09 Thread mdipierro
which version of python, which apache module? is this shared hosting? if so, are you free to edit the apache config? do they have mod_wsgi? mod_proxy? Massimo On Apr 8, 10:46 pm, Michael wrote: > bump! :P any ideas? > > On Apr 7, 12:03 am, Michael wrote: > > > I have a few godaddy hosting acco

[web2py:19500] Re: Stability

2009-04-09 Thread mdipierro
this is bad. On Apr 9, 4:00 am, Michal Jursa wrote: > Well, > Step 4: > stressing that little application on mysql as much as my CPU can, but no > problem, no segfaults, just running and running > > I really like postgres and never had troubles before, but this is a > trouble for me and i pr

[web2py:19505] Re: french translation integration trouble

2009-04-09 Thread mdipierro
yes. my fault. WIll fix it soon. Massimo On Apr 9, 7:36 am, fredg wrote: > Just in case it was a copy/paste error from the fr-fr.py file sent to > you via launchpad, here it is again:http://pastealacon.com/2504 > > Best regards. > > ++ fredg > > On 9 avr, 14:21, fredg wrote: > > > Hi, > > > Ru

[web2py:19499] Re: Can't get IS_EXPR to work properly with !=

2009-04-09 Thread mdipierro
I think you want something like IS_NOT_IN_DB On Apr 8, 11:31 pm, waTR wrote: > Code: > requires=[IS_NOT_EMPTY(), IS_EXPR('value!=%s' % repr(db > (db.db_users.dbu_name==request.vars.nick).select()), "Username already > exists")] > > I keep getting the following error: > File "", line 1 >     __r

[web2py:19497] Re: auto_complete

2009-04-09 Thread mdipierro
rows=db(db.zipcoderegions.region.like('%d%%'%q) % (d,q) ).select (db.zipcoderegions.region) % (d,q) was missing On Apr 9, 3:54 am, jmverm...@xs4all.nl wrote: > Denes, > > I adjusted the form: type='integer' and _type='integer' > > form=form_factory(SQLField('postcoderegio',type='integer', > req

[web2py:19496] french translation integration trouble

2009-04-09 Thread fredg
Hi, Running Web2py-1.60 clean install and python-2.5.4. Got a ticket if I want to edit fr-fr.py language : Error traceback Traceback (most recent call last): File "/home/fredg/Desktop/web2py/gluon/restricted.py", line 98, in restricted exec ccode in environment File "/home/fredg/Desktop

[web2py:19495] Re: BETWEEN functionality

2009-04-09 Thread jmvermeer
Denes, Problem solved: minimum=int(minmax.codemin) maximum=int(minmax.codemax) Should read: minimum=int(minmax[0].codemin) maximum=int(minmax[0].codemax) Why? > > db.define_table('zipcoderegions', > >     SQLField('region', type=integer, default='',notnull=True), > >     SQLField('codemin',

[web2py:19494] Re: common controller function

2009-04-09 Thread Fran
On Apr 9, 5:08 am, g-man wrote: > Right now, I am storing functions in the default controller, then > importing from there as needed, until I can work out a more elegant > way to do it. What's wrong with using either the model or module? F --~--~-~--~~~---~--~~ Y

[web2py:19493] Re: web2py 1.60 is out

2009-04-09 Thread Anand Vaidya
I have posted the update announcements on http://freshmeat.net/projects/web2py/releases/297574 and http://www.icewalkers.com The new release will appear on the front page and RSS feeds in a few hours. -Anand On Apr 9, 2:09 am, mdipierro wrote: > web2py 1.60 is out. > > It contains a lot of sm

[web2py:19492] Re: Stability

2009-04-09 Thread Michal Jursa
Well, Step 4: stressing that little application on mysql as much as my CPU can, but no problem, no segfaults, just running and running I really like postgres and never had troubles before, but this is a trouble for me and i probably will have to consider database change. I think this is 64

[web2py:19491] Re: auto_complete

2009-04-09 Thread jmvermeer
Denes, I adjusted the form: type='integer' and _type='integer' form=form_factory(SQLField('postcoderegio',type='integer', requires=IS_NOT_EMPTY(),\ widget=lambda self,value:TAG[''](INPUT (_id='byzipcode',_name='postcoderegio',_class=\ 'ac_input',_type='integer' and the handler in /cor

[web2py:19490] Re: Stability

2009-04-09 Thread Michal Jursa
Step 1: Simple welcome application works fine, and works fine even under heavy load. Step 2: Now tried to stress my application under 1.60 and the result is: ---8<-cut-here-- web2py Enterprise Web Framework Created by Massimo Di Pierro, Copyright 2007-

[web2py:/] Re: BETWEEN functionality

2009-04-09 Thread jmvermeer
Denes, Thanks for you reply. The function now reads like: def byzipcode(): form=form_factory(SQLField('zipcoderegion',requires=IS_NOT_EMPTY ())) if form.accepts(request.vars,session): minmax=db(db.zipcoderegions.region==request.vars.zipcoderegion) \ .select(db.zipcodereg