[web2py] How can I store GPS coordinate?

2012-06-14 Thread Jaymin Oh
I'm new at Web2py. I just finished reading the official document by Chapter9.(Access Control) But, I couldn't find any info about how to store GPS coordinate (simply latitude, longitude). Is there any simple way I can take? Thanks in advance.

[web2py] Re: Appadmin in Backbone.js?

2012-06-14 Thread Anthony
Good idea, though I think something like AngularJS might be a better option or maybe Batman.js (two way data binding and template-less views). On Friday, June 15, 2012 12:51:52 AM UTC-4, pbreit wrote: > > I was thinking a neat project for someone lo

[web2py] Re: I am planning to re-develope my windows applications in python

2012-06-14 Thread Cliff Kachinske
I have tried both Django and Web2py. I was able to get productive with Web2py right away, while I struggled with Django. I suggest your experience will be the same. On Thursday, June 14, 2012 9:58:22 AM UTC-4, KarlHeinzF wrote: > > Hallo everybody, > first of all I am new to python and web2py.

[web2py] Re: web2py book now free in PDF

2012-06-14 Thread Cliff Kachinske
You can't beat free. I publicized the free pdf in tonight's PyAtl user group meeting. PyAtl is a Meetup group. On Tuesday, June 12, 2012 9:17:46 AM UTC-4, Massimo Di Pierro wrote: > > The official web2py book is now free for everybody: > > https://dl.dropbox.com/u/18065445/web2py/web2py_manual_4

[web2py] Re: how can I make db like list dictionary types data in web2py

2012-06-14 Thread Anthony
> > db.define_table('person', > Field('name'), > Field('phone'), # ---> [‘000-000-1234’,'001-001-1245', ‘three’, > ‘banana’] > Field('email'), # ---> {‘office’: 'y...@gmail.com', ‘home’:' > n...@yahoo.com'} > ) > For now, you could do something like: db.define_table('person',

[web2py] Web2py talk went okay

2012-06-14 Thread Cliff Kachinske
Thanks to all who provided pointers to information for preparing for the talk, especially Massimo. This evening I presented a talk before PyAtl, the Atlanta Meetup Python User Group. Because of time constraints, (30-40 mins) I was really only able to cover the DAL. Out of the ~32 attendees, I

Re: [web2py] Re: web2py book now free in PDF

2012-06-14 Thread Alec Taylor
Good point. Buying my book now. (in PDF and print!) :D On Fri, Jun 15, 2012 at 6:02 AM, villas wrote: > @blye   You are right about that.  We pay so little for such great > documentation.  I have been very happy to purchase the books,  it is a small > and easy way to acknowledge the enormous va

[web2py] how can I make db like list dictionary types data in web2py

2012-06-14 Thread song
Dear Sir, throught studing, I have some questions but there are no exaples. How can I define the database in db.define_table('person', Field('name'), Field('phone'), # ---> [‘000-000-1234’,'001-001-1245', ‘three’, ‘banana’] Field('email'), # ---> {‘office’: 'y...@gmail.com', ‘ho

[web2py] Appadmin in Backbone.js?

2012-06-14 Thread pbreit
I was thinking a neat project for someone looking for something useful to do would be to develop appadmin in BackboneJS. This prompted my thought: http://quidditchcup.wordpress.com/2011/10/03/flitwick-a-backbone-js-admin-for-rapid-data-entry/

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Amit
My requirement is also to install my web2py application to ubuntu running on amazon cloud , but before that i need to setup the prerequisite(web2py framework, apache, database etc..) to ubuntu, so just going through the script shared by pbreit..meanwhile i am trying to get the amazon cloud (Amazon

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Jason Brower
Yeah, I did the script I mentioned to you earlier on ubuntu running on amazon. Very easy install. Once your have everything setup, installing your app is very easy. Let's see how far you get with the script and then we can go from there. Do you have an application you have already made on your

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread pbreit
Both MySQL and Postgres are fine. Use whichever you or anyone on your team has experience with and/or is comfortable with. The Rocket web server that comes with Web2py is great for development but most or all people use something like Apache or Nginx in production for various reasons, performan

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Amit
Okay, I understood at high level is: Rocket web server is bit slow as it will traverse to all layers so we can go for apache( I can go for apache also, as it seems like it serves our purpose because server has to run 24*7 on ubuntu so the client can access my application over the network, but I am

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Jason Brower
Built into web2py for when you develop locally is a server called Rocket. This helps a lot because you don't have to setup the server to be running all the time. Take a look at the diagram I have given in this email. The webserver is what listens to requests from somewhere on the network/intern

Re: [web2py] how to install web2py and deploy web2py application in ubuntu server?

2012-06-14 Thread Amit
Thanks Jason for providing the useful inputs, I have to use ubuntu machine as a server so will not be used for development purpose, will develop web2py application in other PC and simply deploy that application into ubuntu machine, my application will use MySql database and default web server which

[web2py] Re: Virual Field is not working

2012-06-14 Thread Suresh
The problem is solved. I have to insert state_id with each insert of record, default doesn't work. Thank you for the help. Suresh On Wednesday, June 13, 2012 7:50:40 PM UTC+5:30, Suresh wrote: > > Thank you very much for your reply. > > I am attaching the file db.py. I have kept field name uniq

[web2py] Re: Upload filename - extension maintains original case

2012-06-14 Thread Anthony
Are you saying you want the file stored on the server to end in .jpg, but when the user downloads the file, you want it to revert back to .JPG? In that case, why do you care whether the version on the server is lower or upper case -- nobody sees that version? Anthony On Thursday, June 14, 2012

Re: [web2py] Is web2py the right tool for a report project?

2012-06-14 Thread thinkwell
Yea! response.render is the function that I was looking for. The web2py book says: Almost all of its components are built from scratch and are designed to work together, but they function just as well outside of the complete web2py framework. For example, or the template language can be us

Re: [web2py] What is the simplest/most elegent way to get rid of spaces in XML tags

2012-06-14 Thread Kemaru
Thanks Anthony. Ke On Thursday, June 14, 2012 2:54:55 PM UTC-7, Anthony wrote: > > I just realized that I can use your solution in generic.xml. Thank a lot. >> > > Or in your controller: > > if request.extension == 'xml': > [convert spaces to underscores] > > Anthony >

[web2py] Re: Upload filename - extension maintains original case

2012-06-14 Thread villas
Looks like I can do this in 'onvalidation': request.vars.myfield.filename = request.vars.myfield.filename.lower() But then the original filename would not be restored on download.

[web2py] Upload filename - extension maintains original case

2012-06-14 Thread villas
If I upload a file, it is renamed as follows: .jpg --> new.name.abcdefgh.jpg .JPG --> new.name.xyzdefgh.JPG Note that despite the renaming, the extension maintains its original case. I do not like this because I want all my files to be saved in lowercase. For me it is unexpect

Re: [web2py] server down?

2012-06-14 Thread Massimo Di Pierro
Followed your advice. Let's see what we get. massimo On Thursday, 14 June 2012 16:08:22 UTC-5, mcm wrote: > > I would still lower Threads to 5 and use the WSGIDaemonProcess > directive with only processes. > > WSGIDaemonProcess processes=x > > x depends on how much memory you have. since web2

[web2py] Re: What to expect in web2py 2.0

2012-06-14 Thread Massimo Di Pierro
On Saturday, 19 May 2012 14:34:07 UTC-5, Pystar wrote: > > I am really curious at what features to expect in web2py version 2.0 and > when it would be released? Anyone? Massimo? Here is a partial list: - request.args(0,default=0, cast=int, url_onerror=URL(...)), thanks Anthony - generic.ics -

[web2py] Re: opening a uploaded file in db from controller

2012-06-14 Thread Anthony
GAE works differently. You can't store files on the filesystem, so uploads have to be stored in blob fields in the datastore. For 'upload' fields on GAE, web2py automatically creates an associated blob field and stores the file there. In this case, it would create a blob field called "file_blob"

[web2py] Re: I am planning to re-develope my windows applications in python

2012-06-14 Thread pbreit
That looks more like a web app than a Windows app so you should be OK. You can get a pretty nice look and feel with Twitter Bootstrap which Web2py now uses "out-of-the-box".

Re: [web2py] Re: Why errors for incompetent programmer?

2012-06-14 Thread song
2012년 6월 14일 목요일 오후 9시 4분 43초 UTC+9, Johann Spies 님의 말: > > > > On 14 June 2012 11:14, song wrote: > >> My system is debian and web2py version is last ( manybe >> 1.99.7--web2py_src.zip ) >> >> I'm studying and there are many mistake in my codes studied. >> >> But there are many poor users i

[web2py] Re: opening a uploaded file in db from controller

2012-06-14 Thread Umpei Kurokawa
hmm maybe I'm missing a crucial detail. There doesn't appear to be an "uploads" folder. I am currently using Google App Engine Launcher on my windows computer with nosql to test it out though so I guess the files are stored somewhere else? On Thursday, June 14, 2012 5:58:43 PM UTC-4, Anthony wr

[web2py] Re: opening a uploaded file in db from controller

2012-06-14 Thread Anthony
The field only stores the filename, not the full path, so you need to build the path: import os file = open(os.path.join(request.folder, 'uploads', db.seed_file[id].file), 'wb') Anthony On Thursday, June 14, 2012 5:44:50 PM UTC-4, Umpei Kurokawa wrote: > > So I have a table in the database lik

Re: [web2py] What is the simplest/most elegent way to get rid of spaces in XML tags

2012-06-14 Thread Anthony
> > I just realized that I can use your solution in generic.xml. Thank a lot. > Or in your controller: if request.extension == 'xml': [convert spaces to underscores] Anthony

[web2py] MongoDB Virtual Fields

2012-06-14 Thread stu
I just started using web2py and am using it with mongodb. There have been a few hiccups along the way that seem related to the relative immaturity of the DAL for mongo. I am scratching my head over trying to use virtual fields and am now wondering if this could be related to the same thing. d

Re: [web2py] Advice on building a search form

2012-06-14 Thread Keith Edmunds
On Thu, 14 Jun 2012 13:41:18 -0500, j...@qlf.com said: > Here is a screen shot of what mine looks like. I'm using > SQLFORM.factory to generate my 'search' form. Jim, that looks to be exactly what I'm trying to do. > Again, I'm buried with stuff this week thru Monday. I can help if > Tuesday

[web2py] Re: Auto-generated XML file has spaces in its tags

2012-06-14 Thread Kemaru
Just figured out a solution. I can change the generic.xml file and convert all spaces to underscores before calling the following line: {{=XML(xml(response._vars,quote=False))}} Thanks, Ke On Thursday, June 14, 2012 1:54:43 PM UTC-7, Kemaru wrote: > > I use the default way: .../app/controller/fu

Re: [web2py] What is the simplest/most elegent way to get rid of spaces in XML tags

2012-06-14 Thread Ke MA
Vasile, I just realized that I can use your solution in generic.xml. Thank a lot. Ke On Thu, Jun 14, 2012 at 2:07 PM, Ke MA wrote: > Many thanks, Vasile. > > The dict in my post is returned by my_app/my_controller/my_function and is > used by the view I have developed. Only when people want to

[web2py] opening a uploaded file in db from controller

2012-06-14 Thread Umpei Kurokawa
So I have a table in the database like this. db.define_table('seed_file', Field('title','string'), Field('file','upload'), format='%(title)s') And I want to open the uploaded files from this table from the controller for further manipulation. Using open() function on file, I get an err

Re: [web2py] Re: Having issues with modules import

2012-06-14 Thread codehamster
Just did that, but didn't help either. :) I think I'm going to pack the app and move it onto a VM to see if it behaves any better. On Thursday, 14 June 2012 17:32:42 UTC-4, mcm wrote: > > try removing all *.pyc files and restart > > mic > > 2012/6/14 codehamster > > Yeap. I had that origin

Re: [web2py] Re: Having issues with modules import

2012-06-14 Thread Michele Comitini
try removing all *.pyc files and restart mic 2012/6/14 codehamster : > Yeap.  I had that originally, when it didn't work I tried: > > from gluon import * > > then changed to again back to Storage but forgot to add back the storage. > > However, nothing seems to help. > > > On Thursday, 14 June 20

Re: [web2py] Re: Having issues with modules import

2012-06-14 Thread codehamster
Yeap. I had that originally, when it didn't work I tried: from gluon import * then changed to again back to Storage but forgot to add back the storage. However, nothing seems to help. On Thursday, 14 June 2012 17:21:18 UTC-4, Niphlod wrote: > > uhm. wouldn't "from gluon import Storage" line be

Re: [web2py] server down?

2012-06-14 Thread Michele Comitini
http://code.google.com/p/modwsgi/wiki/ConfigurationDirectives#WSGIDaemonProcess 2012/6/14 Michele Comitini : > I would still lower Threads to 5 and use the WSGIDaemonProcess > directive with only processes. > > WSGIDaemonProcess processes=x > > x depends on how much memory you have.  since web2py

Re: [web2py] Re: Having issues with modules import

2012-06-14 Thread Niphlod
uhm. wouldn't "from gluon import Storage" line be "from gluon.storage import Storage" ? Il giorno giovedì 14 giugno 2012 22:50:57 UTC+2, codehamster ha scritto: > > I have restarted several times web2py already, I also have the following > in one of my models: > > from gluon.custom_import import

[web2py] Re: commit 2799e09d6bb4 broke backward compatibility

2012-06-14 Thread Niphlod
Not trying to be a pain in the ass, but it's actually simple: take welcome, add a function as def test(): response.flash = 'òàùòè+' return dict() then, in default.html, add {{=LOAD('default', 'test', ajax=True)}} and voilà. Using the last firebug you'll also get a complaint about "m

Re: [web2py] server down?

2012-06-14 Thread Michele Comitini
I would still lower Threads to 5 and use the WSGIDaemonProcess directive with only processes. WSGIDaemonProcess processes=x x depends on how much memory you have. since web2py *is* fast you do not need higher than x = 4*n cpus. with processes dal db connection can be with poolsize=1. mic 201

Re: [web2py] What is the simplest/most elegent way to get rid of spaces in XML tags

2012-06-14 Thread Ke MA
Many thanks, Vasile. The dict in my post is returned by my_app/my_controller/my_function and is used by the view I have developed. Only when people want to download them as a XML file, these spaces start to introduce troubles. If I convert these spaces to underscores in my controller, I will need

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-14 Thread Andrew
Hi Paolo, Are you able to send a patch to Massimo for your layout and bootswatch files. The bootstrap menu issue is holdnig up 2.0 and I think your changes have addressed this. Would love to see it in trunk. If you can't I can have a go at working out what you did. Thanks Andrew W On Th

[web2py] Re: Auto-generated XML file has spaces in its tags

2012-06-14 Thread Kemaru
I use the default way: .../app/controller/function.xml/... On Thursday, June 14, 2012 1:46:17 PM UTC-7, Massimo Di Pierro wrote: > > can you show us how you generate this XML? > > On Thursday, 14 June 2012 15:09:04 UTC-5, Kemaru wrote: >> >> Dear all, >> >> If I use the build-in XML render on th

Re: [web2py] What is the simplest/most elegent way to get rid of spaces in XML tags

2012-06-14 Thread Vasile Ermicioi
d2 = {} for k,v in your_dict.iteritems(): d2[k.replace(' ','_')]=v #then convert d2 to xml

Re: [web2py] server down?

2012-06-14 Thread Massimo Di Pierro
I am switching to nginx as soon as I move the server. Anyway for now I disabled apps that are not used (should not be used) and changed the apache conf to Timeout 35 KeepAlive On MaxKeepAliveRequests 15 KeepAliveTimeout 2 StartServers 5

Re: [web2py] What is the simplest/most elegent way to get rid of spaces in XML tags

2012-06-14 Thread Vasile Ermicioi
replace spaces with underscores for all your dict keys, then convert it to xml

Re: [web2py] Re: Having issues with modules import

2012-06-14 Thread codehamster
I have restarted several times web2py already, I also have the following in one of my models: from gluon.custom_import import track_changes; track_changes(True) On Thursday, 14 June 2012 16:47:33 UTC-4, mcm wrote: > > You may have to reload the modules. Maybe restarting web2py helps. > > mic >

[web2py] What is the simplest/most elegent way to get rid of spaces in XML tags

2012-06-14 Thread Kemaru
Dear all, If I use the build-in XML render on the following data: {'San Jose' : 37} I get the following XML file: ... 37 ... I am wondering if I can tell the build-in XML render to replace spaces with underscores? I have searched this group but found no solution. Thanks a lot in advance.

[web2py] Re: Having issues with modules import

2012-06-14 Thread codehamster
Source On Thursday, 14 June 2012 16:44:32 UTC-4, Massimo Di Pierro wrote: > > web2py source or binary? > > On Thursday, 14 June 2012 13:49:11 UTC-5, codehamster wrote: >> >> Hey guys, >> >> Just started with web2py about 2 weeks ago. Running into a bit of an >> issue with modules import. >> >> I

[web2py] test

2012-06-14 Thread Kemaru
This is a test.

[web2py] Re: What to expect in web2py 2.0

2012-06-14 Thread Pystar
seen web2py 2.0 is in trunk. What are the new things/features to look out for? On Saturday, May 19, 2012 8:34:07 PM UTC+1, Pystar wrote: > > I am really curious at what features to expect in web2py version 2.0 and > when it would be released? Anyone? Massimo?

Re: [web2py] Re: Having issues with modules import

2012-06-14 Thread Michele Comitini
You may have to reload the modules. Maybe restarting web2py helps. mic 2012/6/14 Massimo Di Pierro : > web2py source or binary? > > > On Thursday, 14 June 2012 13:49:11 UTC-5, codehamster wrote: >> >> Hey guys, >> >> Just started with web2py about 2 weeks ago.  Running into a bit of an >> issue

[web2py] Re: Auto-generated XML file has spaces in its tags

2012-06-14 Thread Massimo Di Pierro
can you show us how you generate this XML? On Thursday, 14 June 2012 15:09:04 UTC-5, Kemaru wrote: > > Dear all, > > If I use the build-in XML render on the following data: > > {'San Jose' : 37} > > I get the following XML file: > > ... > 37 > ... > > I am wondering if I can tell the build-in XML

Re: [web2py] I am planning to re-develope my windows applications in python

2012-06-14 Thread Michele Comitini
2012/6/14 KarlHeinzF : > Hallo everybody, > first of all I am new to python and web2py. > I am planning to re-develope some of my windows applications in python for > the web. > What is best to use, Web2py or Django or some other framework, that is my > question. If you ask here in this group the

[web2py] Re: Having issues with modules import

2012-06-14 Thread Massimo Di Pierro
web2py source or binary? On Thursday, 14 June 2012 13:49:11 UTC-5, codehamster wrote: > > Hey guys, > > Just started with web2py about 2 weeks ago. Running into a bit of an > issue with modules import. > > I have a module util.py in the modules directory in it, I have something > like: > > from

[web2py] Re: commit 2799e09d6bb4 broke backward compatibility

2012-06-14 Thread Massimo Di Pierro
I have now reverted the patch. I would like to see a concrete example of why the code as currently in trunk breaks with internationalization. I do not think it should. Massimo On Tuesday, 5 June 2012 15:02:07 UTC-5, Niphlod wrote: > > Hi, I'm all for supporting international flash messages, but

[web2py] Re: Are we the biggest site using web2py?

2012-06-14 Thread howesc
yesterday on GAE i did 21 million write ops.i wonder how many inserts that actually was? i'm probably not permitted to talk about the exact number of users and such of the starmaker app (www.starmakerstudios.com) but i can say that the app is well used, and the iOS API and the website talk

[web2py] Re: Memcache

2012-06-14 Thread howesc
on GAE i use it quite a lot.i keep some settings in the DB, and some other content that does not change in the DB very frequently. for those things i query them once from the DB and store objects in memcache for say 1 hour. that cuts my response time significantly. in short, memcache is a

[web2py] Re: web2py book now free in PDF

2012-06-14 Thread Kemaru
Thanks a lot. Ke On Tuesday, June 12, 2012 6:17:46 AM UTC-7, Massimo Di Pierro wrote: > > The official web2py book is now free for everybody: > > https://dl.dropbox.com/u/18065445/web2py/web2py_manual_4th.1.pdf > > Massimo > On Tuesday, June 12, 2012 6:17:46 AM UTC-7, Massimo Di Pierro wrote: >

[web2py] Auto-generated XML file has spaces in its tags

2012-06-14 Thread Kemaru
Dear all, If I use the build-in XML render on the following data: {'San Jose' : 37} I get the following XML file: ... 37 ... I am wondering if I can tell the build-in XML render to replace spaces with underscores? I have searched this group but found no solution. Thanks a lot in advance. So

[web2py] Having issues with modules import

2012-06-14 Thread codehamster
Hey guys, Just started with web2py about 2 weeks ago. Running into a bit of an issue with modules import. I have a module util.py in the modules directory in it, I have something like: from gluon import Storage class User(object): ... >From my controller, I import the module but it won't

Re: [web2py] Re: aloha-editor

2012-06-14 Thread Michele Comitini
2012/6/14 Anthony : > Nice, but AGPL license (or you can pay for commercial license -- no prices > listed). Auch! Not an option. Too bad! mic

[web2py] Re: web2py book now free in PDF

2012-06-14 Thread villas
@blye You are right about that. We pay so little for such great documentation. I have been very happy to purchase the books, it is a small and easy way to acknowledge the enormous value we receive in return. On Wednesday, June 13, 2012 11:06:03 AM UTC+1, blye wrote: > > Thank you! > In r

[web2py] Re: aloha-editor

2012-06-14 Thread Anthony
Nice, but AGPL license (or you can pay for commercial license -- no prices listed). Anthony On Thursday, June 14, 2012 3:46:01 PM UTC-4, mcm wrote: > > Seems a nice HTML5 editor to use in a CMS. > > http://aloha-editor.org > > mic >

[web2py] Re: Web2py 2.0 and SQLFORM

2012-06-14 Thread Massimo Di Pierro
I changed it again so that it correctly default to False for create forms and True for edit forms. On Thursday, 14 June 2012 14:03:33 UTC-5, villas wrote: > > I think you are right; the default behaviour seems to have been changed. > The default will probably have to be reverted back, but for

[web2py] Re: Web2py 2.0 and SQLFORM

2012-06-14 Thread villas
I think you are right; the default behaviour seems to have been changed. The default will probably have to be reverted back, but for now you should be able to do this: if form.process(keepvalues=False).accepted:

[web2py] Re: Advice on building a search form

2012-06-14 Thread villas
Hi Keith, Here are a few comments/suggestions: - Use SQLFORM.factory as you suggested. - If there are only a couple of selection fields, you can change the form so the fields to appear single row to save screen space. (Use formstyle = 'divs' and change the CSS). - Simply place

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread Cliff Kachinske
Paolo, You said, " I cannot move the pictures table declaration because both off them have references to each other (mutual reference?) " Why would the tables have mutual references? What kind of relation would cause that? Here are the kinds of relations I know about. One to many; put the re

Re: [web2py] Advice on building a search form

2012-06-14 Thread Jim Steil
Keith I've got a way to handle this exactly, but am not going to have time until next week to share. If you want, please feel free to bug me about it next week (after Monday) and I can put together what I have and send it off to you so you can see it. Here is a screen shot of what mine look

[web2py] Re: new feature in trunk: better markmin

2012-06-14 Thread villas
Issue 854 Thanks.

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread pbreit
I thought the 'reference mytable' version (vs db.mytable) was supposed to get around this issue? Or is that only for self-referencing: http://web2py.com/books/default/chapter/29/6#Self-Reference-and-aliases

Re: [web2py] Re: Web2py Admin interface

2012-06-14 Thread Kevin Miller
Thanks y'all. On Thu, Jun 14, 2012 at 9:35 AM, Michele Comitini < michele.comit...@gmail.com> wrote: > Or use ssh to make a tunnel: > > ssh -L 18000:localhost:8000 > > then access your web2py as: > http://localhost:18000/admin > > mic > > > 2012/6/14 Anthony : > > Access it over HTTPS. > > > > >

[web2py] Re: Possible bug in SQLFORM for Web2py v2.0

2012-06-14 Thread David Simmons
Hi Massimo it was a create form. I now understand why keepvalues=True as it makes sense for an edit form. The value is inconsistent between SQLFORM and FORM which may catch some people out but not sure how you address the issue. many thanks for your quick reply. I was initially sceptical about

[web2py] Re: Possible bug in SQLFORM for Web2py v2.0

2012-06-14 Thread Massimo Di Pierro
This is the right question. I see from the source there was a change of behavior between stable (keepvalue=False) and trunk (keepvalue=True). Do you have an edit form or an insert form. I this the issue was that the behavior for edit forms was counterintuitive. massimo On Thursday, 14 June 20

[web2py] Re: Possible bug in SQLFORM for Web2py v2.0

2012-06-14 Thread David Simmons
Hi Me again :-) Is this the wrong place to ask this question, if so I apologies and ask that somebody please point me to the right place for this kind of thing. Many thanks Dave On Thursday, June 14, 2012 8:08:10 AM UTC+1, David Simmons wrote: > > Hi > > I downloaded the latest trunk versio

[web2py] Advice on building a search form

2012-06-14 Thread Keith Edmunds
Hi All I'd like some advice on the best approach to building a search form. I don't think crud.search is right, but I'm not sure whether I should approach this using a SQLFORM or SQLFORM.factory or some other way. The model includes an 'activities' table that has a date column. There's also a 'cu

[web2py] Auto Login Redirect Failure

2012-06-14 Thread Sushant Taneja
Hi, I am building an application on AppEngine platform. Whenever a user requests for an invite, the user is sent an email with a link. The user when clicks on the link is presented with a registration page which contains two forms : 1. Custom Registration form 2. Image upload form for a profile

[web2py] Re: using a virtual machine

2012-06-14 Thread Craig Matthews
I downloaded it - thanks. Too bad you can't get web2py to host it as a virtual appliance. It would certainly save people a lot of time. On Thursday, June 14, 2012 10:43:22 AM UTC-4, peter wrote: > > Okay, here you are. It is over 1GB so I will not leave it up too long. > > http://ukjazz.net/bri

[web2py] Re: truncate() not resetting the counter id in one table

2012-06-14 Thread Massimo Di Pierro
This must be a sqlite problem. Web2py has no logic in this regard. On Thursday, 14 June 2012 00:24:22 UTC-5, sesenmaister wrote: > > I'm using SQLDB('sqlite://mydb.db'). > > I was extracting info from a table using regular expressions, and > inserting and updating the info in a new table. I had t

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread Niphlod
No problem at all. PS: sql.log shows what web2py tries to do when creating tables with the status of each command if you want to "trace" this kind of errors in the future, just start from an empty database and use a normal database client to "replay" sql.log, statement after statement.

[web2py] Memcache

2012-06-14 Thread Hassan Alnatour
Dear ALL, I just want to know when yo use Memcache , and what can i benefit from using it

Re: [web2py] Re: how to eliminate the path in a table

2012-06-14 Thread Anthony
> > I have tried that by removing the subfolder but its giving an error > import zipfile > def zipfolder(): > zf = > zipfile.ZipFile('/home/praveen/job_files/seq_data/PCGENE_Format.zip') > fil = > zf.open('/home/praveen/job_files/seq_data/PCGENE_Format.zip/NPKGTS1') > print fil > err

[web2py] Re: using a virtual machine

2012-06-14 Thread peter
Okay, here you are. It is over 1GB so I will not leave it up too long. http://ukjazz.net/british_jazz/static/abc.vdi If you do chkconfig --add uwsgi_nginx chkconfig uwsgi_nginx on you will have both uwsgi and nginx set up as services that will start at boot up. 127.0.0.1 should bring up the

Re: [web2py] Re: how to eliminate the path in a table

2012-06-14 Thread praveen krishna
I have tried that by removing the subfolder but its giving an error import zipfile def zipfolder(): zf = zipfile.ZipFile('/home/praveen/job_files/seq_data/PCGENE_Format.zip') fil = zf.open('/home/praveen/job_files/seq_data/PCGENE_Format.zip/NPKGTS1') print fil error: There is no item na

[web2py] Re: Is web2py the right tool for a report project?

2012-06-14 Thread villas
Just found this which may be of some interest; if not for you, then the group... http://www.geraldoreports.org/docs/tutorial-web2py.html

Re: [web2py] Re: Web2py Admin interface

2012-06-14 Thread Michele Comitini
Or use ssh to make a tunnel: ssh -L 18000:localhost:8000 then access your web2py as: http://localhost:18000/admin mic 2012/6/14 Anthony : > Access it over HTTPS. > > > On Thursday, June 14, 2012 10:12:54 AM UTC-4, dundee wrote: >> >> Hi all, >> >> I just realize that the admin interface in we

[web2py] Re: Web2py Admin interface

2012-06-14 Thread Anthony
Access it over HTTPS. On Thursday, June 14, 2012 10:12:54 AM UTC-4, dundee wrote: > > Hi all, > > I just realize that the admin interface in web2py is disabled in > production mode. I though it would be available so I can securely manage > all my tables (CRUD). > I know there must be way to do

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread Paolo
I am paolo! I've just discovered that on google groups it is written gabriella :-( I will try to fix it, maybe because I am not using a google mail? Anyway, you are right! thanks again for the feedbacks paolo:-) Il 14.06.2012 15:35 Niphlod ha scritto: Gabriella, or Paolo. Maybe it's becau

[web2py] Web2py Admin interface

2012-06-14 Thread Kevin Miller
Hi all, I just realize that the admin interface in web2py is disabled in production mode. I though it would be available so I can securely manage all my tables (CRUD). I know there must be way to do this. Anyone can point me to the right material to properly do this? Thanks.

[web2py] Re: Apply CSS class to form Generated from DAL?

2012-06-14 Thread Anthony
> > Would this also allow "mixing in". Ex: > > form.element('input[name=color]')['_class']='%s %s' % > (form.element('input[name=color]')['_class'], 'myclass') > Or: form.element('input[name=color]')['_class'] += ' myclass' Anthony

Re: [web2py] Re: how to eliminate the path in a table

2012-06-14 Thread Anthony
Are there subfolders in the zipfile? I would think you would want to use the full name (including path) to extract/open the file, not just the filename: for name in zf.namelist(): print zf.open(name) Anthony On Thursday, June 14, 2012 7:37:36 AM UTC-4, praveen krishna wrote: > > Hi, > I

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread Niphlod
Gabriella, or Paolo. Maybe it's because I "was born" speaking of jobs in the SQL department, but have you ever tried "manually" to create two tables and set a mutual relationship within those two without first creating the tables without references? When you create the route table, how can

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread Paolo
Hi Niphlod, again thanks for your suggestion, it worked very well. I removed all the reference fields, I run once and then again with all the reference fields without the former errors. To me is a bit strange that the reference type field doesn't work with an empty db :( Regards, -- Paolo I

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread Niphlod
hehe poor web2py (and maybe db schema) You should let create the two tables without references and then set the references to each other. I think that during the first creation if a foreign key is requested but there is no foreign table the db (rightfully) will prevent you to create such

[web2py] europython in Florence

2012-06-14 Thread Manuele Pesenti
https://ep2012.europython.eu/p3/ep2012/whos-coming is anybody planning to come? Manuele

Re: [web2py] Switching sqlite/postgres

2012-06-14 Thread Paolo
Hi all, Actually I cannot move the pictures table declaration because both off them have references to each other (mutual reference?) In route the field photo_id references pictures and in pictures the field route_id references route. -- Paolo Il 14.06.2012 09:56 Niphlod ha scritto: don't k

Re: [web2py] Asterisk + Web2py projects?

2012-06-14 Thread António Ramos
Here it is http://www.youtube.com/watch?v=vCNoAyKN86o You have to put a script in /var/lib/asterisk/agi-bin my script #!/usr/bin/python import sys import os from xmlrpclib import ServerProxy env = {} tests = 0 while 1: line = sys.stdin.readline().strip() if line == '': break key,data = line.spli

[web2py] Re: How to prevent the default SQLFORM submit when the upload is complete and wait?

2012-06-14 Thread Anthony
When the post request comes in to index, the session file gets locked, which blocks all subsequent requests. The reason the upload progress bar still works is that you hacked into copystream_progress, which is called before the session file is locked. However, once the file has uploaded, the in

Re: [web2py] Asterisk + Web2py projects?

2012-06-14 Thread villas
Yes, it would be very interesting to see a code example -- thanks! On Thursday, June 14, 2012 12:49:16 PM UTC+1, mweissen wrote: > > I am working with Asterisk and it would be very interesting for me to see > a connection with web2by. > Am 14.06.2012 13:46 schrieb "António Ramos" : > >> Hello

  1   2   >