[web2py:27026] Re: killer app idea

2009-07-20 Thread JohnMc
Presumably to have this survivable you would want multiple replicated hosts sitting out in the cloud with no content on them other than pointers to content. All the content is out on the cloud as disparate objects. That provides an attacker a two pronged problem. It is not sufficient just to bring

[web2py:27025] Re: killer app idea

2009-07-20 Thread Trollkarlen
I think something like this would be fairly simple to modify for this purpose: http://en.wikipedia.org/wiki/Kademlia But i think that making a db back end where the db for the news site is a distributed hash table is the best approach. And then just front ends that uses this db in web2py the fron

[web2py:27024] Re: Web2Py Editor Graphical glitches

2009-07-20 Thread JohnMc
Yes I have seen this too. (I named it ghosting.) At least for me the one thing that seems to clear it up is to do a save followed by a page reload. But that does not prevent it from recurring. On Jul 20, 9:27 pm, Bottiger wrote: > I remember that I mentioned that the Web2Py editor had graphical

[web2py:27023] Re: Getting the next record

2009-07-20 Thread Hans Donner
On Tue, Jul 21, 2009 at 07:49, rb wrote: > I do have a point: the DAL does not seem to > support multi-column keys. It also does not support multi-column > constraints. DAL itself does not yet support this, however you can always execute SQL directly to apply these constraints on DB level. > I'

[web2py:27022] Re: Forms and dates

2009-07-20 Thread vneves
thanks! On Jul 20, 6:27 pm, mdipierro wrote: > if form.accepts(request.vars, session,onvalidation=lambda form:\ >     (form.vars.init < form.vars.end) or form.errors.update({'end:'Must > be before init'})) > > On Jul 20, 3:23 pm, vneve wrote: > > > Hello, > > > I have a form that is something l

[web2py:27021] Re: Getting the next record

2009-07-20 Thread rb
Well I apologize if I seem to have wandered a bit in my postings here but I have enjoyed the exchange and it helped me think through the problem a bit. I started out with an observation about the "id" field being the primary key and some thoughts on its dangers. Then I wandered a bit. But I do hav

[web2py:27020] Re: Questions for large deployment

2009-07-20 Thread Bottiger
If it is truly not computationally intensive, and does not even use a database, it should not be a problem. I have benchmarked Web2Py on the static welcome page to 700 requests/ second with a concurrency level of 50. To increase the level of concurrency (if you have additional CPU cores), you sh

[web2py:27019] Does CRON work on GAE?

2009-07-20 Thread Vidul Petrov
Probably this topic has been discussed in the past, but I wasn't able to find anything. The cron script works fine (it's implemented as a controller method) unless running in the GAE testing environment. The username in app.yml is web2py, the same goes for the username in "crontab" file. Thank yo

[web2py:27018] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
anyway, since I'm Scribus-ing other things, I'll go with you on that here... perhaps we can share master pages, etc. so the slew of stuff (eventually) has some "common"-ish look to it. On Mon, Jul 20, 2009 at 11:34 PM, Yarko Tymciurak wrote: > (and yes, on looking again, sure: reST doesn't addr

[web2py:27017] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
(and yes, on looking again, sure: reST doesn't address the 1st 2, nor does (if I'm getting you) LaTex (by itself, nor TeX in general), troff, or any of the wiki markups, nor XML-ish stuff On Mon, Jul 20, 2009 at 11:31 PM, Yarko Tymciurak wrote: > :-) Ahh, mercy at last! ;-) > > > On Mon, Ju

[web2py:27016] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
:-) Ahh, mercy at last! ;-) On Mon, Jul 20, 2009 at 11:27 PM, JohnMc wrote: > > Yarko, > > I could go into a long histronic on document systems and disparate > roles for each but I will pass. I'll just close with the comment that > the four roles are distinct and not to be merged. Learned that

[web2py:27015] Re: HOW2Py

2009-07-20 Thread JohnMc
Yarko, I could go into a long histronic on document systems and disparate roles for each but I will pass. I'll just close with the comment that the four roles are distinct and not to be merged. Learned that at Xerox. JohnMc On Jul 20, 10:49 pm, Yarko Tymciurak wrote: > On Mon, Jul 20, 2009 at

[web2py:27014] Questions for large deployment

2009-07-20 Thread Anand Vaidya
Hi After a couple of web2py projects, I am confident of coding a fairly big app in web2py. My previous projects did not need any database (we had to use flatfiles), the new project is also similar. I intend to bypass the models etc completely. The app is likely to be used in a corporate setting

[web2py:27013] Re: Web2Py Editor Graphical glitches

2009-07-20 Thread Jonathan Lundell
On Jul 20, 2009, at 8:37 PM, Yarko Tymciurak wrote: > oh! I recognize this; it might be why I initially went to Safari > "its all text" plugin... It's a rather odd glitch, in that once it shows up it's very hard to get rid of. Repainting and such won't do the trick. > > On Mon, Jul 20, 200

[web2py:27012] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 4:41 PM, JohnMc wrote: > > Yarko, > > Understand your viewpoint as well. Documentation is a 4 part process - > create, edit, format, distribute. reST is excellent on the last 2 > points and bordering on sad on the first two. > BTW - didn't mean to sound harsh, but this mi

[web2py:27011] Re: web2py-users and web2py-developers

2009-07-20 Thread weheh
Bottiger, you may be jumping to conclusions prematurely. My experience to date with this group is that it is inclusive, not exclusive. That Massimo et. al. are interested in positive, constructive, even revolutionary ideas, not flame wars. Love, not hate. Peace, not war. Separating developers from

[web2py:27010] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 4:41 PM, JohnMc wrote: > > Yarko, > > Understand your viewpoint as well. Documentation is a 4 part process - > create, edit, format, distribute. reST is excellent on the last 2 > points and bordering on sad on the first two. This seems like your opinion (to which you are

[web2py:27009] Re: Web2Py Editor Graphical glitches

2009-07-20 Thread Yarko Tymciurak
oh! I recognize this; it might be why I initially went to Safari "its all text" plugin... On Mon, Jul 20, 2009 at 10:01 PM, Jonathan Lundell wrote: > > On Jul 20, 2009, at 7:27 PM, Bottiger wrote: > > > I remember that I mentioned that the Web2Py editor had graphical > > glitches but no one bel

[web2py:27008] Re: The 80/20 rule

2009-07-20 Thread Yarko Tymciurak
from a recent couchDB presentation at ChiPy, mention was about stability and "non-existent security / access controls" Not sure the extent, but this put it off my radar for my list (but I'm happy for any evidence / additional info to change that) On Mon, Jul 20, 2009 at 8:16 PM, Bottiger wro

[web2py:27007] Re: Anyone in Southern Calif

2009-07-20 Thread weheh
I used to go to the Northern Cal Piggies group meetings occasionally and I must say that Piggies rock. And this is definitely a good topic for the group. I would consider doing it if you bought me a ticket from the east coast to Orange County ;^) --~--~-~--~~~---~--~---

[web2py:27006] Re: GAE upload from appadmin (site)

2009-07-20 Thread Yarko Tymciurak
Did you create a Google App Engine account, accept the agreement, etc? http://appengine.google.com/ On Mon, Jul 20, 2009 at 5:47 PM, Tim Michelsen wrote: > > Did anyone succeed uploading an application to GAE using the deploy button? > I tried to upload a scaffolding app using my email and pas

[web2py:27005] Re: killer app idea

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 5:26 PM, JohnMc wrote: > > Yarko, > > Definitely not. Neither service has security features. I was > commenting more the P2P nature of the vehicle itself. > > I would point out any nation willing to massacre its citizens would > think nothing of turning off top level route

[web2py:27004] Re: Getting the next record

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 4:32 PM, rb wrote: > > Thx so much for your (quick) replies. It really helps to have a > conversation sometimes. > > On Jul 20, 12:40 pm, Yarko Tymciurak wrote: > > On Mon, Jul 20, 2009 at 2:27 PM, rb wrote: > > > > > No, what is an "ordering" table? > > > > YOU create a

[web2py:27003] Re: HOW2Py

2009-07-20 Thread JohnMc
Alex, Certainly can, and will. Fact it brings up yet another 'opportunity' for consideration. Hopefully the How2Pys will include the sample code run ready. If that is the case why not just put the documentation in /static? (or someplace better?) That way it is totally contained in the .zip/.w2p

[web2py:27002] Re: HOW2Py

2009-07-20 Thread JohnMc
Yarko, One other point, "Shinx not working" . My mind Sphinx works great! Its the other end I am worried about. On Jul 20, 4:21 pm, Yarko Tymciurak wrote: > On Mon, Jul 20, 2009 at 4:16 PM, Hans Donner wrote: > > > guys, aren't we confusing goal and tools again? > > > goal: get some more docum

[web2py:27001] Re: HOW2Py

2009-07-20 Thread JohnMc
Yarko, Scribus, yes. I just had it export to PDF. Lot of improvements I would like to include -- * Included graphics need a tad more pixel density for clarity. * added pagination in the footer * More consistent formatting of coding. Welcome your input Yarko. On Jul 20, 4:21 pm, Yarko Tymciura

[web2py:27000] Re: Web2Py Editor Graphical glitches

2009-07-20 Thread Jonathan Lundell
On Jul 20, 2009, at 7:27 PM, Bottiger wrote: > I remember that I mentioned that the Web2Py editor had graphical > glitches but no one believed me. > > I stumbled upon it again while using Chrome, but rest assured, it also > happens in Firefox. I've seen it with Mac Safari 4, too. --~--~

[web2py:26999] Web2Py Editor Graphical glitches

2009-07-20 Thread Bottiger
I remember that I mentioned that the Web2Py editor had graphical glitches but no one believed me. I stumbled upon it again while using Chrome, but rest assured, it also happens in Firefox. http://imgur.com/8AiTg.png --~--~-~--~~~---~--~~ You received this message

[web2py:26998] Re: The 80/20 rule

2009-07-20 Thread Bottiger
Redis requires the entire database to fit in memory. I've done a comparison a couple weeks ago between all of the free distributed databases and found that mongodb and couchdb are the most advanced and with the least quirks and requirements. On Jul 20, 3:44 pm, JohnMc wrote: > Yarko, > > Liked

[web2py:26997] Re: Anyone in Southern Calif

2009-07-20 Thread mikech
I should mention that their wiki is at: http://socal-piggies.org/scp/FrontPage On Jul 20, 4:28 pm, mikech wrote: > And a member of Socal Piggies (So. Cal. Python Users Group)?  They're > looking for presenters at the August meeting.  Maybe an opportunity to > show off Web2py? --~--~-~--~

[web2py:26996] Anyone in Southern Calif

2009-07-20 Thread mikech
And a member of Socal Piggies (So. Cal. Python Users Group)? They're looking for presenters at the August meeting. Maybe an opportunity to show off Web2py? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-u

[web2py:26995] Re: HOW2Py

2009-07-20 Thread Alex Fanjul
Wow!! impressive John...! Could you provide us with an example zip application ready to install in web2py? thanks in advance!! alex f El 20/07/2009 23:12, JohnMc escribió: > Ok, here is a draft of the article -- > http://76.185.48.154/images/web2pyart1.pdf. > > Have not applied a great deal off

[web2py:26994] Re: GAE upload from appadmin (site)

2009-07-20 Thread Tim Michelsen
Did anyone succeed uploading an application to GAE using the deploy button? I tried to upload a scaffolding app using my email and password but nothing happened. Please share your experiences. Thanks. > After submitting my email and password in the GAE deploy field of the > appadmin: > Tra

[web2py:26993] Re: The 80/20 rule

2009-07-20 Thread JohnMc
Yarko, Liked your list. As to schemeless key:value databases, an interesting one is redis. (http://code.google.com/p/redis/) Has built in persistence, is very fast, extensions to support primitive lists. Have it installed on a box as an experiment. On Jul 19, 5:07 pm, Yarko Tymciurak wrote:

[web2py:26992] Re: Installing web2py as windows service?

2009-07-20 Thread Brian M
Thank you, Thank You! Fran Forgot about pywin32. Had installed it for python2.5 but forgot to re- install when I switched this box to python 2.6. It's always the little things isn't it :D Seems to be working correctly now. Well the installation of the service gave an error "Exception in thread

[web2py:26991] Re: killer app idea

2009-07-20 Thread JohnMc
Yarko, Definitely not. Neither service has security features. I was commenting more the P2P nature of the vehicle itself. I would point out any nation willing to massacre its citizens would think nothing of turning off top level router links serving their country as well if the situation require

[web2py:26990] Re: Getting the next record

2009-07-20 Thread Hans Donner
Hi, 1. Currently web2py relies for this on the DB engine 2. Can always happen. There is no way to prevent this. The main risk with using technical keys is that too much is tied to the id. They are *keys*, and should be used as such. Eg when doing a max(id) and a min(id) no assumptions can be mad

[web2py:26989] Re: Installing web2py as windows service?

2009-07-20 Thread Fran
On Jul 20, 10:27 pm, Brian M wrote: > I'm attempting to get web2py setup as a service under windows XP Pro > but am running in to some problems. > >>python web2py.py -W install Did you install these?: http://sourceforge.net/projects/pywin32/ > Does anyone here have a recommended way to setup we

[web2py:26988] Re: Getting the next record

2009-07-20 Thread rb
> Using this kind of technical keys (auto increment id, where > autoincrement is provided by db) is quite common fo db-design. In fact Yes, and Codd himself said it is wrong, wrong, wrong to do so. Myself, I can only see a problem if/when: 1. the id gets reused or 2. if the record gets deleted

[web2py:26987] Re: override default model values in SQLFORM

2009-07-20 Thread David Zejda
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Oh sorry, I just overlooked the initial reply.. :o) Hans Donner napsal(a): > David, 10 minutes after your original post there was already a reply: > > http://groups.google.com/group/web2py/browse_thread/thread/de36120b9337f00d/1fde78aa5827a84c?hl=en

[web2py:26986] Re: Getting the next record

2009-07-20 Thread Hans Donner
Using this kind of technical keys (auto increment id, where autoincrement is provided by db) is quite common fo db-design. In fact re-using id's is more 'dangerous': normally the id is used in another table to make a reference. If for some reason not all related tables are maintained correctly (eg

[web2py:26985] Re: SQLForm and IS_NULL_OR(IS_IN_DB( ... multiple=True))

2009-07-20 Thread David Zejda
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OK, I will go without None, zero choice will be sufficient, if I alter the program a bit... mdipierro napsal(a): > You should not combine > > IS_IN_DB(db, 'table.id', 'table.name', multiple=True) > with > IS_NULL_OR() > > because if multiple choice

[web2py:26984] Re: HOW2Py

2009-07-20 Thread JohnMc
Yarko, Understand your viewpoint as well. Documentation is a 4 part process - create, edit, format, distribute. reST is excellent on the last 2 points and bordering on sad on the first two. Tim, Might look into your suggestion. Been a year since I have used Lyx but it was reasonably proficient

[web2py:26983] Re: MySQL - OperationalError: Error on rename (errno: 150)

2009-07-20 Thread David Zejda
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My tables are actually InnoDB - they are generated by DAL. D. mdipierro napsal(a): > The DAL assumes InnoDB, not MYISAM. Perhaps that is the problem? > > On Jul 20, 12:05 pm, David Zejda wrote: > Hello, > > my db backend is MySQL 5.0.51a-24 on Li

[web2py:26982] Re: Oracle Errors on multiple row retrieval

2009-07-20 Thread DJ
Hi Massimo, Tried the db.commit and I still get the error. Not sure what is causing it. I have another SQL search query which works fine. I have included code fragments from both functions for comparison. Any help would be appreciated. Thanks. # SQL search query -- Web2py 1.56, Oracle 10g # #---

[web2py:26981] Re: Getting the next record

2009-07-20 Thread rb
Thx so much for your (quick) replies. It really helps to have a conversation sometimes. On Jul 20, 12:40 pm, Yarko Tymciurak wrote: > On Mon, Jul 20, 2009 at 2:27 PM, rb wrote: > > > No, what is an "ordering" table? > > YOU create a db table where YOU impose your order, e.g. > > db.define_table

[web2py:26980] Installing web2py as windows service?

2009-07-20 Thread Brian M
I'm attempting to get web2py setup as a service under windows XP Pro but am running in to some problems. >>python web2py.py -W install WARNING:root:no file locking default applications appear to be installed already web2py Enterprise Web Framework Created by Massimo Di Pierro, Copyright 2007-2009

[web2py:26979] Re: Forms and dates

2009-07-20 Thread mdipierro
if form.accepts(request.vars, session,onvalidation=lambda form:\ (form.vars.init < form.vars.end) or form.errors.update({'end:'Must be before init'})) On Jul 20, 3:23 pm, vneve wrote: > Hello, > > I have a form that is something like this: > > form = form_factory( >         SQLField('init'

[web2py:26978] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
For example, Scribus lets you import pages - any thoughts of sharing scribus source, so we can import "articles" into one master-page oriented output? On Mon, Jul 20, 2009 at 4:21 PM, Yarko Tymciurak wrote: > > On Mon, Jul 20, 2009 at 4:16 PM, Hans Donner wrote: > >> >> guys, aren't we confusing

[web2py:26977] Re: Is this doable : input from one client, display to another ?

2009-07-20 Thread fpp
Thanks Massimo. The reversehttp method sounds a bit *too* sophisticated (or at least under-documented) to me, I guess I'll try the first one for a start. Is it not possible for a client to maintain a long-running xlmhttprequest by which the server can refresh the screen at will ? On 20 juil, 16

[web2py:26976] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 4:16 PM, Hans Donner wrote: > > guys, aren't we confusing goal and tools again? > > goal: get some more documentation, tips and tricks etc published > tool: whatever to accomplish the goal RIght; and they overlap here: publish == accessible; whatever the tools, agreemen

[web2py:26975] Re: SQLForm and IS_NULL_OR(IS_IN_DB( ... multiple=True))

2009-07-20 Thread mdipierro
You should not combine IS_IN_DB(db, 'table.id', 'table.name', multiple=True) with IS_NULL_OR() because if multiple choices are permitted, zero choices are also permitted. Massimo On Jul 20, 1:32 pm, DenesL wrote: > On Jul 20, 1:49 pm, David Zejda wrote: > > > > > Hello, > > > for > > IS_NULL

[web2py:26974] Re: MySQL - OperationalError: Error on rename (errno: 150)

2009-07-20 Thread mdipierro
The DAL assumes InnoDB, not MYISAM. Perhaps that is the problem? On Jul 20, 12:05 pm, David Zejda wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello, > > my db backend is MySQL 5.0.51a-24 on Linux. > > If I try to gently alter already generated table schema, like to rename > > SQ

[web2py:26973] Re: HOW2Py

2009-07-20 Thread Hans Donner
guys, aren't we confusing goal and tools again? goal: get some more documentation, tips and tricks etc published tool: whatever to accomplish the goal if sphinx isn't working for us in this case, it will not be the tool for this. I'd rather have some first editions in whatever format, based on t

[web2py:26972] Re: HOW2Py

2009-07-20 Thread JohnMc
Ok, here is a draft of the article -- http://76.185.48.154/images/web2pyart1.pdf. Have not applied a great deal off formatting. Looking for input as to preferences in that regard. JohnMc On Jul 19, 10:13 pm, Yarko Tymciurak wrote: > On Sun, Jul 19, 2009 at 7:49 PM, Tim Michelsen > wrote: > >

[web2py:26971] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
> Sphinx + reST is what Pycon chose for some reasons. T > sorry - meant to say Python... (e.g. docs.python.org, etc. ... as well as numpy, and on and on...) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-u

[web2py:26970] Re: HOW2Py

2009-07-20 Thread Tim Michelsen
JohnMc schrieb: > "The shell scripts for making web2py specific sphinx docs I don't > think apply > to your question of what tools do I use to create rest (that is, the > structured format of the content). > > But bottom line is still - you can easily just use a normal text > editor " > - Yar

[web2py:26969] Re: HOW2Py

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 3:27 PM, JohnMc wrote: > > "The shell scripts for making web2py specific sphinx docs I don't > think apply > to your question of what tools do I use to create rest (that is, the > structured format of the content). > > But bottom line is still - you can easily just use a n

[web2py:26968] GAE upload from appadmin (site)

2009-07-20 Thread Tim Michelsen
After submitting my email and password in the GAE deploy field of the appadmin: Traceback (most recent call last): File "/devel/web2py/web2py_gae/gluon/restricted.py", line 107, in restricted exec ccode in environment File "/devel/web2py/web2py_gae/applications/admin/controllers/gae

[web2py:26967] Re: HOW2Py

2009-07-20 Thread JohnMc
"The shell scripts for making web2py specific sphinx docs I don't think apply to your question of what tools do I use to create rest (that is, the structured format of the content). But bottom line is still - you can easily just use a normal text editor " - Yarko Why of course I can create r

[web2py:26966] Forms and dates

2009-07-20 Thread vneve
Hello, I have a form that is something like this: form = form_factory( SQLField('init', 'date',), SQLField('end', 'date'), ) The problem is, I don't want to insert those fields into the equivalent db table unless 'init' < 'end'. I'm aware I could do this: if form.accept

[web2py:26965] Re: killer app idea

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 3:03 PM, JohnMc wrote: > > Massimo, > > Hmm. Latest version of Google Reader does what you suggest. I also > think I seen a subset as a Yahoo Pipes filter. I don't think either of those masks IP paths, prevents government censorship / tracking; For some interesting back

[web2py:26964] Re: killer app idea

2009-07-20 Thread JohnMc
Massimo, Hmm. Latest version of Google Reader does what you suggest. I also think I seen a subset as a Yahoo Pipes filter. But the creation side as a news syndicate as a P2P is an intriguing idea. I would even suggest getting money grubby with such an idea for the simple fact that there are unaf

[web2py:26963] Re: Getting the next record

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 2:27 PM, rb wrote: > > No, what is an "ordering" table? YOU create a db table where YOU impose your order, e.g. db.define_table('mystuf', db.Field('name'), db.Field('comment')) db.define_table('myorder_mystuff', db.Field( 'my_sequence', integer #? or whatever), db.Fiel

[web2py:26962] Re: Getting the next record

2009-07-20 Thread rb
No, what is an "ordering" table? The DAL assumes an id field as the primary key in all tables. Thus the internal ordering is always by this id field value. The natural ordering would then be by insertion order (later insertions would have a higher id value than earlier insertions). After some dele

[web2py:26961] Re: Problem with SQLFORM.accepts (?)

2009-07-20 Thread Jonathan Lundell
On Jul 20, 2009, at 9:04 AM, Yarko Tymciurak wrote: > On Mon, Jul 20, 2009 at 9:33 AM, Jonathan Lundell > wrote: > > On Jul 20, 2009, at 7:22 AM, mdipierro wrote: > > > > > The error is here: > > > > IS_NOT_IN_DB(db,db.strona) > > > > the second argument has to be a field, not a table. > > Woul

[web2py:26960] Re: Problem with SQLFORM.accepts (?)

2009-07-20 Thread DenesL
Or just add a check to the __init__ to see if parameter "field" is really one. Not as easy as isinstance(field, SQLField) since it has to allow for 'table.field' strings but nor overly complicated either. The performance hit should be very low. --~--~-~--~~~---~--~--

[web2py:26959] Re: Getting the next record

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 2:07 PM, rb wrote: > > Oops. I made a small mistake. Isn't it true that I could get the Next > record (of a table having the 'name' field as its primary key) using > > rows = db(db.table.name > current_value).select(db.table.ALL, > orderby=db.table.name, limitby=(0,1)) > >

[web2py:26958] Re: Getting the next record

2009-07-20 Thread rb
Oops. I made a small mistake. Isn't it true that I could get the Next record (of a table having the 'name' field as its primary key) using rows = db(db.table.name > current_value).select(db.table.ALL, orderby=db.table.name, limitby=(0,1)) Then my next record would be found in rows[0] ? And to g

[web2py:26957] Getting the next record

2009-07-20 Thread rb
I am a bit flummoxed over dbs that insist on using an "id" field as their primary key. Specifically I would like to be able to access records via a more "btrieve" or old-style "ordered set" mode of GetFirst, Get Prev, GetNext, GetLast. The web2py manual gives a neat trick to paginate records which

[web2py:26956] Re: At least in Italy we are second

2009-07-20 Thread Francisco Gama
that's embarassing... a Python portal supported by Drupal (PHP). On Jul 20, 12:22 pm, Alex Fanjul wrote: > Now First Massimo... > with almost 60% of votes > > congratulations!! > > El 18/07/2009 23:51, mdipierro escribió: > > > Hey, > > > my fellow countrymen are having a poll: > > >    http://

[web2py:26955] Re: SQLForm and IS_NULL_OR(IS_IN_DB( ... multiple=True))

2009-07-20 Thread DenesL
On Jul 20, 1:49 pm, David Zejda wrote: > Hello, > > for > IS_NULL_OR(IS_IN_DB(db, 'table.id', 'table.name')) > SQLForm generates a combo with a None as a selectable value. > > There is also a relatively new support for multiple fields: > IS_IN_DB(db, 'table.id', 'table.name', multiple=True) > It

[web2py:26954] Re: SQLForm and IS_NULL_OR(IS_IN_DB( ... multiple=True))

2009-07-20 Thread Yarko Tymciurak
2009/7/20 David Zejda > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello, > > for > IS_NULL_OR(IS_IN_DB(db, 'table.id', 'table.name')) > SQLForm generates a combo with a None as a selectable value. The third field in IN_IN_DB() is a string that describes the elements of the dropbox.

[web2py:26953] SQLForm and IS_NULL_OR(IS_IN_DB( ... multiple=True))

2009-07-20 Thread David Zejda
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, for IS_NULL_OR(IS_IN_DB(db, 'table.id', 'table.name')) SQLForm generates a combo with a None as a selectable value. There is also a relatively new support for multiple fields: IS_IN_DB(db, 'table.id', 'table.name', multiple=True) It generates

[web2py:26952] MySQL - OperationalError: Error on rename (errno: 150)

2009-07-20 Thread David Zejda
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, my db backend is MySQL 5.0.51a-24 on Linux. If I try to gently alter already generated table schema, like to rename SQLField('relation', 'text', requires = \ IS_NULL_OR(IS_IN_DB(db, 'relation_type.id', 'relation_type.id', multiple=Tru

[web2py:26951] Re: Problem with SQLFORM.accepts (?)

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 9:33 AM, Jonathan Lundell wrote: > > On Jul 20, 2009, at 7:22 AM, mdipierro wrote: > > > > > The error is here: > > > > IS_NOT_IN_DB(db,db.strona) > > > > the second argument has to be a field, not a table. > > Would it be an overcomplication to sprinkle a few asserts throu

[web2py:26950] Re: Invalid field names starting with "_" char

2009-07-20 Thread Yarko Tymciurak
On Mon, Jul 20, 2009 at 5:57 AM, mdipierro wrote: > > Yes, but the new DAL will allow you use map virtual names into actual > names and you will be able to use those tables. Good to know this is in the plans > > > On Jul 19, 5:22 pm, Boriel wrote: > > On Sun, Jul 19, 2009 at 23:19, Hans

[web2py:26949] Re: Problem with SQLFORM.accepts (?)

2009-07-20 Thread Jonathan Lundell
On Jul 20, 2009, at 7:22 AM, mdipierro wrote: > > The error is here: > > IS_NOT_IN_DB(db,db.strona) > > the second argument has to be a field, not a table. Would it be an overcomplication to sprinkle a few asserts throughout web2py to help out with this kind of thing? I can imagine it'd speed

[web2py:26948] Re: Problem with SQLFORM.accepts (?)

2009-07-20 Thread mdipierro
The error is here: IS_NOT_IN_DB(db,db.strona) the second argument has to be a field, not a table. On Jul 20, 8:10 am, Karol Grębski wrote: > I'm not sure if I'm doing something wrong, or if it's a bug in web2py, > but I get an interesting ticket when I try tu submit a new news into > my databa

[web2py:26947] Re: Is this doable : input from one client, display to another ?

2009-07-20 Thread mdipierro
yes, the simpler way is to have the second client (the fixed unit) periodically refresh the screen via ajax. the more sophisticated way is to use something like this http://www.reversehttp.net/demos/ so that server can push data to the other client. On Jul 20, 6:02 am, fpp wrote: > Hi, > > I

[web2py:26946] [web2py 1.64.4]Problem with SQLFORM.accepts (?)

2009-07-20 Thread Karol Grębski
I'm not sure if I'm doing something wrong, or if it's a bug in web2py, but I get an interesting ticket when I try tu submit a new news into my database. Any sudgestions? *** Traceback (most recent call last): File "/home/mlody/Desktop/cherry/web2py/gluon/restricted.py", line 107, in restricted

[web2py:26945] Re: error messages in Auth.change_password

2009-07-20 Thread Fran
On Jul 20, 1:00 pm, Alex Fanjul wrote: > Massimo, couldnt we use T function in such messages for > internationalization? > With: auth.messages.submit_button = T('Enviar') > the system complain with: > TypeError:unsupported operand type(s)for%:'lazyT'and'Storage' auth.messages should be of type M

[web2py:26944] Re: error messages in Auth.change_password

2009-07-20 Thread Alex Fanjul
Massimo, couldnt we use T function in such messages for internationalization? With: auth.messages.submit_button = T('Enviar') the system complain with: TypeError:unsupported operand type(s)for%:'lazyT'and'Storage' thanks alex f El 19/07/2009 20:28, sebastianovide+...@gmail.com escribió: > aut

[web2py:26943] Re: At least in Italy we are second

2009-07-20 Thread Alex Fanjul
Now First Massimo... with almost 60% of votes congratulations!! El 18/07/2009 23:51, mdipierro escribió: > Hey, > > my fellow countrymen are having a poll: > > http://www.python-it.org/ (on the left column) > > Looks like at least there we are second so far. > > Massimo > > > > -- Alej

[web2py:26942] Is this doable : input from one client, display to another ?

2009-07-20 Thread fpp
Hi, I have an idea for an app I'd like to try out, but I'm not sure if it's actually possible to do this with http. Basically the app server would be dedicated and have only two clients : - one, a mobile, tactile unit, would only display a sort of menu (think big buttons) and send input from ch

[web2py:26941] Re: Condensing jquery.js

2009-07-20 Thread mdipierro
Alvaro is working on a patch for this. He can do it already but we need to make sure it does not hit performance. On Jul 20, 12:07 am, Bottiger wrote: > Is there any reliable way to condense common static files into one > folder? > > For example, Jquery, a 56 kb file, is replicated among every >

[web2py:26940] Re: Invalid field names starting with "_" char

2009-07-20 Thread mdipierro
Yes, but the new DAL will allow you use map virtual names into actual names and you will be able to use those tables. On Jul 19, 5:22 pm, Boriel wrote: > On Sun, Jul 19, 2009 at 23:19, Hans Donner wrote: > > > for now it has too much impact to change it in the DAL. Simply > > removing the indic

[web2py:26939] Re: running all doctests in gluon and up

2009-07-20 Thread mdipierro
hans, since I am out of town with limited connectivity, can you please collect these patches and email them to me at the end of the week? thanks. On Jul 19, 9:52 am, Hans Donner wrote: > hi all, > > the following script is currently planned in gluon\tests and is for > running doctests on all

[web2py:26938] Re: web2py-users and web2py-developers

2009-07-20 Thread mdipierro
welcome from Beijing. Yarko is referring the Clojure agreement. http://clojure.org/space/showimage/ca.pdf Somebody pointed me to it. I do not have a strong feeling but seems clears and concise. massimo On Jul 19, 6:04 am, Yarko Tymciurak wrote: > On Sun, Jul 19, 2009 at 5:36 AM, Fran wrote: