[web2py:30469] IS_IN_DB - Label

2009-09-09 Thread ma...@rockiger.com
Is it possible to give the label in the IS_IN_DB function more than one value? I mean somthing like this: ...requires = IS_IN_DB(db, 'test.id', %s - %s % (db.test.col1, db.test.col2)) I hope you get what I mean. Thanks. Best, Marco --~--~-~--~~~---~--~~ You

[web2py:30470] Re: Cherokee - fastcgi - 404 not found

2009-09-09 Thread Arvind
Hi, I am posting what i figure from the cherokee config file. Somehow, its not working with cherokee. i have spent over a week trying to figure this out. also, can you please tell me , what exactly do you start from the web2py directory after having started the cherokee webserver ? In

[web2py:30471] Re: better support for web2py at WebFaction

2009-09-09 Thread Graham Dumpleton
On Sep 9, 3:59 pm, Richard richar...@gmail.com wrote: There are 2 threads in the WebFaction forum at the moment about getting better support for web2py:http://forum.webfaction.com/viewtopic.php?id=3184http://forum.webfaction.com/viewtopic.php?id=3216 I know quite a few of us use

[web2py:30472] web2py default server load capacity

2009-09-09 Thread Arvind
Hello, This might have been an already asked question. I did not find anything (maybe i am blind), on google search. the default app server that we run as [/var/web2py]# python web2py.py How much load can this handle ? Is it good to run on production servers with high traffic volume, say,

[web2py:30473] Web2py startup script for arch linux

2009-09-09 Thread Arvind
Hello, when i run the startup script for arch linux provided inside the scripts folder. i keep getting this error. web2py.archlinux.sh: line 13: [: -ne: unary operator expected I have copied this script into the main web2py directory and from there i am running it. i am not quite sure how

[web2py:30474] Re: IS_IN_DB - Label

2009-09-09 Thread Fran
On Sep 9, 7:19 am, ma...@rockiger.com rocki...@googlemail.com wrote: Is it possible to give the label in the IS_IN_DB function more than one value? I mean somthing like this: ...requires = IS_IN_DB(db, 'test.id',  %s - %s % (db.test.col1, db.test.col2)) Yes: IS_IN_DB(db,

[web2py:30475] Re: formatting SQLFORMs

2009-09-09 Thread Fran
On Sep 9, 5:59 am, Auden omniva...@yahoo.com wrote: Is there any mechanism for formatting the presentation view of SQLFORMS that are generated from data models? For example if I want to have one field size to be half the size of another one? or if I want to have the size of the field

[web2py:30476] Re: CRUD uses?

2009-09-09 Thread Fran
On Sep 9, 1:37 am, jayvandal jayvan...@gmail.com wrote: I was looking at the article in the Web2py manual concerning CRUD. In Radrails, cakePHP,  etc it is placed in one place and it creates the CRUD  code and forms. I am confused about how Web2py addreses. I looked thru other posts  but I

[web2py:30477] Re: Default application with virtualhost

2009-09-09 Thread Fran
On Sep 8, 9:57 pm, Jose jjac...@gmail.com wrote: In my setup I have the following: VirtualHost 127.0.0.1:43109   ServerName mydomain.com   DocumentRoot /home/myaccount/webapps/apachewsgi/web2py/applications   Directory /myapplication     Order allow,deny     Allow from all   /Directory

[web2py:30478] Re: Form output similar to Google search

2009-09-09 Thread Fran
On Sep 8, 3:00 pm, vvk varunk.ap...@gmail.com wrote: My form has 100 entries. How to output only the first ten entries in one page and make the rest appear as links ? ( like 11-20, 21-30... )         Like in google search, Results are shown as 10 results per page and remaining results are

[web2py:30479] Re: call a controller function...

2009-09-09 Thread Carlos Aboim
hi, I tried the Richard method and worked just fine! Seems more pythonic to me! thanks folks! Carlos Aboim On 9 Set, 00:46, Richard richar...@gmail.com wrote: You need to specify the othercontrolleror it will stay in obras: URL(r=request, c='clientes', f='insert') On Sep 9, 2:10 am, Carlos

[web2py:30480] web2py comparison post at tutor list

2009-09-09 Thread Timmie
FYI: web2py vs django - http://www.nabble.com/web2py-vs-django-td25360012.html --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To

[web2py:30481] Re: better support for web2py at WebFaction

2009-09-09 Thread Richard
yes, but it would be good if they officially supported/recognized web2py like they do Django, Turbogears, etc. On Sep 9, 4:53 pm, Graham Dumpleton graham.dumple...@gmail.com wrote: On Sep 9, 3:59 pm, Richard richar...@gmail.com wrote: There are 2 threads in the WebFaction forum at the

[web2py:30482] error on rendering just a record!

2009-09-09 Thread Carlos Aboim
Hi, I have the next files. I want to retrieve just a record from a list in database. controller --- http://dpaste.com/hold/91386/ view --- http://dpaste.com/hold/91385/ but it gives me the next error: error output --- invalid function by the way, if the retrieved info has a

[web2py:30483] get random record efficiently

2009-09-09 Thread Richard
hi, is there an efficient way to get a random record from a table? An obvious non-efficient way would be to get all the records and do random.choice(). thanks, Richard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[web2py:30484] prevent upload saving to disk

2009-09-09 Thread Richard
I am using SQLFORM.factory to upload some files. By default form.accepts() saves the file to disk. Is there a way to prevent this, like the dbio flag does for the database? I want to examine the file in memory and so don't need to write to disk. thanks, Richard

[web2py:30485] Re: Default application with virtualhost

2009-09-09 Thread Jose
On 9 sep, 08:40, Fran francisb...@googlemail.com wrote: There is no redirection here, just an Allow statement:http://httpd.apache.org/docs/2.2/howto/access.html I don't see how this would work at all - it doesn't seem to be processing Python in any way - no Proxy to CherryPy, no WSGI or

[web2py:30486] Re: Jpolite testing on Web2py

2009-09-09 Thread Frank
hi, mr. freeze, sorry for late response, thanks for your feedback, I will try it. and hope your more insight. Frank On 9月9日, 上午10时16分, mr.freeze nat...@freezable.com wrote: Frank, I think you will need to create your own login form that has class='ajaxform1'. That is howjPoliteknows to

[web2py:30487] Re: two tables, one form

2009-09-09 Thread mdipierro
Iceberg, you are right. @Richard, are you redirecting on not accetps? That would cause the probelm On Sep 8, 11:30 pm, Iceberg iceb...@21cn.com wrote: On Sep9, 10:05am, weheh richard_gor...@verizon.net wrote: I will try to do this but it will take time. Meanwhile, one thing I've noticed

[web2py:30488] Re: strftime why?

2009-09-09 Thread mdipierro
I tried this and it works for me: massimo-di-pierros-macbook:web2py mdipierro$ python web2py.py -S welcome -M (InteractiveConsole) db.define_table('a',Field('b','date')) db.a.insert(b='1776-07-04') 1 I think you may be running an old version of web2py On Sep 9, 12:22 am, jayvandal

[web2py:30489] Re: web2py default server load capacity

2009-09-09 Thread mdipierro
The built-in server is fast, as fast if not faster than apache but it has other limitations: - slow on static files copared to apache - size limit on HTTPS transfers - an unresolved timeout issue with streaming of large files - does not support typical apache configs like virtual hosts, hosts

[web2py:30490] Re: better support for web2py at WebFaction

2009-09-09 Thread mdipierro
yes, they should do. It really takes nothing since already list cherrypy and we have more users. On Sep 9, 5:51 am, Richard richar...@gmail.com wrote: yes, but it would be good if they officially supported/recognized web2py like they do Django, Turbogears, etc. On Sep 9, 4:53 pm, Graham

[web2py:30491] Re: error on rendering just a record!

2009-09-09 Thread mdipierro
The problem is that you return cliente=clientes[0] i.e. a single client, not multimple Rows, but in view you loop over c{{for cliente in cliente:}} as if cliente were Rows and not a single cliente. My advice is: def show(): ''' ver cliente ''' nome = request.vars.nome

[web2py:30492] Re: get random record efficiently

2009-09-09 Thread mdipierro
select(,orderby='random') does not work on GAE but works on all supported relational databases. On Sep 9, 7:07 am, Richard richar...@gmail.com wrote: hi, is there an efficient way to get a random record from a table? An obvious non-efficient way would be to get all the records and do

[web2py:30493] Re: prevent upload saving to disk

2009-09-09 Thread mdipierro
db.mytable.myfield.uploadfield=False and after form.accepts you can access form.vars.myfield.file form.vars.myfield.filename On Sep 9, 7:53 am, Richard richar...@gmail.com wrote: I am using SQLFORM.factory to upload some files. By default form.accepts() saves the file to disk. Is there a

[web2py:30494] Re: Web2py startup script for arch linux

2009-09-09 Thread Jonathan Lundell
On Sep 9, 2009, at 12:00 AM, Arvind wrote: when i run the startup script for arch linux provided inside the scripts folder. i keep getting this error. web2py.archlinux.sh: line 13: [: -ne: unary operator expected I have copied this script into the main web2py directory and from there i am

[web2py:30495] warning: shell locks sqlite

2009-09-09 Thread Massimo Di Pierro
It seems that using the web based shell with sqlite may lock sqlite. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe

[web2py:30496] Re: error on rendering just a record!

2009-09-09 Thread Carlos Aboim
Hey Massimo, thanks for your reply, I've changed the code as you said and now it's ok. But I whould like to edit the record. 1. How do I do to edit that record. 2. How do I change the order of apearence of fields, because the fields seams to be apearing in a random away maybe not... thanks again

[web2py:30497] 'pack all' option leaves out a file

2009-09-09 Thread Don
Has anyone else experienced the following behavior: I am using version 1.66.2 and whenever I pack an application, it seems that APP NAME/views/web2py_ajax.html is not included in the wp2 file. The causes problems when trying to administrator the database. Also, sometimes the wp2 file is bad.

[web2py:30498] Re: Web2py startup script for arch linux

2009-09-09 Thread Jonathan Lundell
I'll be more verbose. Here's what the script appears (to me) to be doing. #!/bin/bash # the script should be run # from WEB2PY root directory prog=`basename $0` This sets $prog to web2py.archlinux.sh cd `pwd` Change directories to the current directory. Huh? chmod +x $prog Make

[web2py:30499] Re: web2py default server load capacity

2009-09-09 Thread Arvind
Hello, - slow on static files copared to apache this i believe is resolved when we configure the webserver to pass on non-static things to web2py. - size limit on HTTPS transfers - an unresolved timeout issue with streaming of large files - does not support typical apache configs like

[web2py:30500] Re: Web2py startup script for arch linux

2009-09-09 Thread Arvind
Hello, So, what do we need to run exactly, maybe, I can work on the script and fix it. do we need to execute web2py.py ? is that all ? thanks Arvind --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users

[web2py:30501] Re: Pycon

2009-09-09 Thread mr.freeze
I would like to see a 'deep dive' into the DAL included complex queries, best practices, limitations, tips and tricks. On Sep 6, 4:05 pm, Massimo Di Pierro mdipie...@cs.depaul.edu wrote: I would like to propose a talk and a tutorial for PyCon 2010. I could use your help. What topic

[web2py:30502] Re: Web2py startup script for arch linux

2009-09-09 Thread Jonathan Lundell
On Sep 9, 2009, at 8:54 AM, Arvind wrote: So, what do we need to run exactly, maybe, I can work on the script and fix it. do we need to execute web2py.py ? is that all ? For the start function, check if web2py.py is running, and don't do anything if it is; otherwise start it. For the

[web2py:30503] SQLite for Production?

2009-09-09 Thread greenpoise
Is it a good alternative? I am a fan of Postgresql myself BUT just for the simplicity of the whole development, can SQLite handle the job in the long run (users, record, db size)? I am sure is almost transparent when using both (correct me if I am wrong) but doesnt the Auth method changes?

[web2py:30504] Re: error on rendering just a record!

2009-09-09 Thread mdipierro
{{=crud.update(db.cliente,cliente)}} On Sep 9, 9:50 am, Carlos Aboim abo...@gmail.com wrote: Hey Massimo, thanks for your reply, I've changed the code as you said and now it's ok. But I whould like to edit the record. 1. How do I do to edit that record. 2. How do I change the order of

[web2py:30505] Re: 'pack all' option leaves out a file

2009-09-09 Thread mdipierro
This is a known bug in python 2.6.1. What python version are you using? On Sep 9, 9:57 am, Don sam...@gmail.com wrote: Has anyone else experienced the following behavior: I am using version 1.66.2 and whenever I pack an application, it seems that APP NAME/views/web2py_ajax.html is not

[web2py:30506] Re: web2py default server load capacity

2009-09-09 Thread mdipierro
On Sep 9, 10:51 am, Arvind arvind.ran...@gmail.com wrote: Hello, - slow on static files copared to apache this i believe is resolved when we configure the webserver to pass on non-static things to web2py. - size limit on HTTPS transfers - an unresolved timeout issue with streaming

[web2py:30507] Re: SQLite for Production?

2009-09-09 Thread mdipierro
If you have new users it is ok. If you have lots of users use postgresql. The worse thing about sqlite is that if the file grows and you run out of memory, the file gets corrupted and you lose data. Massimo On Sep 9, 11:16 am, greenpoise danel.sega...@gmail.com wrote: Is it a good

[web2py:30508] Re: get random record efficiently

2009-09-09 Thread Anand Vaidya
The raw SQL for PostgreSQL: SELECT col FROM tab ORDER BY random() LIMIT 1; I happened to see this on http://wiki.postgresql.org/wiki/FAQ Regards Anand On Sep 9, 8:07 pm, Richard richar...@gmail.com wrote: hi, is there an efficient way to get a random record from a table? An obvious

[web2py:30509] Re: 'pack all' option leaves out a file

2009-09-09 Thread Don
v2.6.2 On Sep 9, 12:31 pm, mdipierro mdipie...@cs.depaul.edu wrote: This is a known bug in python 2.6.1. What python version are you using? On Sep 9, 9:57 am, Don sam...@gmail.com wrote: Has anyone else experienced the following behavior: I am using version 1.66.2 and whenever I pack

[web2py:30510] Re: SQLite for Production?

2009-09-09 Thread Jason Brower
I only use it when it is text in a page... like a wiki that is changed by one or two users. Otherwise, you want soemthing that can be backed up and manipulated live. I hear there are problems iwht SQLight in that respect. On Wed, 2009-09-09 at 09:16 -0700, greenpoise wrote: Is it a good

[web2py:30511] Re: SQLite for Production?

2009-09-09 Thread greenpoise
Thanks for the input. On Sep 9, 1:07 pm, Jason Brower encomp...@gmail.com wrote: I only use it when it is text in a page... like a wiki that is changed by one or two users.  Otherwise, you want soemthing that can be backed up and manipulated live.  I hear there are problems iwht SQLight in

[web2py:30512] Layout problem

2009-09-09 Thread eddwinston
Hi, I am trying to control when and show login form on a page. I have a login form that is displayed on the side of the page is user is not logged in and if the user actually goes the the login page (not the login form by the side of the page). It causes problem because there will be login form

[web2py:30513] Re: CRUD uses?

2009-09-09 Thread Yarko Tymciurak
On Wed, Sep 9, 2009 at 3:36 AM, Fran francisb...@googlemail.com wrote: On Sep 9, 1:37 am, jayvandal jayvan...@gmail.com wrote: I was looking at the article in the Web2py manual concerning CRUD. In Radrails, cakePHP, etc it is placed in one place and it creates the CRUD code and forms. I

[web2py:30514] Re: Default application with virtualhost

2009-09-09 Thread Fred
Jose, your setup appears to be missing the critical WSGI parts of that webfaction configuration example. See all the lines that have WSGI in them. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group.

[web2py:30515] Re: Layout problem

2009-09-09 Thread mdipierro
This is an html issue. look at the generate html. Perhaps there are unmatched tags in 'mini_login.html'? On Sep 9, 12:54 pm, eddwinston eddwins...@gmail.com wrote: Hi, I am trying to control when and show login form on a page. I have a login form that is displayed on the side of the page is

[web2py:30516] Re: CRUD uses?

2009-09-09 Thread mdipierro
I guess the confusion is that in those other cases you create the code and forms, then you place them in your app. The approach requires that if you modify the models, you regenerate the code and forms, etc. The web2py approach is diffrent. You simply but, for example, plase

[web2py:30517] Re: two tables, one form

2009-09-09 Thread weheh
Yes, I was redirecting on non-accepts and yes, I can confirm that that was what was causing the problem. The redirecting actually went to the same page with a different argument, but I have done the same thing by setting a session variable. Anyway, I didn't realize that the redirection on fail

[web2py:30518] Re: 'pack all' option leaves out a file

2009-09-09 Thread mdipierro
Can you try 2.5.1 and see if you can reproduce the problem? I believe it is a 2.6 issue (another reason to recommend 2.5) but perhaps I am wrong. Massimo On Sep 9, 11:56 am, Don sam...@gmail.com wrote: v2.6.2 On Sep 9, 12:31 pm, mdipierro mdipie...@cs.depaul.edu wrote: This is a known bug

[web2py:30519] Re: Cherokee - fastcgi - 404 not found

2009-09-09 Thread Arvind
Hello, I was playing with lighttpd and i found out that , that it basicaly defines a 404 error to redirect to /fcgihandler.fcgi So, in my virtual host inside cherokee, i defined, this error handler, and bingo, web2py started to work perfectly with cherokee. Massimo , this is the page i used as

[web2py:30520] Static Content

2009-09-09 Thread Arvind
Hello, Since, Massimo just told us, that , the static content is not very well served, by the default web2py server, what are the proper directories that we can put into the config of the web server, so that, static content gets served by the webserver and only application calls, go to the

[web2py:30521] Uploading File for Statistical Operations

2009-09-09 Thread Noynoy
Hi, I am a newbie on web application development. I want to create a website using web2py where I will upload a file which contains integer measurements and the web application will perform some statistical operations. I have read the documentation but still feel at a lost as to how to start

[web2py:30522] Re: Uploading File for Statistical Operations

2009-09-09 Thread Yarko Tymciurak
On Wed, Sep 9, 2009 at 2:51 PM, Noynoy lowiew...@gmail.com wrote: Hi, I am a newbie on web application development. I want to create a website using web2py where I will upload a file which contains integer measurements and the web application will perform some statistical operations. I

[web2py:30523] return and redirect

2009-09-09 Thread __Kyo__
Is there any way to include return and redirect at same time, in one function? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To

[web2py:30524] Re: return and redirect

2009-09-09 Thread mdipierro
I do not understand. You can do this: if success: return dict() else: redirect(somewhere) but you cannot do both at the same time. technically redirect raises HTTP(303) while return raises HTTP(200). massimo On Sep 9, 3:03 pm, __Kyo__ iacastil...@gmail.com wrote: Is there any way to

[web2py:30525] Re: Uploading File for Statistical Operations

2009-09-09 Thread Yarko Tymciurak
On Wed, Sep 9, 2009 at 3:01 PM, Yarko Tymciurak yark...@gmail.com wrote: On Wed, Sep 9, 2009 at 2:51 PM, Noynoy lowiew...@gmail.com wrote: Hi, I am a newbie on web application development. I want to create a website using web2py where I will upload a file which contains integer

[web2py:30526] Re: Uploading File for Statistical Operations

2009-09-09 Thread Yarko Tymciurak
On Wed, Sep 9, 2009 at 3:16 PM, Yarko Tymciurak yark...@gmail.com wrote: On Wed, Sep 9, 2009 at 3:01 PM, Yarko Tymciurak yark...@gmail.com wrote: On Wed, Sep 9, 2009 at 2:51 PM, Noynoy lowiew...@gmail.com wrote: . If there are sample codes on how to upload and read csv file using

[web2py:30527] Re: Web2py startup script for arch linux

2009-09-09 Thread Jonathan Lundell
On Sep 9, 2009, at 12:00 AM, Arvind wrote: when i run the startup script for arch linux provided inside the scripts folder. i keep getting this error. web2py.archlinux.sh: line 13: [: -ne: unary operator expected I have copied this script into the main web2py directory and from there i am

[web2py:30528] Re: Web2py startup script for arch linux

2009-09-09 Thread Thadeus Burgess
For a web2py startup script I just copied web2py to /home/thadeusb/Workspace/web2py, and then web2py/applications/init is linked to /home/thadeusb/Workspace/Web/MySite.com On the desktop I created a shell script that contains the following... cd /home/thadeusb/Workspace/web2py python web2py.py

[web2py:30529] Re: return and redirect

2009-09-09 Thread __Kyo__
A form created, is configured to download a pdf (return), but when I resume using the form, it needs to be updated (redirect), maybe there's another way to do this, download and update the form... thanks in advance. On Sep 9, 3:06 pm, mdipierro mdipie...@cs.depaul.edu wrote: I do not

[web2py:30530] Re: return and redirect

2009-09-09 Thread mdipierro
Please explain more. I do not understand. On Sep 9, 3:36 pm, __Kyo__ iacastil...@gmail.com wrote: A form created, is configured to download a pdf (return), but when I resume using the form, it needs to be updated (redirect), maybe there's another way to do this, download and update the

[web2py:30531] Django polls tutorial translated in web2pyese

2009-09-09 Thread mdipierro
http://www.vimeo.com/6504620 FYI. I have posted a news item on reddit about this despite the obvious opposition to web2py there. Massimo --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post

[web2py:30532] Re: return and redirect

2009-09-09 Thread __Kyo__
def reporte(): reportes=['Reporte de un tirador','Reporte de todos los tiradores'] form=FORM(TABLE( TR(Tirador,SELECT(_type=select,_name=usuario, *[OPTION(x.apellidopaterno,' ',x.apellidomaterno,' ',x.nombre,_value=x.id) for x in db().select(db.usuario.ALL, orderby =

[web2py:30533] Re: Django polls tutorial translated in web2pyese

2009-09-09 Thread mdipierro
forget it. The vimeo conversion did not work. On Sep 9, 3:48 pm, mdipierro mdipie...@cs.depaul.edu wrote: http://www.vimeo.com/6504620 FYI. I have posted a news item on reddit about this despite the obvious opposition to web2py there. Massimo

[web2py:30534] Re: return and redirect

2009-09-09 Thread __Kyo__
def reporte(): form=FORM(TABLE( TR(Tirador,SELECT(_type=select,_name=usuario, *[OPTION(x.apellidopaterno,' ',x.apellidomaterno,' ',x.nombre,_value=x.id) for x in db().select(db.usuario.ALL, orderby = db.usuario.apellidopaterno)])), TR(,

[web2py:30535] Re: connecting to existing SQLite database

2009-09-09 Thread Tim Michelsen
Yarko Tymciurak schrieb: which db server are you dealing with? local: file://mydb.sqlite --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to

[web2py:30536] Another Web2py blog entry

2009-09-09 Thread mikech
A First shot at web2py: http://www.jjude.com/2009/03/08/a-first-shot-at-web2py/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To

[web2py:30537] Re: Default application with virtualhost

2009-09-09 Thread Jose
On 9 sep, 18:35, Fred fre...@gmail.com wrote: Jose, your setup appears to be missing the critical WSGI parts of that webfaction configuration example.  See all the lines that have WSGI in them. Fred, This is the complete file: LoadModule setenvif_module modules/mod_setenvif.so LoadModule

[web2py:30538] Re: Another Web2py blog entry

2009-09-09 Thread mdipierro
actually that is old (march) and perhaps should be updated. Massimo On Sep 9, 4:04 pm, mikech mp.ch...@gmail.com wrote: A First shot at web2py:http://www.jjude.com/2009/03/08/a-first-shot-at-web2py/ --~--~-~--~~~---~--~~ You received this message because you are

[web2py:30539] Re: Uploading File for Statistical Operations

2009-09-09 Thread Tim Michelsen
prototype - suggest you start by establishing the basic data you want; You can create the table definitions in the admin interface, and then load them with some test data from csv files in the admin interface. Actually, you don't need to create tables. Because you seem to upload different

[web2py:30540] Re: Uploading File for Statistical Operations

2009-09-09 Thread mdipierro
This does exactly what you want: http://vimeo.com/6401333 the source code is in http://bazaar.launchpad.net/~mdipierro/qcdmc/development/files requires apt-get install python-matplotlib or enthought python on windows. Massimo On Sep 9, 2:51 pm, Noynoy lowiew...@gmail.com wrote: Hi,

[web2py:30541] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch

2009-09-09 Thread DJ
Hi Massimo, Yes, you are correct. I used the TEXT datatype for an application I am building. While it works on MySQL, it throws errors on Oracle. Web2Py by default creates CLOB datatypes on Oracle when you specify TEXT in the model which causes this error. How did you fix this issue with BLOBs?

[web2py:30542] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch

2009-09-09 Thread mdipierro
Try this. In gluon.sql.py (in trunk) after line 400 add if fieldtype == 'text' and dbname == 'oracle': return :CLOB('%s') % obj.replace('\'','\'\'') On Sep 9, 4:31 pm, DJ sebastianjaya...@gmail.com wrote: Hi Massimo, Yes, you are correct. I used the TEXT datatype for an

[web2py:30543] Re: Uploading File for Statistical Operations

2009-09-09 Thread Tim Michelsen
You may find some inspriation her: http://books.google.de/books?id=j7QbD83-h8AClpg=PP1pg=RA2-PA275 Its use of cgi may be outdated. But there are some good ideas for the design. more specifically: http://books.google.de/books?id=j7QbD83-h8AClpg=PP1pg=RA2-PA286

[web2py:30544] Re: T3 rocks!

2009-09-09 Thread DJ
Massimo, This would be an excellent addition to the appliances web2py already has. I was recently trying out GAE and set up a test site using T3. The installation was dead simple and T3 worked really well. With minimal effort I was able to set up - http://fightalzheimers.appspot.com Having a

[web2py:30545] Re: SQLite for Production?

2009-09-09 Thread Stef Mientki
mdipierro wrote: If you have new users it is ok. If you have lots of users use postgresql. The worse thing about sqlite is that if the file grows and you run out of memory, the file gets corrupted and you lose data. Massimo hi Massimo, I was so impolite to quote your statement on the

[web2py:30546] Re: SQLite for Production?

2009-09-09 Thread mdipierro
I apologize and I conclude my statement is not correct. I have experienced this problem once (out of disk space and sqlite database corruption) but I made the mistake of confusing correlation with causality. Except in that occasion I never had any problem with sqlite and I do use it on

[web2py:30547] Re: T3 rocks!

2009-09-09 Thread mdipierro
looks very professional! On Sep 9, 4:57 pm, DJ sebastianjaya...@gmail.com wrote: Massimo, This would be an excellent addition to the appliances web2py already has. I was recently trying out GAE and set up a test site using T3. The installation was dead simple and T3 worked really well. With

[web2py:30548] Re: SQLite for Production?

2009-09-09 Thread Stef Mientki
great to hear that Massimo, I quoted your message back to the sqlite mailing list, so now everybody is happy again (I assume) ;-) cheers, Stef mdipierro wrote: I apologize and I conclude my statement is not correct. I have experienced this problem once (out of disk space and sqlite database

[web2py:30549] who made this? I really like it

2009-09-09 Thread mdipierro
http://www.icoexist.org/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to

[web2py:30550] Re: SQLite for Production?

2009-09-09 Thread Hernan Olivera
I have used sqlite in a Django project, for intensive data-entry and report purposes with 4 users with no problems. my 2 cents 2009/9/9 Stef Mientki stef.mien...@gmail.com great to hear that Massimo, I quoted your message back to the sqlite mailing list, so now everybody is happy again (I

[web2py:30551] Re: Static Content

2009-09-09 Thread Richard
I was also concerned with this so I asked this question recently on the webfaction forum: http://forum.webfaction.com/viewtopic.php?id=3215 I haven't tried out the proposed solutions yet. Richard On Sep 10, 5:15 am, Arvind arvind.ran...@gmail.com wrote: Hello, Since, Massimo just told us,

[web2py:30552] DAL indexes support?

2009-09-09 Thread Richard
According to the manual the DAL does not support indexes because it would make migrations complex. However we are recommended to use migrate=False in production. So could the DAL somehow support indexes under this condition? Such a feature would have saved me some time - I had trouble with

[web2py:30553] isoformat how to use.

2009-09-09 Thread jayvandal
I looked for ideas on how to use the isoformat. I thought it should be in the database, but ?I got into the problem of converting the date data1776-07-04 to the date format where the running of the controller for the db table would not break. Any help would be greatly appreciated! Thanks, jim

[web2py:30554] action based on received email

2009-09-09 Thread Victor
hello everyone just a quick question here. I noticed that the trend nowadays is having a client send an email to a specified address, and having an application on the server do something based on the address that it was sent to. Facebook does this with uploads. I just wanted to know how it is

[web2py:30555] Re: get random record efficiently

2009-09-09 Thread Iceberg
On Sep9, 8:07pm, Richard richar...@gmail.com wrote: hi, is there an efficient way to get a random record from a table? An obvious non-efficient way would be to get all the records and do random.choice(). thanks, Richard Would like to see comments on this. import random total_count

[web2py:30556] Re: Static Content

2009-09-09 Thread mdipierro
all web2py url for static files have the form /$1/static/$2 and they should be mapped into /path/to/web2py/applicaitons/$1/static/$2 Massimo On Sep 9, 2:15 pm, Arvind arvind.ran...@gmail.com wrote: Hello, Since, Massimo just told us, that , the static content is not very well served, by

[web2py:30557] Re: DAL indexes support?

2009-09-09 Thread mdipierro
It does not support indices in the sense that it does not provide an API for indices. You can create indices with db.executesql('CREATE INDEX ...;') db.commit() You can do it from the shell. Massimo On Sep 9, 7:13 pm, Richard richar...@gmail.com wrote: According to the manual the DAL does

[web2py:30558] Re: get random record efficiently

2009-09-09 Thread mdipierro
I thought I answered this random_record = db().select(db.mytable.ALL,orderby='random,limitby= (0,1))[0] On Sep 9, 8:27 pm, Iceberg iceb...@21cn.com wrote: On Sep9, 8:07pm, Richard richar...@gmail.com wrote: hi, is there an efficient way to get a random record from a table? An obvious

[web2py:30559] Re: isoformat how to use.

2009-09-09 Thread mdipierro
I am trying different scenarios but I do not undertand the problem. web2py does not call strftime nor strptime. It only calls isoformat but isoformat can handle dates like 1776-07-04 unless you have a buggy implementation. The only problem I can see is that the js calendar widget cannot handle

[web2py:30560] Django polls tutorial in web2py

2009-09-09 Thread mdipierro
Conversion worked this time: http://vimeo.com/6507384 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group,

[web2py:30561] Re: DAL indexes support?

2009-09-09 Thread Richard
yeah I know I can do it manually - that's what I ended up doing. The reason given in the manual for lack of an API is it would make migrations complex. But this wouldn't be an issue in production where migrate=False. Or is there another reason? Richard On Sep 10, 11:53 am, mdipierro

[web2py:30562] Re: DAL indexes support?

2009-09-09 Thread mdipierro
not all database allow create index if not exists this means web2py would have to keep track of what indices have been created and what no. This would introduce a new level of complexity and, in my view, would not really provide any benefit over creating indices manually. Moreover every new

[web2py:30563] Re: Proxy Error 502

2009-09-09 Thread Richard
I've created a backend process to postprocess the uploaded files separately to the request, and so am no longer receiving this error. Is there a way to configure Apache to allow more time before this timeout error? Richard On Sep 9, 11:38 am, Richard richar...@gmail.com wrote: My exact setup

[web2py:30564] Re: Django polls tutorial in web2py

2009-09-09 Thread weheh
Nice tutorial. The buzzing in the background of the audio sounds like Django is getting all wound up and ready to explode (mainly at the beginning). ;^) On Sep 9, 10:05 pm, mdipierro mdipie...@cs.depaul.edu wrote: Conversion worked this time: http://vimeo.com/6507384

[web2py:30565] Re: DAL indexes support?

2009-09-09 Thread Richard
Oh fair enough. How far along is the new DAL? Richard On Sep 10, 12:19 pm, mdipierro mdipie...@cs.depaul.edu wrote: not all database allow create index if not exists this means web2py would have to keep track of what indices have been created and what no. This would introduce a new level

[web2py:30566] Re: DAL indexes support?

2009-09-09 Thread mdipierro
at some point it was very close but we made changed to the current dal and I am not sure anymore. If I had a week to dedicate exclusvely to this it would be done but I do not. I will try clean it up and post it so I can get help. On Sep 9, 9:40 pm, Richard richar...@gmail.com wrote: Oh fair

[web2py:30567] Re: Layout problem

2009-09-09 Thread eddwinston
Hi Massimo, From the code I wrote, I took off the {{pass}} line and it worked. It is strange because I thought that block was supposed to end in {{pass}} On Sep 9, 9:46 pm, mdipierro mdipie...@cs.depaul.edu wrote: This is an html issue. look at the generate html. Perhaps there are unmatched

[web2py:30568] Re: get random record efficiently

2009-09-09 Thread Richard
but (I think) he wants something working on GAE. On Sep 10, 11:55 am, mdipierro mdipie...@cs.depaul.edu wrote: I thought I answered this random_record = db().select(db.mytable.ALL,orderby='random,limitby= (0,1))[0] On Sep 9, 8:27 pm, Iceberg iceb...@21cn.com wrote: On Sep9, 8:07pm,

  1   2   >