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

2011-09-06 Thread Johann Spies
On 5 September 2011 20:04, brushek luk...@chrustek.net wrote: Can anybody help ? or grid and smartgrid shouldn't be used with custom fields ? I have tried your model and controller and get the following error when I try to use SQLFORM.smartgrid or -grid: File

[web2py] Re: Published my collection of plugins

2011-09-06 Thread kenji4569
Hi António, I implemented a file chooser for the elrte widget. Please try it: http://dev.s-cubism.com/plugin_elrte_widget Since the file chooser is very primitive, you may need to customize it. But, the customization would be easy with the expressive power of web2py (see the demo code). (Notice:

Re: [web2py] Re: how to avoid shell in the admin

2011-09-06 Thread António Ramos
You are the man... :) 2011/9/6 Anthony abasta...@gmail.com On Monday, September 5, 2011 12:18:28 PM UTC-4, Ramos wrote: hello, i dont like the shell in the admin because in windows i cannot repeat last command also the pythonwin is way more friendly... 1 - in windows how can i do the shame

[web2py] T empty strings

2011-09-06 Thread guruyaya
Hi Massimo For some strange reason the update language mechanism leave out some empty strings. I'm not sure why this bug occurs, my guess is, it's one of the crazy things I'm doing in this project. I was wondering, why an empty string in the translation file, won't return the default string? It

[web2py] Building a non-trivial SOAP service using web2py

2011-09-06 Thread David Mitchell
Hello all, I'm looking at using web2py to build a SOAP service to work as a test harness for an infrastructure upgrade we're planning. Unfortunately, all the web2py SOAP info I've found has been trivial services such as adding 2 numbers together - in my case, I need my SOAP server to be able to

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

2011-09-06 Thread Bruno Rocha
On Tue, Sep 6, 2011 at 4:05 AM, Johann Spies johann.sp...@gmail.com wrote: if field.type in ('string','text')]) TypeError: reduce() of empty sequence with no initial value That is a bug I already reported [0] grid does not works with tables without fields of type 'string' or 'text', also

[web2py] create server.crt and server.key certificates

2011-09-06 Thread Web2Py Freak
anyone can help me with these file , i dont know what to put in them

[web2py] deploying web2py on IIS

2011-09-06 Thread Web2Py Freak
how can i deploy web2py on IIS ??

Re: [web2py] create server.crt and server.key certificates

2011-09-06 Thread António Ramos
i followed this tutorial http://www.xenocafe.com/tutorials/linux/centos/openssl/self_signed_certificates/index.php 2011/9/6 Web2Py Freak halna...@gardeniatelco.com anyone can help me with these file , i dont know what to put in them

[web2py] Css Error

2011-09-06 Thread PaoloPk
Ciao è la prima volta che partecipo ad un gruppo, complimenti per il web2py. Volevo segnalare un errore: quando si crea New application wizard, step1, voce Plugins, non è possibile visualizzare i contenuti, con nessun browser. Basta correggere la classe incriminata con float left

Re: [web2py] Re: how to avoid shell in the admin

2011-09-06 Thread Anthony
Sorry, slight mistake -- it's: python web2py.py -S your_app -N -M (I left off the .py in my original reply.) Also, this assumes you have your own installation of Python and you are running the web2py source code version rather than the Windows binary version. If you are running the Windows

[web2py] Email client in Web2py ?

2011-09-06 Thread António Ramos
Hello, has anyone thought about creating an app in web2py that would be an email client? Thank you António

[web2py] Re: button calling a action

2011-09-06 Thread Fabiano Faver
Thanks Noel and Anthony both have worked! what it was worrying me is that I didn't want to just redirect the user, it will have to run some code and will redirect to specific pages based on user group and data on page. I guess i would put these codes in a page anyway and redirect, but perhaps

[web2py] Re: uploading my web2py website

2011-09-06 Thread Ross Peoples
Shared hosting is the cheapest type of hosting for simple web sites and blogs. In order to get your app to run on a web server, the web server must first have web2py installed. When web2py is installed and running on a server, it acts like an application server (server that runs individual

[web2py] Re: request.args inconsistent behaviour and ignoring URI valid characters

2011-09-06 Thread Massimo Di Pierro
Exactly! This is an importent security feature. On Sep 5, 9:39 pm, pbreit pbreitenb...@gmail.com wrote: It's hard to say exactly what is allowed but according to my reading ofhttp://tools.ietf.org/html/rfc3986* is definitely not allowed and . and .. may not be allowed in the path (since they

[web2py] Re: deploying web2py on IIS

2011-09-06 Thread Massimo Di Pierro
Try this and please report errors. Start web2py as usual on port 8000 python web2py -p 8000 -i 127.0.0.1 -a 'password' Create: C:\inetpub\wwwroot\web2py C:\inetpub\wwwroot\web2py\bin Download http://managedfusion.com/ and extract C:\inetpub\wwwroot\web2py\Web.config Create

[web2py] Re: Css Error

2011-09-06 Thread Massimo Di Pierro
Grazie Paolo. Decisamente utile. On Sep 6, 4:48 am, PaoloPk paolocaval...@gmail.com wrote: Ciao è la prima volta che partecipo ad un gruppo, complimenti per il web2py. Volevo segnalare un errore: quando si crea New application wizard,  step1, voce Plugins, non è possibile visualizzare i

[web2py] Re: Email client in Web2py ?

2011-09-06 Thread Massimo Di Pierro
If you are on linux you can create a ~/.forward file that contains |/home/youraccount/yourprogram.py (quotes required) and all received emails will be passed as stdin to / home/youraccount/yourprogram.py. That program can from gluon import * and you are in business! Massimo On Sep 6, 6:48 

[web2py] Re: deploying web2py on IIS

2011-09-06 Thread Web2Py Freak
where dose my application files go ? or my packed project go

[web2py] Re: deploying web2py on IIS

2011-09-06 Thread Web2Py Freak
Massimo , if you may please , can you explain thing a little more this is my first time doing this . Thank you .

[web2py] Re: Published my collection of plugins

2011-09-06 Thread kenji4569
web2py gives the file in the download directory for example 5e74c950-95b2-4843-b4c6-53bc8efca8fe/plugin_elrte_widget/download/plugin_e lrte_widget_file.file.9a877c8c8c9d285c.4361726f6c696e61323031305f612e646f63 .doc The former random string is a display file name, and just for demo. The

[web2py] Re: Web2py in a pure python data acquisition system

2011-09-06 Thread Willoughby
Very cool! Thanks for sharing...

[web2py] Re: python isn´t in frozen sys.path

2011-09-06 Thread Anthony
If you want to use your own Python installation, then download the web2py source code version instead of the Windows binary version. The Windows binary version includes its own Python interpreter and standard library and won't work with your regular Python installation. Anthony On Tuesday,

[web2py] views

2011-09-06 Thread Web2Py Freak
i wanna ask you guys , dose the html files in views should be working like normal html pages .. and anyone can tell me how to publish my projects ??

[web2py] Re: views

2011-09-06 Thread Anthony
On Tuesday, September 6, 2011 11:05:29 AM UTC-4, Web2Py Freak wrote: i wanna ask you guys , dose the html files in views should be working like normal html pages Not exactly. They are intended to be processed by the web2py framework, which transforms them into standard HTML to be

[web2py] Re: views

2011-09-06 Thread Web2Py Freak
would you take a look at my project and tell me what have i done wrong ??

Re: [web2py] Re: python isn´t in frozen sys.path

2011-09-06 Thread António Ramos
i´n not using my python instalation I´m using web2py binaries for windows the output you saw is from the web2py console,and not the python command line 2011/9/6 Anthony abasta...@gmail.com If you want to use your own Python installation, then download the web2py source code version instead

[web2py] Re: views

2011-09-06 Thread Anthony
Sure. On Tuesday, September 6, 2011 11:22:36 AM UTC-4, Web2Py Freak wrote: would you take a look at my project and tell me what have i done wrong ??

Re: [web2py] Re: python isn´t in frozen sys.path

2011-09-06 Thread Anthony
On Tuesday, September 6, 2011 11:25:47 AM UTC-4, Ramos wrote: i´n not using my python instalation I´m using web2py binaries for windows the output you saw is from the web2py console,and not the python command line But I think pythoncom.py is trying to import something that isn't included

Re: [web2py] Re: Published my collection of plugins

2011-09-06 Thread António Ramos
After i upload a file i get a icon in the text. How do i lauch the file that i just embedded in the text? Thank you 2011/9/6 kenji4569 hos...@s-cubism.jp web2py gives the file in the download directory for example

[web2py] Re: python isn´t in frozen sys.path

2011-09-06 Thread Matt Gorecki
I'm not sure about the error, but in that screenshot you are running version 1.90. Try doing a mercurial pull/update. You should end up with version 1.98.2. Matt On Sep 6, 9:54 am, António Ramos ramstei...@gmail.com wrote: ok, doing that i got another error sorry 2011/9/6 Anthony

[web2py] Re: views

2011-09-06 Thread Web2Py Freak
dear anthony, what happened with you ??

Re: [web2py] Re: python isn´t in frozen sys.path

2011-09-06 Thread António Ramos
Working now! updated to 1.98.2 2011/9/6 Matt Gorecki gorecki.m...@gmail.com I'm not sure about the error, but in that screenshot you are running version 1.90. Try doing a mercurial pull/update. You should end up with version 1.98.2. Matt On Sep 6, 9:54 am, António Ramos

Re: [web2py] Re: Cannot operate on a closed database

2011-09-06 Thread appydev
Why not so with: request = current.request? Is it safe to use the following? # modules/myobjects.py from gluon import * request,session,response,T,cache = current.request,current.session,current.response,current.T,current.cache and then use some class method : if form.accepts(request,

[web2py] Re: views

2011-09-06 Thread Anthony
On Tuesday, September 6, 2011 12:15:41 PM UTC-4, Web2Py Freak wrote: dear anthony, what happened with you ?? What do you mean?

[web2py] Re: python isn´t in frozen sys.path

2011-09-06 Thread Anthony
I think the problem was that back in version 1.90, you had to do auth=Auth(globals(),db) -- with the introduction of the new thread local 'current' object, auth=Auth(db) can be used instead, but trying that with an older version will result in this error. Anthony On Tuesday, September 6,

[web2py] short but useful facebook api info

2011-09-06 Thread Massimo Di Pierro
http://blog.carduner.net/2011/09/06/easy-facebook-scripting-in-python/

[web2py] Re: deploying web2py on IIS

2011-09-06 Thread Massimo Di Pierro
I am not a windows user s I am just reposting somebody else info. I guess web2py goes in C:\inetpub\wwwroot\web2py and you start it from there cd C:\inetpub\wwwroot\web2py c:/python/python.exe web2py -p 8000 -i 127.0.0.1 -a 'password' C:\inetpub\wwwroot\web2py\Web.config is the only file you

[web2py] Re: views

2011-09-06 Thread Massimo Di Pierro
This was a funny exchange! On Sep 6, 11:47 am, Anthony abasta...@gmail.com wrote: On Tuesday, September 6, 2011 12:15:41 PM UTC-4, Web2Py Freak wrote: dear anthony, what happened with you ?? What do you mean?

[web2py] How to connect DB2 with Python pyodbc

2011-09-06 Thread Omi Chiba
I posted the step by step instruction in my blog. http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-pyodbc.html

[web2py] Using a lambda to set a default

2011-09-06 Thread Lennon
I'm try to use a lambda to set a default value based on a value in another table. Here is my model: db.define_table('trip_instance', timestamp, sos_table, Field('trip_type_id', db.trip_type, label='Trip Type', widget=trip_select_widget, requires = IS_IN_DB(db, 'trip_type.id', '% (name)s'),

[web2py] When does web2py close database sessions

2011-09-06 Thread Andrew
Hi, The book describes connection pooling and when new sessions are created, but when are they closed ? If I do not have connection pooling turned on, will the session close after each request ? I am trying to determine if I can make use of dynamically created volatile tables in the database. The

[web2py] windows xp and source web2py

2011-09-06 Thread Christopher Baron
Hi web2py users, I'm running a web2py server on a windows xp machine. Let's call it the kiosk machine. The kiosk machine has a static IP. I am able to ping the kiosk machine from other computers on the network. However, I'm unable to send an http request from a computer on the network to the

[web2py] Re: CAS Auth redirect loop

2011-09-06 Thread Bruno Codeman
Any news about it? On 31 ago, 18:08, Jay jkel...@gmail.com wrote: The only comment I have is that there may be problem in the code at redirect. Raising an exception in redirect does not seem to work. I would look there. My $.02. Jay

[web2py] blog post on web2py + db2

2011-09-06 Thread Massimo Di Pierro
http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-pyodbc.html

[web2py] Re: windows xp and source web2py

2011-09-06 Thread Massimo Di Pierro
How are you starting web2py? You should be using python.exe web2py.py -i 0.0.0.0 -p 80 0.0.0.0 means accessible publicly (if no firewall) and -p 80 sets the port. On Sep 6, 2:15 pm, Christopher Baron cba...@fieldmuseum.org wrote: Hi web2py users, I'm running a web2py server on a windows xp

Re: [web2py] short but useful facebook api info

2011-09-06 Thread Bruno Rocha
On Tue, Sep 6, 2011 at 2:41 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: http://blog.carduner.net/2011/09/06/easy-facebook-scripting-in-python/ Awesome! Thanks for sharing it. I added it classes in facebook.py, now I have a more complete facebok graph API. How easy is to upload

[web2py] Re: windows xp and source web2py

2011-09-06 Thread Christopher Baron
Ah, I see, thanks. This allows remote machines to hit the server, but the request receives a 200. Let's say this machine is on a secure network. If I wanted to hack web2py so that remote machines on the network could access the application, could I simply uncomment line 17 from

[web2py] Date Picker Widget

2011-09-06 Thread David
Wondering if anyone saw any new neat date picker widgets lately? Also; How hard would it be to replace the current date picker with jquery-ui datepicker? Thanks.

[web2py] Re: views

2011-09-06 Thread pbreit
Freak, have you read the web2py book? There's a lot of information about views and how to deploy web2py. It's goin to be difficult to explain those topics here in google groups.

[web2py] Re: button calling a action

2011-09-06 Thread pbreit
That's how regular web2py form handling works.

Re: [web2py] blog post on web2py + db2

2011-09-06 Thread António Ramos
Great i tested the example from the python shell and i connected to my company AS400 with success. FANTASTIC Tomorrow i will kick the ass of the RPG guy. :) 2011/9/6 Massimo Di Pierro massimo.dipie...@gmail.com

Re: [web2py] blog post on web2py + db2

2011-09-06 Thread António Ramos
I tried the DAL Example and i could not connect to my AS400 does the DAL only works with db2 on windows or linux? i have my db2 in a OS400 machine Thank you António Em 6 de setembro de 2011 21:56, António Ramos ramstei...@gmail.comescreveu: Great i tested the example from the python shell

[web2py] Re: Date Picker Widget

2011-09-06 Thread ron_m
I didn't replace the one in web2py, I just use the jQueryUI one by including the necessary CSS and JS files and placing the files in static/js and static/css after downloading a custom build from jQueryUI In the view where it is needed I add these lines before the extend 'layout.html' line

[web2py] Re: Date Picker Widget

2011-09-06 Thread Anthony
Have you seen this: http://dev.s-cubism.com/plugin_anytime_widget? On Tuesday, September 6, 2011 4:40:49 PM UTC-4, David J wrote: Wondering if anyone saw any new neat date picker widgets lately? Also; How hard would it be to replace the current date picker with jquery-ui datepicker?

[web2py] Re: blog post on web2py + db2

2011-09-06 Thread Omi Chiba
No, you can connect to the OS400 machine (Actually, that's where I tested) Check your System: name ,SQL default library: name, user id and password. If your machine can start session with iSeries Access then you can connect. On Sep 6, 4:07 pm, António Ramos ramstei...@gmail.com wrote: I tried

Re: [web2py] Re: Date Picker Widget

2011-09-06 Thread Bruno Rocha
{{response.files.append(URL('static','css/cupertino/jquery-ui-1.8.14.custom.css'))}} {{response.files.append(URL('static','js/jquery-ui-1.8.14.custom.min.js'))}} I included the files above and also changed web2py_ajax.js[0] a bit As you can see in line 37 I kept the default calendar only

Re: [web2py] Re: blog post on web2py + db2

2011-09-06 Thread Jim Steil
Works for me. I'm running from source using trunk from a week or so ago. Did not work for me when running on windows running web2py.exe. Probably has to do with PyODBC not being available unless you have it in the modules directory. Just a thought -Jim On 9/6/2011 4:32 PM, Omi

Re: [web2py] blog post on web2py + db2

2011-09-06 Thread António Ramos
Ok, seems to get someting now. I have to change in AS400 the permissions to allow my username to create a table ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do iSeries Access][DB2 UDB]SQL0551 - Not authorized to object in *N type *USRPRF. (-551) (SQLExecDirectW)') How about

[web2py] Re: short but useful facebook api info

2011-09-06 Thread Massimo Di Pierro
Shall we include it contrib? if no dependencies On Sep 6, 2:59 pm, Bruno Rocha rochacbr...@gmail.com wrote: On Tue, Sep 6, 2011 at 2:41 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: http://blog.carduner.net/2011/09/06/easy-facebook-scripting-in-python/ Awesome! Thanks for sharing

[web2py] Re: button calling a action

2011-09-06 Thread Massimo Di Pierro
you can do {{=A('clickme',callback=URL())}} and the URL is called via ajax. You can also pass a target=... the id of a DIV where to post the result and a delete='tr' which will delete the tr including the link. On Sep 6, 3:51 pm, pbreit pbreitenb...@gmail.com wrote: That's how regular

[web2py] Re: Date Picker Widget

2011-09-06 Thread Niphlod
I use jquery datetimepicker (from http://trentrichardson.com/examples/timepicker/) Seems to work OK, but I use only ISO style data inputs using internationalizations is probably only a matter of time spent on the initialization on timeFormat and dateFormat excerpt from web2py_ajax.js

Re: [web2py] Re: short but useful facebook api info

2011-09-06 Thread Bruno Rocha
There is no dependency, I just put fbconsole.py in my /modules and did something like this: import fbconsole fbconsole.APP_ID = CLIENT_ID # comes from facebook auth, (Michelle's code) fbconsole.SERVER_PORT = 8000 fbconsole.REDIRECT_URI = 'http://localhost:%s/tutor' %

[web2py] contrib module for cache stored in redis

2011-09-06 Thread Niphlod
I think I have a first working draft for using redis as a backend for cache like gluon.contrib.memcache I dind't get completely the internals of cache, though . storing with 'predefined' keys works ok, and also the expire works out of the box. I removed the mutex lock found in other

[web2py] 500 INTERNAL SERVER ERROR

2011-09-06 Thread patrick moon
I'm able to connect to mssql using python and in test mode. but I'm getting the 500 internal server errroris there a way to figure out what the problem is? log looks pretty messy. I'm was trying to get json back from mssql. Was successful under mysql. json format does not seem to be

Re: [web2py] 500 INTERNAL SERVER ERROR

2011-09-06 Thread Ivica Kralj
Yea, Inapplications admin page, on top right you will find error log button in the menu (or link https://127.0.0.1:8000/admin/default/errors/APPNAME) Also It might be useful to use Firebug, (i.i network, script) Cheers good luck On 7 September 2011 01:08, patrick moon pmo...@gmail.com wrote:

[web2py] Re: Published my collection of plugins

2011-09-06 Thread kenji4569
After i upload a file i get a icon in the text. How do i lauch the file that i just embedded in the text? The elrte editor prevents the icon link from clicking to download the file. So you have to first submit the editing html, and save the html in db, and then display the html in the view (as

[web2py] Re: blog post on web2py + db2

2011-09-06 Thread Omi Chiba
How about using auth with as400 users. Is it possible? I'm not sure about it since I'm still new for web2py but your problem should be related to the permission just like your error says. My library is like... Object secured by authorization list . . . . . . . . . . . . *NONE Object User

[web2py] Re: short but useful facebook api info

2011-09-06 Thread Massimo Di Pierro
Please send me a patch. Make sure it includes is own license (MIT, BSD or LGPL). On Sep 6, 6:07 pm, Bruno Rocha rochacbr...@gmail.com wrote: There is no dependency, I just put fbconsole.py in my /modules and did something like this:     import fbconsole     fbconsole.APP_ID = CLIENT_ID #

[web2py] Re: contrib module for cache stored in redis

2011-09-06 Thread Massimo Di Pierro
meta_storage is a dict and a class variable (there is only one for all apps). Given one app meta_storage[app] is the dictionary that stores that cache for that app. You do not need this if you use a third party cache system but make sure the generated keys includes a prefix that avoids conflicts

[web2py] Re: deploying web2py on IIS

2011-09-06 Thread Brian M
Perhaps check out web2pyslices.com -- http://www.web2pyslices.com/slices/take_slice/128 Install web2py on Windows with IIS I haven't tried it (I just use the built-in rocket server or apache + mod_wsgi even on windows) Good Luck ~Brian

[web2py] Bug: Text field length default limit to 512 characters ?

2011-09-06 Thread toan75
Hi. I found in 1.98.2, text field type default length is 512 not 65536? It's correct? Toan.

[web2py] Iterate through form.vars

2011-09-06 Thread Noel Villamor
Code: if form.accepts(request.vars, session): arr = ['a','b','c'] for i in range(3): arr[i] = form.vars.x Desired: In the for loop, I wanted to have arr[0] = form.vars.x0 arr[1] = form.vars.x1 arr[2] = form.vars.x2 As you can see, I am not yet a

[web2py] Re: Bug: Text field length default limit to 512 characters ?

2011-09-06 Thread Noel Villamor
Do an explicit length declaration in your model definition: Field('txt','text', length=65536), Look here: http://www.web2py.com/book/default/chapter/06?search=Field+constructor On Sep 7, 3:10 pm, toan75 toa...@gmail.com wrote: Hi. I found in 1.98.2, text field type default length is