Re: [web2py] Re: on grid and smartgrid search feature

2011-10-12 Thread Johann Spies
On 12 October 2011 14:59, stefaan wrote: > > I have replaced my all my similar .js and .css files with that of the > > welcome app but I see no popup panel. > > It may be that the old .css is cached in your browser and needs to be > reloaded > - try to refresh the browser page once. That was the

[web2py] using request.restful() for POST ?

2011-10-12 Thread Anaconda
I have been going through the video tutorial on this at "http:// vimeo.com/21133657" and i can get everything to work except the Post requests. I may be calling it incorrectly in my browser, has anyone done the tutorial and done it correctly? @request.restful() def manage_dog(): def GET(id):

Re: [web2py] Re: Internal error

2011-10-12 Thread Johann Spies
On 12 October 2011 15:31, Massimo Di Pierro wrote: > How long is the list of sids? Slite? This is not a web2py error but > most likely a driver error. Try commit after every every update. > > Thanks for your reply Massimo. The list is normally not long - between 1 and 5 most of the times although

Re: [web2py] Re: Memory problems on Webfaction

2011-10-12 Thread Johann Spies
On 13 October 2011 06:44, MidGe wrote: > hello elffikkl, > > I tried your suggestion, but I am not having your success. > > The install succeed, but the admin fails. It keeps requesting me to log > in although it does recognize my password as valid! > > Any suggestions? > > I have another 5 day

[web2py] Re: Storing date format in dd-mm-yyyy in database

2011-10-12 Thread pbreit
It's still generally better to store the date in a standard format and re-arrange it for display purposes. There is a good chance you will thank yourself later for doing it this way.

[web2py] Re: IMPORTANT

2011-10-12 Thread guruyaya
I could be wrong, but I don't think I remember any discussions that go out of line, in this forum. I don't remember any politics discussions, any religious or scientific, that went out of line. Is this, really a such a big problem that requires it's own policy? We don't need this policy, just as mu

Re: [web2py] Re: Memory problems on Webfaction

2011-10-12 Thread MidGe
hello elffikkl, I tried your suggestion, but I am not having your success. The install succeed, but the admin fails. It keeps requesting me to log in although it does recognize my password as valid! Any suggestions? I have another 5 days left on this webfaction account if anything is worth

[web2py] web2conf update: PyConAr 2011 version

2011-10-12 Thread Mariano Reingart
FYI I have merged branches, pulled clones and updated the web2conf repository with the application used for PyCon Argentina 2011. web2conf is a minimalist conference management system, started for PyCon 2009 registration and used in several events: http://code.google.com/p/web2conf/ Change hist

Re: [web2py] IMPORTANT

2011-10-12 Thread Bruno Rocha
How about including a diversity statement to the main website? just like these ones: http://www.python.org/community/diversity/ http://www.dreamwidth.org/legal/diversity http://www.ubuntu.com/community/ubuntuvalues

[web2py] Re: web2ruby possible?

2011-10-12 Thread wwwgong
Vote for node.js On Sep 11, 5:40 pm, "dustin.b" wrote: > 1+ vote for node.js ;) > > On 11 Sep., 21:14, David Marko wrote: > > > > > Or to node.js :-)

[web2py] Re: IMPORTANT

2011-10-12 Thread TheSweetlink
On Oct 12, 8:08 pm, Daniel Aguayo wrote: > El 12/10/11 18:17, Stefaan Himpe escribi : > > >> Do we need a policy about this? > > > "live and let live" ? > > ++1 > > I would be worried if anyone take seriously enough another user signature > ;3 +1 all of the above for funny and true. > ... Or

[web2py] Re: confused with install on centos 5.7

2011-10-12 Thread TheSweetlink
CentOS 5 uses an old ver of python I believe but I stopped after 5.6. The only way I got it to work was under virtualenv and that was after compiling separate version of python (best not to dump the old version as yum depends on python 2.4). As Peter states it will require great manual labor on yo

[web2py] Re: manual file upload using SQLFORM.factory

2011-10-12 Thread TheSweetlink
Full stack strikes again. On Oct 12, 10:46 am, Massimo Di Pierro wrote: > The url is validated. .. is not allowed in the URL. > I commend you Massimo and happy to see you respond so level headed to such an emotionally driven thread (elsewhere btw)...again.

[web2py] Re: Bug in included table, or am I using this incorrectly?

2011-10-12 Thread Massimo Di Pierro
You need to do: included = db.Table('included', Field('uniq', unique=True)) including = db.define_table('including', included, Field('field1')) including.uniq.requires=IS_NOT_IN_DB(db,'including.uniq') The last line is necessary because it is not obvious that you want to be unique respect to the

[web2py] Re: Storing date format in dd-mm-yyyy in database

2011-10-12 Thread Rohit
Vinicius Assef writes: > > Clarifying, > date fields are stored in internal format and they are optimized for that. > > You can customize representation format, not stored format. It was > what Ovidio showed you. > > -- > Vinicius Assef. > > On Tue, Oct 11, 2011 at 10:16 PM, Ovidio Marinho

[web2py] Re: Using SQLCustomType to implement bigint in MySQL

2011-10-12 Thread Massimo Di Pierro
Fixed in trunk. Please check it. On Oct 12, 11:59 am, Massimo Di Pierro wrote: > Please open a ticket. Looks like a bug but it can be fixed in 12hrs. > > On Oct 12, 10:31 am, chris_g wrote: > > > > > > > > > I am trying to define a custom type on a MySQL db and I get the error > > below. My moti

[web2py] Re: Better off-line book?

2011-10-12 Thread Massimo Di Pierro
Actually that is a good idea. Let me give it some thought. On Oct 12, 7:48 pm, ~redShadow~ wrote: > @Massimo > > Some time ago I bought the web2py book, to have offline documentation > (connectivity is getting worse and worse here in italy, and I don't want > to rely on that for docs..) and to su

[web2py] Re: RESTful interfaace

2011-10-12 Thread Massimo Di Pierro
Writing it It may change but not too much. On Oct 12, 7:40 pm, ~redShadow~ wrote: > On Wed, 2011-10-12 at 17:25 -0700, Massimo Di Pierro wrote: > > [..cut..] > > I've already seen this example somewhere (is it in the book?) but it > looks like the whole REST-server thing is quite undocumented

[web2py] Better off-line book?

2011-10-12 Thread ~redShadow~
@Massimo Some time ago I bought the web2py book, to have offline documentation (connectivity is getting worse and worse here in italy, and I don't want to rely on that for docs..) and to support the project. But I'm using more the online book than the pdf since I find the navigation in html docume

Re: [web2py] Re: RESTful interfaace

2011-10-12 Thread ~redShadow~
On Wed, 2011-10-12 at 17:25 -0700, Massimo Di Pierro wrote: > [..cut..] I've already seen this example somewhere (is it in the book?) but it looks like the whole REST-server thing is quite undocumented and not advertised as it should.. is that just experimental and might change in the future? Or,

[web2py] Re: RESTful interfaace

2011-10-12 Thread Massimo Di Pierro
You can do: @request.restful() def api(): response.view = 'generic.json' def GET(tablename,id): if not tablename=='person': raise HTTP(400) return dict(person = db.person(id)) def POST(tablename,**fields): if not tablename=='person': raise HTTP(400) retu

Re: [web2py] Re: IMPORTANT

2011-10-12 Thread Daniel Aguayo
El 12/10/11 18:17, Stefaan Himpe escribió: Do we need a policy about this? "live and let live" ? ++1 I would be worried if anyone take seriously enough another user signature ;3

[web2py] Re: how to restrict a field to be alphabet only

2011-10-12 Thread Saurabh S
thank you all On Oct 12, 7:37 pm, Vinicius Assef wrote: > But not '*', '%' and so on. hehehe > > > > > > > > On Wed, Oct 12, 2011 at 10:00 AM, Anthony wrote: > > Yeah, that's probably better for names. Names can include hyphens as well. > > > On Wednesday, October 12, 2011 8:56:35 AM UTC-4, spyk

[web2py] Re: IMPORTANT

2011-10-12 Thread villas
Do we need a policy? Yes! Maybe you could simply add a sentence to the policy you have already written: This group is secular and non-political and group members are requested to bear this in mind when making posts. If I see any statement that will appear discriminatory towards any group o

[web2py] RESTful interfaace

2011-10-12 Thread Arturo Filastò
I wish to implement a RESTful interface with web2py. What I would like to know is what is the most web2py friendly way of doing so. Is there a way to have the data inserted into the database without me having to write the queries myself? I am basically looking for the equivalent of forms.accepts(

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread Omi Chiba
Aha! You need to hit "<-" "->" on your key board to slide the page. It takes me five minutes to figure out. Maybe we should have a little user friendly navigation like the one on slideshare which has a little clickable arrow at the bottom. http://www.slideshare.net/amiable_indian/introduction-to-

[web2py] Re: IMPORTANT

2011-10-12 Thread Stefaan Himpe
Do we need a policy about this? "live and let live" ?

[web2py] Bug in included table, or am I using this incorrectly?

2011-10-12 Thread nick name
Note: tested on 1.97.1; I believe problem (or my misunderstanding) is still on trunk. I tried to check with trunk, but I have some compatibility problems to solve first - I will post an update when I have solved them. I have an included table defined like this: included = db.Table('included',

Re: [web2py] Re: join with SQLFORM.grid

2011-10-12 Thread Marcelo Martinez
Thank you 2011/10/12 Massimo Di Pierro > SQLFORM.grid does not take rows. It take the query itself. It needs > the query to optimize the select for orderby and pagination. You can > in fact do: > > query =(a.dialstatus=='ANSWER')& (a.inicio>=dt1)&(a.inicio<=dt2) > left = > (b.on(a.id_accountcode

[web2py] Re: join with SQLFORM.grid

2011-10-12 Thread Massimo Di Pierro
SQLFORM.grid does not take rows. It take the query itself. It needs the query to optimize the select for orderby and pagination. You can in fact do: query =(a.dialstatus=='ANSWER')& (a.inicio>=dt1)&(a.inicio<=dt2) left = (b.on(a.id_accountcode==b.id),rp.on(a.id_rutaproveedor==rp.id),r.on(rp.id_r u

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread jotbe
http://code.google.com/p/web2py/issues/detail?id=469 Just ask when I should test it. Regards, Jan On 12 Okt., 19:06, Massimo Di Pierro wrote: > I think I found the bug. Please open a ticket so I do not forget. I > can fix this tonight. > > On Oct 12, 10:46 am, "jot.be" wrote: > > > > > > > > >

[web2py] Re: Windows + Apache + mod_proxy

2011-10-12 Thread Paolo Caruccio
Well done! Paolo

Re: [web2py] Re: db events trigger

2011-10-12 Thread Bruno Rocha
Do not forget the *before render* and *after render* and workflow events. this is very useful triggers and are not related to database. maybe it is more easy to implement in template engine. http://zerp.ly/rochacbruno Em 12/10/2011 10:24, "Massimo Di Pierro" escreveu: > So basically the event

[web2py] Re: Display "Loading' animated gif or js : How to

2011-10-12 Thread Paolo Caruccio
Hi Vineet, as juanduke has suggested, I use the following jquery function (I put it in web2py_ayax.js) instead of standard w2p ajax function to show a loading image: function web2py_polling(u,s,t){ $('#'+t).html(''); ajax(u,s,t); } Of course you can set some css rules to custom div#loading_gif

[web2py] JSONP in web2py

2011-10-12 Thread Harshad
I know this has been discussed earlier, but I am not sure how to use JSONP for cross domain communication correctly. This is how I make the request: var jqxhr = $.getJSON('get_devices.jsonp', function(data) { displayList(data); }) .error(function() { alert("

[web2py] Re: problem with iframe widget

2011-10-12 Thread peter
Thanks for the reply Anthony, useful as always. I tried implementing the frame killer killer, but it keeps my page in view no matter what, closing the window being the only way out! Useful to know that it is not a problem with the widget. Peter On Oct 12, 12:13 pm, Anthony wrote: > Sorry, here'

[web2py] Re: IMPORTANT

2011-10-12 Thread annet
I don't want to start a discussion on politics, religion or philosophy but I think it is important to realize that politics and religion can disturb people's live or at least strongly influence their course of life negatively. In that case it may be disturbing to read a signature quoting a politica

[web2py] Re: confused with install on centos 5.7

2011-10-12 Thread peter
Hi Lucas, I found deploying on Centos 5 very hard work. I tried all the methods in the book, and none worked for me. I tried Cherokee and would not recommend that route. nginx with uwsgi was relatively straightforward and is very fast. Here are some useful links https://library.linode.com/web-se

[web2py] join with SQLFORM.grid

2011-10-12 Thread mmartinez
Hello list my doubt is how I can create a list SQLForm.grid from this consultation that I make to the database dt1=datetime.datetime(*time.strptime(request.vars.desde,'%Y-%m-%d %H: %M:%S')[0:6]) dt2=datetime.datetime(*time.strptime(request.vars.hasta, '%Y-%m-%d %H: %M:%S')[0:6]) query =(a.dialst

Re: [web2py] Re: Proper way to calculate/display a time delta?

2011-10-12 Thread Richard Vézina
;-) On Wed, Oct 12, 2011 at 11:48 AM, Nate Atkinson wrote: > Compute field doesn't quite work for calculating days on place > (because it changes every day), but it will make geocoding in my app > much more elegant. > > A virtual field was exactly what I needed. > > Thank you very much! I guess I

[web2py] Re: Can I turn off new Query feature in grid/smartgrid

2011-10-12 Thread Massimo Di Pierro
SQLFORM.gird(,search_widget=None) On Oct 12, 12:02 pm, Jim Steil wrote: > Hi > > Wondering if I can turn off (not display) the new query button in my > SQLFORM.grid and SQLFORM.smartgrid.  If not available today, are there > plans to make it optional? > >      -Jim

[web2py] Re: STOOOPID Question

2011-10-12 Thread Massimo Di Pierro
rows = db(db.products).select(orderby=db.products.name) table = SQLTABLE(rows) You can sort the rows, not the table. The links in the header are just passed back to the action and can use to make the select dependent on them. You can also use table = SQFORM.grid(db.products) and you get

[web2py] Re: Windows + Apache + mod_proxy

2011-10-12 Thread Omi Chiba
Paolo, I just finished summarized this setting and post on my blog. http://ochiba77.blogspot.com/2011/10/how-to-setup-web2py-apache-wsgi-uniform.html On Oct 10, 5:41 pm, Paolo Caruccio wrote: > I am very glad I helped > > Ciao. > > Paolo

[web2py] Re: Python 2.7 on GAE (experimental)

2011-10-12 Thread Massimo Di Pierro
I do not think web2py should move to 2.7. I think web2py on GAE should deploy using 2.7. I do not see any negative side on running on a more modern interpreter which is guaranteed to be there. Everywhere I run I try to get the lastest Python version (2.x of course). On Oct 12, 11:13 am, Changju

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread Massimo Di Pierro
I think I found the bug. Please open a ticket so I do not forget. I can fix this tonight. On Oct 12, 10:46 am, "jot.be" wrote: > markmin2html attached. > > Sample code/CLI-snippet (same as > below):https://gist.github.com/90231ab4713fb2e6588b > > On Wed, Oct 12, 2011 at 5:14 PM, Massimo Di Pierr

[web2py] Can I turn off new Query feature in grid/smartgrid

2011-10-12 Thread Jim Steil
Hi Wondering if I can turn off (not display) the new query button in my SQLFORM.grid and SQLFORM.smartgrid. If not available today, are there plans to make it optional? -Jim

[web2py] Re: DAL level access to GAE entities by named key

2011-10-12 Thread howesc
i know we went back and forth a few months back and i helped with the patch for it, but it was lightly tested and i never used it myself in a production environment. i suspect it's a simple fix and i'll take a look at the DAL as well. cfh

[web2py] Re: Using SQLCustomType to implement bigint in MySQL

2011-10-12 Thread Massimo Di Pierro
Please open a ticket. Looks like a bug but it can be fixed in 12hrs. On Oct 12, 10:31 am, chris_g wrote: > I am trying to define a custom type on a MySQL db and I get the error > below. My motivation is to store data in Bigint rather than Integer. > > bigint = SQLCustomType( >         type = 'int

[web2py] Re: DAL and multiple web2py -S processes.

2011-10-12 Thread Michael Ellis
> Does the error ordinarily happen often enough that you can be confident that > the barrier option makes any difference at all? It could easily be something > else, though the fact that you don't see the problem on OS X suggests a file > system issue. > > The other thing you might experiment wi

Re: [web2py] Re: DAL and multiple web2py -S processes.

2011-10-12 Thread Jonathan Lundell
On Oct 12, 2011, at 9:16 AM, Michael Ellis wrote: > Hmmm, still not completely out of the woods. I've seen one instance > of the error so far on one of the new systems. I ran "PRAGMA > integrity_check" from a sqlite3 command line and saw a bunch of "page > never used" reports. Then I ran VACUUM

[web2py] Fwd: cx_Oracle 5.1.1

2011-10-12 Thread Massimo Di Pierro
FYI, since we use it. Begin forwarded message: From: Anthony Tuininga Date: October 11, 2011 9:43:45 PM CDT To: , , > Subject: cx_Oracle 5.1.1 Reply-To: What is cx_Oracle? cx_Oracle is a Python extension module that allows access to Oracle and conforms to the Python database API 2.0 spe

[web2py] Re: DAL and multiple web2py -S processes.

2011-10-12 Thread Michael Ellis
Hmmm, still not completely out of the woods. I've seen one instance of the error so far on one of the new systems. I ran "PRAGMA integrity_check" from a sqlite3 command line and saw a bunch of "page never used" reports. Then I ran VACUUM and re-ran the integrity check which came back ok. On Oct

[web2py] Re: Python 2.7 on GAE (experimental)

2011-10-12 Thread Changju
Why do we move to Python 2.7 Massimo ? I just wonder what made you think so? Is it due to the Multithreading and Concurrent Request? On Oct 12, 10:22 pm, Massimo Di Pierro wrote: > We should move to python27 for gae > > On Oct 11, 10:47 pm, pbreit wrote: > > > > > > > > >http://code.google.com/a

[web2py] Re: DAL and multiple web2py -S processes.

2011-10-12 Thread Michael Ellis
> I'd turn on the ext4 barrier option just for the heck of it; see what happens. > > http://lwn.net/Articles/283161/ Thank you, Jonathan! That seems promising. I'm now testing it on two systems. So far so good. Let's see if it holds up for a few hours. I can't believe the Linux maintainers dec

Re: [web2py] Re: MongoDB and Web2py

2011-10-12 Thread ~redShadow~
On Wed, 2011-10-12 at 04:07 -0700, David Marko wrote: > Massimo adviced me to use something like this previsously: > > def make_connection(): > from pymongo import Connection > connection = Connection('localhost', 27017) > return connection > > connection = cache.ram('mongodb'

[web2py] Re: two SQLFORM.grid in one view?

2011-10-12 Thread apple
Code below works fine but: 1) change ajax=False => paginate buttons open the correct page on a new tab in the browser. 2) change ajax=True again and change first line of test2 to tablename=request.args(0) and paginate buttons fail as there is no tablename in the request. It is a useful feature in S

[web2py] Re: Proper way to calculate/display a time delta?

2011-10-12 Thread Nate Atkinson
Compute field doesn't quite work for calculating days on place (because it changes every day), but it will make geocoding in my app much more elegant. A virtual field was exactly what I needed. Thank you very much! I guess I skimmed that section of the book too quickly. Best regards, Nate On O

Re: [web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread jot.be
markmin2html attached. Sample code/CLI-snippet (same as below): https://gist.github.com/90231ab4713fb2e6588b On Wed, Oct 12, 2011 at 5:14 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Yes, the markimin and the sample code. > > On Oct 12, 10:03 am, jotbe wrote: > > I am not using

Re: [web2py] IMPORTANT

2011-10-12 Thread Marco Mansilla
El Wed, 12 Oct 2011 06:59:32 -0700 (PDT) Massimo Di Pierro escribió: > Hope nobody gets offended by this email and I have no option but bring > it up because I have received few emails on the topic. > > This is a multinational, multicultural community and this is a very > good thing. We want to

[web2py] Re: Display "Loading' animated gif or js : How to

2011-10-12 Thread juanduke
Hi Vinnet: The easiest way to achive this, is showing a image (http://www.ajaxload.info/

[web2py] Using SQLCustomType to implement bigint in MySQL

2011-10-12 Thread chris_g
I am trying to define a custom type on a MySQL db and I get the error below. My motivation is to store data in Bigint rather than Integer. bigint = SQLCustomType( type = 'integer', native = 'bigint', ) db.define_table('s1', Field('target_id', bigint) ) db.s1.inser

Re: [web2py] Proper way to calculate/display a time delta?

2011-10-12 Thread Richard Vézina
You can use compute type field (search for compute in the book) you just have to put your delta in a lambda function... That if you want to store the computed value... Or you can use virtual field that can compute also (not sure about that) your delta will be execute each time to call you select v

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread Massimo Di Pierro
Yes, the markimin and the sample code. On Oct 12, 10:03 am, jotbe wrote: > I am not using Jython. Please see the version information in my prev. > reply. Strange issue. > > Should I send you my markmin2html.py for comparison? > > On 12 Okt., 16:16, Massimo Di Pierro > wrote: > > > > > > > > > I

Re: [web2py] Re: db events trigger

2011-10-12 Thread Manuele
On 11/10/2011 22:23, Massimo Di Pierro wrote: form=SQLFORM(...).process(onsuccess=lambda form:...) not exactly what I was asking for... I thought about a method of the table object run in specific situation, example just before or just after a new record is inserted and so on... remind that a r

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread jotbe
I am not using Jython. Please see the version information in my prev. reply. Strange issue. Should I send you my markmin2html.py for comparison? On 12 Okt., 16:16, Massimo Di Pierro wrote: > I cannot reproduce it. I get: > > Python 2.7.2 (v2.7.2:8527427914a2, Jun 11 2011, 15:22:34) > [GCC 4.2.1

[web2py] Re: db events trigger

2011-10-12 Thread nick name
Reminder of issue 354: http://code.google.com/p/web2py/issues/detail?id=354 I have never used a select trigger, so I only have vague ideas about how it would be useful. For inserts, a single line is sufficient. For deletes/update, that is not true. You can look at (todor's fixes to) my implem

Re: [web2py] DAL and multiple web2py -S processes.

2011-10-12 Thread Jonathan Lundell
On Oct 12, 2011, at 7:48 AM, Michael Ellis wrote: > Help! I'm running into a serious and puzzling problem running multiple > web2py shell processes against a common database. I'm using web2py > 1.97 and sqlite3 under Linux Mint 10 with an ext4 file system. In a > nutshell, the problem is that I

[web2py] Display "Loading' animated gif or js : How to

2011-10-12 Thread Vineet
A View requests or redirects to some controller. It takes some time to serve the request. In the meantime, how do I display animated "Loading" image? It will disappear after the request is served. Vineet

Re: [web2py] Re: IMPORTANT

2011-10-12 Thread Vinicius Assef
I'm with Ross. I'm part of Brazilians' web2py community and here we face different religious and health beliefs among us. Some of us are activists on twitter about our beliefs. There is our personal channel to spread our word. Here, I'm not supposed to read messages different from web2py issues,

[web2py] Proper way to calculate/display a time delta?

2011-10-12 Thread Nate Atkinson
Hi, The company I work for places environmental measuring devices at different locations. I've designed a simple database to keep track of where we have devices. One thing that's important to us is how long a device has been on site. It's probably easiest to understand if I just paste some code.

[web2py] DAL and multiple web2py -S processes.

2011-10-12 Thread Michael Ellis
Help! I'm running into a serious and puzzling problem running multiple web2py shell processes against a common database.  I'm using web2py 1.97 and sqlite3 under Linux Mint 10 with an ext4 file system.   In a nutshell, the problem is that I'm getting various DatabaseErrors when one process attempts

[web2py] "Loading" animated gif or javascript : how to display

2011-10-12 Thread Vineet
A View calles/requests/redirects to some controller. It takes some time to serve the request. In the meantime, how do I display animated "Loading" image? It will disappear after the request is served. Vineet

[web2py] Re: manual file upload using SQLFORM.factory

2011-10-12 Thread Massimo Di Pierro
The url is validated. .. is not allowed in the URL. On Oct 11, 5:01 pm, Alex wrote: > the files in the uploads folder should be save since they are all > renamed. But what happens if the user passes e.g. '../models/db.py' as > parameter? (the slashes would have to be encoded though, is this > pos

Re: [web2py] Re: db events trigger

2011-10-12 Thread Vinicius Assef
Massimo, you got the point: event dispatched to each affected line. :-) I see it working as conventional RDBMS triggers work as well. Not more, not less. -- Vinicius Assef. On Wed, Oct 12, 2011 at 10:24 AM, Massimo Di Pierro wrote: > So basically  the events are associated to the table and on

Re: [web2py] how to restrict a field to be alphabet only

2011-10-12 Thread Vinicius Assef
But not '*', '%' and so on. hehehe On Wed, Oct 12, 2011 at 10:00 AM, Anthony wrote: > Yeah, that's probably better for names. Names can include hyphens as well. > > On Wednesday, October 12, 2011 8:56:35 AM UTC-4, spyker wrote: >> >> On 12 October 2011 13:33, Anthony wrote: >>> >>> On Wednesday

Re: [web2py] Re: Python 2.7 on GAE (experimental)

2011-10-12 Thread Jonathan Lundell
On Oct 12, 2011, at 6:22 AM, Massimo Di Pierro wrote: > We should move to python27 for gae > > On Oct 11, 10:47 pm, pbreit wrote: >> http://code.google.com/appengine/docs/python/python27/newin27.html Yes, but... > Python 2.7 is now available as an experimental runtime for all applications > u

[web2py] Re: IMPORTANT

2011-10-12 Thread Ross Peoples
I don't know how everyone else feels about this, but I am not easily offended. I'm generally very laid back and take a "to each their own" approach to something I don't agree with. Having said that, I have to deal with extremists on both sides of a wide variety of different topics in regular li

[web2py] Re: manual file upload using SQLFORM.factory

2011-10-12 Thread TheSweetlink
I don't think that's how it works. I get 404 error when trying to manually download a model. I'm not sure how but I believe web2py handles this internally and prevents simple attacks like you're thinking of. It may be worth asking the experts though. On Oct 11, 6:01 pm, Alex wrote: > the files

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread Massimo Di Pierro
I cannot reproduce it. I get: Python 2.7.2 (v2.7.2:8527427914a2, Jun 11 2011, 15:22:34) [GCC 4.2.1 (Apple Inc. build 5666) (dot 3)] on darwin >>> print MARKMIN(content) ... # My slides title ... ## Slide One ... this allows you to create slides using markmin ... ## Slide Two ... - you can use lis

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread jotbe
Still not working: ### HG rev: $ LC_ALL=C; hg summary parent: 2503:0f3a2bc13026 tip fixed problem with missing identity in auth branch: default commit: 2 modified, 1 deleted, 5 unknown update: (current) ### Py-CLI: $ python web2py.py -P -M -S slides web2py Web Framework Created by Massimo Di P

[web2py] IMPORTANT

2011-10-12 Thread Massimo Di Pierro
Hope nobody gets offended by this email and I have no option but bring it up because I have received few emails on the topic. This is a multinational, multicultural community and this is a very good thing. We want to keep it this way. Each of us has different believes. Some people have expressed t

Re: [web2py] Re: Python 2.7 on GAE (experimental)

2011-10-12 Thread Martin Weissenboeck
+1 Martin 2011/10/12 Massimo Di Pierro > We should move to python27 for gae > > On Oct 11, 10:47 pm, pbreit wrote: > > http://code.google.com/appengine/docs/python/python27/newin27.html

[web2py] Re: Help! import winrandom gives dll load failed error under Apache on Vista, but works under Rocket.

2011-10-12 Thread Omi Chiba
David, This kind of explains why pyodbc cannot run on apache under wsgi. The below link solution may also work with you because I assume Uniform server is built with correct compiler. https://groups.google.com/group/web2py/browse_thread/thread/1cc544f52d9aeac4/eb79347e29582367#eb79347e29582367

[web2py] Re: Making slides with web2py and markmin

2011-10-12 Thread Massimo Di Pierro
Can you try the latest markmin (from trunk)? On Oct 12, 2:37 am, jotbe wrote: > Your example code seems to trigger a bug in MARKMIN, when using the > link and the image tag in a list: > > ## snip ## > > >>> content = """... # My slides title... ## Slide One... this allows you to > >>> create sli

[web2py] Re: Internal error

2011-10-12 Thread Massimo Di Pierro
How long is the list of sids? Slite? This is not a web2py error but most likely a driver error. Try commit after every every update. On Oct 12, 5:49 am, Johann Spies wrote: > I am running a script to update data and on some records I get the error: > > *** InternalError: current transaction is ab

[web2py] Re: two SQLFORM.grid in one view?

2011-10-12 Thread Massimo Di Pierro
Please show us the code (the man and two controllers). On Oct 12, 3:09 am, apple wrote: > Have updated issue 454 which was previously closed. > > This works with ajax=True (seems to work with multiple tables too > though I have not fully tested) if you have a separate controller for > each table.

[web2py] Re: db events trigger

2011-10-12 Thread Massimo Di Pierro
So basically the events are associated to the table and only apply to single record event. This reduces the scope and makes things simple. But is this what other people are asking? On Oct 12, 12:18 am, guruyaya wrote: > On Oct 12, 4:18 am, Massimo Di Pierro > wrote: > > > As I said, the problem

[web2py] Re: Python 2.7 on GAE (experimental)

2011-10-12 Thread Massimo Di Pierro
We should move to python27 for gae On Oct 11, 10:47 pm, pbreit wrote: > http://code.google.com/appengine/docs/python/python27/newin27.html

Re: [web2py] Re: web2py hosting

2011-10-12 Thread Bryan Barnard
I just got a beta account with pythonanywhere, and want to test it out. I'm new to web2py. Can you provide any info on how you went about setting it up? On Sat, Oct 8, 2011 at 3:42 AM, GoldenTiger wrote: > I beta tester of a future specific python hosting http:/ > www.pythonanywhere.com > > WE

[web2py] STOOOPID Question

2011-10-12 Thread horridohobbyist
I'm using SQLTABLE in a view and I'm specifying 'orderby' to add sortable column headers, eg, orderby=db.products.name I have the linkable column headers, but when I click on them, NOTHING changes. The order of the rows remain the same. So, what am I missing here? Shouldn't this "just work"? Th

Re: [web2py] how to restrict a field to be alphabet only

2011-10-12 Thread Anthony
Yeah, that's probably better for names. Names can include hyphens as well. On Wednesday, October 12, 2011 8:56:35 AM UTC-4, spyker wrote: > > On 12 October 2011 13:33, Anthony wrote: > >> On Wednesday, October 12, 2011 7:13:53 AM UTC-4, spyker wrote: >>> >>> >>> Field('your_name', require

[web2py] Re: on grid and smartgrid search feature

2011-10-12 Thread stefaan
> I have replaced my all my similar .js and .css files with that of the > welcome app but I see no popup panel. It may be that the old .css is cached in your browser and needs to be reloaded - try to refresh the browser page once. That was the case for me. A new button "query" should appear left

Re: [web2py] how to restrict a field to be alphabet only

2011-10-12 Thread Johann Spies
On 12 October 2011 13:33, Anthony wrote: > On Wednesday, October 12, 2011 7:13:53 AM UTC-4, spyker wrote: >> >> >> Field('your_name', requires=IS_MATCH('\D+') >> > > Note, \D will match any non-digit character, not just letters. > > That is what I said: anything except 0-9. It allows for

[web2py] Re: MongoDB and Web2py

2011-10-12 Thread David Marko
Shouldnt the cache.ram('mongodb', make_mongo_connection, 0) has the None instead of 0? Having 0 it doesnt work as a cache as it refreshes connection on each request ...

Re: [web2py] Re: Help for creating template

2011-10-12 Thread Anthony
By default, @auth.requires_login() should be redirecting to the 'user' action in the 'default' controller, which will then look for the /views/default/user.html view file for rendering. Do you have the standard user.html file? If so, it extends layout.html. If you don't want it to extend layout

Re: [web2py] on grid and smartgrid search feature

2011-10-12 Thread Johann Spies
On 11 October 2011 16:20, Massimo Di Pierro wrote: > The new grid/smartgrid have a much better search feature. A new button > query shows a popup panel that allows you to build the query string. > Can you please check on your existing tables and see if you encounter > any problems? > > You will ne

[web2py] Re: table without id

2011-10-12 Thread Cory Coager
Thanks both. I ended up adding an id field to the tables.

Re: [web2py] Re: SQLFORM.factory does not create the table in db, so how to query results?

2011-10-12 Thread Bruno Rocha
Em 12/10/2011 03:57, "dlypka" escreveu: > > Thanks - your reply helped me see how it works. > I did not realize that web2py just puts the name of *only* the > selected radio button > in request.vars. That is not up to web2py. this is how html forms work in general. when a form is submited *only*

[web2py] Re: MongoDB and Web2py

2011-10-12 Thread Jay
Here is what I use (in a file models/0.py): import pymongo from pymongo import ASCENDING, DESCENDING def make_mongo_connection(): mdb = pymongo.Connection() return mdb mdb = cache.ram('mongodb', make_mongo_connection, 0) # in the code I use mdb as needed. # On a busy site, it may make s

[web2py] Re: MongoDB and Web2py

2011-10-12 Thread David Marko
Both can be in db.py file and so available for entire application = to other db_xx.py files and controlers ... the same thing as standard 'db' sql connection variable defined in db.py by default.

  1   2   >