[web2py] IS_NOT_IN_DB on three fields

2012-08-07 Thread Annet
I have the following validator: IS_NOT_IN_DB(db(db.PromoUnit.sequenceNumber==request.vars.sequenceNumber),db.PromoUnit.promoPositionID,error_message='combination promo position sequence number already in database') The table PromoUnit also has a field nodeID which I would like to include in

[web2py] Re: issue with mysql (or pymysql only?)

2012-08-07 Thread Marin Pranjić
Default isolation level for mysql is 'Repeatable Read'. It does not see commits from other transactions. You can use db.commit to update table snapshot or you can change isolation level with db.executesql at the beginning of transaction. 'Read Committed' level is what you need. Postgres MSSQL

Re: [web2py] web2py 2.0 almost done

2012-08-07 Thread Johann Spies
On 7 August 2012 06:33, Massimo Di Pierro massimo.dipie...@gmail.comwrote: Web2py 2.0 is almost done. Please try the nightly build. Let us know if it breaks anything. Not serious problem but the import/export form in welcome/appadmin does not look good. The buttons overlap. See the

[web2py] soap service Operation xml not found in WSDL

2012-08-07 Thread k0aun9
Hi, I've been using it web2py for quite a while now and now moving it to the next level. I'm trying to setup a soap service (both client and server) and having some problem. Actually, I'm following a tutorial here http://code.google.com/p/pysimplesoap/wiki/Web2Py When I try to create a

[web2py] Re: presenting a manytomany relation for insert

2012-08-07 Thread goabbear
The labels for the checkboxes are the names of the mailinglists, that's ok, but not for the destinataire which the email field is replaced by the destinataire id. This is just a simple form where one user can subscribe to multiple mailinglists giving his email. In the same way, I want to limit

[web2py] Re: issue with mysql (or pymysql only?)

2012-08-07 Thread Niphlod
I see. The DBAPI spec is created to smooth the differences between different implementation: that's why , for example, if a driver is defaulting to autocommit (like pyodbc), the underlying DBAPI forces off the autocommit. I'm really not well-versed into following the PEP but I think behaviour

[web2py] Re: type 'exceptions.SyntaxError' invalid select attribute: distinct

2012-08-07 Thread Elton Pereira de Lima
Same error. One detail I forgot to mention, this only happens when I use mongodb. Follows the traceback: Traceback (most recent call last): File /home/eltonplima/workspace/web2py/2.0/web2py/gluon/restricted.py, line 205, in restricted exec ccode in environment File

[web2py] Re: web2py 2.0 almost done

2012-08-07 Thread apps in tables
Hi, I suggest adding (intentionally) few bugs. Once they are discovered, most probably others are discovered. Ashraf --

Re: [web2py] web2py 2.0 almost done

2012-08-07 Thread vinicius...@gmail.com
Is there a changelog? On 08/07/2012 01:33 AM, Massimo Di Pierro wrote: Web2py 2.0 is almost done. Please try the nightly build. Let us know if it breaks anything. massimo -- --

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Aurelijus Useckas
I've tried nearly any possible syntax, but with no success. Any line with the reference to other table causes an error 1005 / 150: table creation failed because a foreign key constraint was not correctly formed Wasted a lot of time on it with no avail, guess will be forced to go back to ol'

Re: [web2py] web2py 2.0 almost done

2012-08-07 Thread Alexei Vinidiktov
I can't run web2py from Google App Engine *locally* (either via Application Launcher or via command line with dev_appserver.py). Tested on Windows and Ubuntu Linux. I've filed a bug request: http://code.google.com/p/web2py/issues/detail?id=921 On Tue, Aug 7, 2012 at 11:33 AM, Massimo Di Pierro

[web2py] MySQL Error

2012-08-07 Thread Hassan Alnatour
Dear ALL , I am trying to connect to mysql database and i keep getting this error : *class 'gluon.contrib.pymysql.err.ProgrammingError' (1064, uYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Like INT,\n

Re: [web2py] MySQL Error

2012-08-07 Thread Marin Pranjić
'Like' is an sql keyword. On Tue, Aug 7, 2012 at 1:13 PM, Hassan Alnatour halna...@gardeniatelco.comwrote: Dear ALL , I am trying to connect to mysql database and i keep getting this error : *class 'gluon.contrib.pymysql.err.ProgrammingError' (1064, uYou have an error in your SQL syntax;

Re: [web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Johann Spies
On 7 August 2012 06:48, lyn2py lyn...@gmail.com wrote: Question on the autocomplete widget: Previous post / discussions indicate that this widget doesn't work for IE, may I know if it has been fixed? Or what seems to be preventing IE from rendering it properly? The autocomplete widget does

Re: [web2py] MySQL Error

2012-08-07 Thread Marin Pranjić
Hi, order is sql keyword too. This might be helpful to you: http://web2py.com/books/default/chapter/29/6?search=check#Reserved-keywords Regards, Marin On Tue, Aug 7, 2012 at 3:05 PM, Hassan Alnatour halna...@gardeniatelco.comwrote: Dear Marin, I change Like To Likes but i still get errors

[web2py] smartgrid divided in columns

2012-08-07 Thread Martin Weissenboeck
Hi, I have a table with a lot of checkboxes and only very short textstrings, like this: This table is created with my own function, but I would prefer to create it with smartgrid. Is there any way to do this? Regards, Martin --

Re: [web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Anthony
Maybe we should consider adopting jQuery UI autocomplete for the client-side code. Anthony On Tuesday, August 7, 2012 8:56:57 AM UTC-4, Johann Spies wrote: On 7 August 2012 06:48, lyn2py lyn...@gmail.com wrote: Question on the autocomplete widget: Previous post / discussions indicate that

[web2py] Re: smartgrid divided in columns

2012-08-07 Thread Martin Weissenboeck
Additional question: is it possible to use radio buttons instead of checkboxes in a smart grid? 2012/8/7 Martin Weissenboeck mweis...@gmail.com Hi, I have a table with a lot of checkboxes and only very short textstrings, like this: This table is created with my own function, but I would

[web2py] Re: IS_NOT_IN_DB on three fields

2012-08-07 Thread Anthony
Looks like it should work. What do you mean it doesn't work? What are you expecting, and what is happening instead? Anthony On Tuesday, August 7, 2012 3:13:36 AM UTC-4, Annet wrote: I have the following validator:

Re: [web2py] Re: Appengine CPU cycles

2012-08-07 Thread Alexei Vinidiktov
The app I'm developing is highly dependent on auth. Does it mean that any request that uses auth won't be faster than 200ms on GAE? On Tue, Aug 7, 2012 at 7:30 AM, howesc how...@umich.edu wrote: are you using auth? auth takes around 200ms to load i think on GAE. i avoid initializing auth

[web2py] Re: smartgrid divided in columns

2012-08-07 Thread Martin Weissenboeck
Sorry - it seems that the picture of my table has been lost. I try with with an attached file. 2012/8/7 Martin Weissenboeck mweis...@gmail.com Additional question: is it possible to use radio buttons instead of checkboxes in a smart grid? 2012/8/7 Martin Weissenboeck mweis...@gmail.com

Re: [web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Alec Taylor
Nah, I'm pretty sure jQuery UI is a little too heavy for our needs. Maybe just the bootstrap autocomplete plugin? On Tue, Aug 7, 2012 at 11:40 PM, Anthony abasta...@gmail.com wrote: Maybe we should consider adopting jQuery UI autocomplete for the client-side code. Anthony On Tuesday,

[web2py] How to use formkey with forms defined in the view?

2012-08-07 Thread Yarin
Sometimes I need to define my forms in the view, but still want to use as much of web2py's form functionality as possible. In those cases I generally define the form in the controller as well, with corresponding fields, and then build a form in the view with the same formname. This works,

Re: [web2py] URL strategy for single application

2012-08-07 Thread Daniel Gonzalez
Thanks Jonathan, Bruno, I am a bit confused: where is this routes.py file? Is it a web2py-wide file, or an application-specific file? Thanks, Daniel On Thursday, August 2, 2012 9:47:24 PM UTC+2, Jonathan Lundell wrote: On 2 Aug 2012, at 12:34 PM, Bruno Rocha rochacbr...@gmail.com wrote:

Re: [web2py] URL strategy for single application

2012-08-07 Thread Jonathan Lundell
On 7 Aug 2012, at 7:17 AM, Daniel Gonzalez gonva...@gmail.com wrote: Thanks Jonathan, Bruno, I am a bit confused: where is this routes.py file? Is it a web2py-wide file, or an application-specific file? It goes in the web2py root directory. There's a pair of example files for the two

[web2py] Re: type 'exceptions.SyntaxError' invalid select attribute: distinct

2012-08-07 Thread Massimo Di Pierro
This helps. I think I just fixed it in trunk. Can you check and confirm if it is fixed? On Tuesday, 7 August 2012 04:35:33 UTC-5, Elton Pereira de Lima wrote: Same error. One detail I forgot to mention, this only happens when I use mongodb. Follows the traceback: Traceback (most recent

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Massimo Di Pierro
Can you please post the entire mode? My guess is an issue with capitalization perhaps combined with corruption of table files. On Tuesday, 7 August 2012 06:00:06 UTC-5, Aurelijus Useckas wrote: I've tried nearly any possible syntax, but with no success. Any line with the reference to other

Re: [web2py] web2py 2.0 almost done

2012-08-07 Thread Massimo Di Pierro
which browser? On Tuesday, 7 August 2012 02:49:42 UTC-5, Johann Spies wrote: On 7 August 2012 06:33, Massimo Di Pierro massimo.dipie...@gmail.comwrote: Web2py 2.0 is almost done. Please try the nightly build. Let us know if it breaks anything. Not serious problem but the import/export

Re: [web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Massimo Di Pierro
Looks like the css is missing... On Tuesday, 7 August 2012 07:56:57 UTC-5, Johann Spies wrote: On 7 August 2012 06:48, lyn2py lyn...@gmail.com wrote: Question on the autocomplete widget: Previous post / discussions indicate that this widget doesn't work for IE, may I know if it has been

[web2py] free search API | Zero-click Info API duckduckgo.com

2012-08-07 Thread Michele Comitini
A free search API. I like this duckduckgo engine. api.duckduckgo.com https://github.com/crazedpsyc/python-duckduckgo/ mic --

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Aurelijus Useckas
Here it is: db.define_table('tag', Field('tag', notnull=True, unique=True), format='%(tag)s') db.define_table('city', Field('name', notnull=True, unique=True), format='%(name)s') db.define_table('maps', Field('name'), Field('last_name'), Field('long'),

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Yarin
Change the name of in your Field('long') field in maps table - it's a reserved keyword in MySQL and will cause it to hang. On Tuesday, August 7, 2012 10:57:07 AM UTC-4, Aurelijus Useckas wrote: Here it is: db.define_table('tag', Field('tag', notnull=True, unique=True),

[web2py] Re: register form and service conditions acceptance

2012-08-07 Thread Marco Prosperi
Maybe show what you tried. I would think you could make either the field label or comment (the comment appears after the input field) a link, and trigger the modal dialog with an onclick attribute or a jQuery event handler. Anthony ok, in models/db.py I have put (but the link in

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Dirk Krause
I finally understand why the app wizard prefixes every table with 't_' and every field with 'f_'. Probably a good practice anyway. Am Dienstag, 7. August 2012 17:03:44 UTC+2 schrieb Yarin: Change the name of in your Field('long') field in maps table - it's a reserved keyword in MySQL and

Re: [web2py] Re: plugin_wiki meta-menu

2012-08-07 Thread villas
Yes, that is an even better idea - it is more flexible. Thanks, On Monday, August 6, 2012 12:48:21 PM UTC+1, mweissen wrote: Thank you - nice solution. I have changed it to: elif url.startswith('url:'): url=URL(*(url[4:].split('/'))) Usage: url:application/controller/function All

[web2py] Mistake in the web2py book

2012-08-07 Thread Remco K
Hi, I found a little mistake in the Web2Py-book but i dont know if this is the right place to report these things. Anyway: I was reading about using the scheduler when i saw this: completed_runs = db(db.scheduler_run.status='COMPLETED').select() Which gives the error: SyntaxError: keyword

[web2py] Re: GAE - SQL cloud connection

2012-08-07 Thread Alexei Vinidiktov
The problem still exists in the latest nightly build. Without this modification (changing the field length to 128) launching web2py on the remote GAE server gives me the error: DatabaseError: 1071: Specified key was too long; max key length is 767 bytes The whole traceback is as follows:

Re: [web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Massimo Di Pierro
Has anybody worked out a good CSS for this? I do not think web2py ever shipped with css for the autocomplete widget. On Tuesday, 7 August 2012 07:56:57 UTC-5, Johann Spies wrote: On 7 August 2012 06:48, lyn2py lyn...@gmail.com wrote: Question on the autocomplete widget: Previous post /

[web2py] Re: GAE - SQL cloud connection

2012-08-07 Thread Massimo Di Pierro
Why does 512 result in Specified key was too long; max key length is 767 bytes. Is one counting unicode and one bytes? If setting this length to 128 is the only option, I will change it but I am afraid it may be too short to store .table files. Did you encounter any problem after this change?

[web2py] Re: free search API | Zero-click Info API duckduckgo.com

2012-08-07 Thread Massimo Di Pierro
This is really nice. It is a single file and has simple APIs. Should we include it in contrib? On Tuesday, 7 August 2012 09:46:53 UTC-5, Michele Comitini wrote: A free search API. I like this duckduckgo engine. api.duckduckgo.com https://github.com/crazedpsyc/python-duckduckgo/ mic

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Massimo Di Pierro
Damn MySQL. It should not hang, it should return a operationalerror. On Tuesday, 7 August 2012 10:03:44 UTC-5, Yarin wrote: Change the name of in your Field('long') field in maps table - it's a reserved keyword in MySQL and will cause it to hang. On Tuesday, August 7, 2012 10:57:07 AM

Re: [web2py] Re: free search API | Zero-click Info API duckduckgo.com

2012-08-07 Thread Alec Taylor
On Wed, Aug 8, 2012 at 1:28 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: This is really nice. It is a single file and has simple APIs. Should we include it in contrib? It gets my vote! - Also, it would be good to get something similar to http://haystacksearch.org/ from Django at some

[web2py] Re: How to use formkey with forms defined in the view?

2012-08-07 Thread Anthony
After calling form.accepts (or form.process), the generated formkey is stored in form.formkey. You can also use form.hidden_fields() to generate the _formname and _formkey hidden fields instead of creating them manually. def index(): return

[web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Dirk Krause
Sry if this is a dumb question: am I supposed to post possible bugs here or file an issue on google code? Am Dienstag, 7. August 2012 06:33:48 UTC+2 schrieb Massimo Di Pierro: Web2py 2.0 is almost done. Please try the nightly build. Let us know if it breaks anything. massimo --

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Yarin
Think it actually does return a non-specific SQL syntax error that gets ticketed by web2py- but web2py never goes to an error screen and the browser just hangs- if i recall.. On Tuesday, August 7, 2012 11:30:37 AM UTC-4, Massimo Di Pierro wrote: Damn MySQL. It should not hang, it should

Re: [web2py] Re: Appengine CPU cycles

2012-08-07 Thread Christian Foster Howes
when i last tested it it was with a very complex custom auth + validators. there are probably ways to trim it down. one thing that i did was only init mail and attach mail to auth if i was doing something that required mail. cfh On 8/7/12 6:45 , Alexei Vinidiktov wrote: The app I'm

[web2py] Re: type 'exceptions.SyntaxError' invalid select attribute: distinct

2012-08-07 Thread Elton Pereira de Lima
After upgrading(git pull), I got a new error. NameError: global name 'ObjectId' is not defined Traceback (most recent call last): File /home/eltonplima/workspace/web2py/gluon/restricted.py, line 205, in restricted exec ccode in environment File

[web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Luc Chase
Where is the Ver. 2.0 system? Is it at https://github.com/web2py/web2py/ ? On Tuesday, 7 August 2012 05:33:48 UTC+1, Massimo Di Pierro wrote: Web2py 2.0 is almost done. Please try the nightly build. Let us know if it breaks anything. massimo --

[web2py] Re: How to use formkey with forms defined in the view?

2012-08-07 Thread Yarin
Anthony- thanks, but this isn't working for me and now I'm more confused. Why do I need to call .process() on the form again- isn't it already being processed when i do `form.accepts(...)`? Here is my updated code- it is still double posting: * Controller:* def index(): form =

Re: [web2py] Re: free search API | Zero-click Info API duckduckgo.com

2012-08-07 Thread Michele Comitini
Massimo has already integrated whoosh to some extent. Having a uniform search API layer in web2py is interesting, a matter of discussion could be if the DAL interface could be extended to do the task. mic 2012/8/7 Alec Taylor alec.tayl...@gmail.com: On Wed, Aug 8, 2012 at 1:28 AM, Massimo Di

[web2py] Re: boolean type in MySQL: CHAR(1) vs TINYINT(1)

2012-08-07 Thread Osman Masood
However, web2py maintains the promise of backwards compatibility. One way is to have a 'tinyint_boolean' datatype for those who want to use tinyints as booleans. But that looks kind of messy and inelegant. An alternative is this: We could add a migration script to /scripts to convert all

[web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Dirk Krause
If you want the trunk (i.e. the latest version) I assume it's best that you do a git clone https://github.com/web2py/web2py/ and work from there. Every once and a while you will want to do a git pull to receive the latest version. Am Dienstag, 7. August 2012 18:03:24 UTC+2 schrieb Luc Chase:

Re: [web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Annet
Maybe just the bootstrap autocomplete plugin? I am using the Bootstrap autocomplete (typeahead) plugin, as far as I know it styles well in IE. Annet --

[web2py] Upload error field *_newfilename does not belong to the table

2012-08-07 Thread Paolo
Hi all, I've just checked out the last trunk, I got the following error: 2012-08-07 19:26:01,063 - web2py - ERROR - Traceback (most recent call last): File /home/paolo/Desktop/git/web2py/gluon/restricted.py, line 205, in restricted exec ccode in environment File

[web2py] Re: IS_NOT_IN_DB on three fields

2012-08-07 Thread Annet
Hi Anthony, Looks like it should work. What do you mean it doesn't work? What are you expecting, and what is happening instead? In case I enter the following records: nodeID promoPositionID sequenceNumber 2831 1 2831

[web2py] Re: How to use formkey with forms defined in the view?

2012-08-07 Thread Yarin
OK- figured this out, mostly. Anthony's answer worked, but only after I added session to the .accepts(...) args // and or used form.process(...).accepted instead. Working code below: *Controller:* * * def index(): form = FORM(INPUT(_name='name')) if form.accepts(request.vars,

[web2py] variables to determine table columns from database

2012-08-07 Thread Larry Wapnitsky
from a web page, i'm able to successfully query my database using the following: rows = db(db[request.args(0)].id == request.args(1)).select( What I'm having trouble with is passing another argument that specifies another column other than id. I've tried the following with no success:

[web2py] Re: How to use formkey with forms defined in the view?

2012-08-07 Thread Anthony
OK- figured this out, mostly. Anthony's answer worked, but only after I added session to the .accepts(...) args // and or used form.process(...).accepted instead. Yes, the formkey is stored in the session, so you have to pass the session to form.accepts() for the formkey to be created.

[web2py] Re: variables to determine table columns from database

2012-08-07 Thread Anthony
rows = db(db[request.args(0)][request.args(2)] == request.args(1)).select ( Anthony On Tuesday, August 7, 2012 2:15:09 PM UTC-4, Larry Wapnitsky wrote: from a web page, i'm able to successfully query my database using the following: rows = db(db[request.args(0)].id ==

[web2py] Re: Mistake in the web2py book

2012-08-07 Thread Niphlod
yeah, scheduler docs are anyway going to be replaced as soon as web2py 2.0 is out: scheduler was heavily changed since 1.99.7 and a lot a functionality was added. On Tuesday, August 7, 2012 5:10:12 PM UTC+2, Remco K wrote: Hi, I found a little mistake in the Web2Py-book but i dont know if

[web2py] Re: IS_NOT_IN_DB on three fields

2012-08-07 Thread Anthony
Did you move that validator from the promoPositionID field to the nodeID field? The second version of the validator is checking for unique values in the nodeID field, not the promoPositionID field, so the validator belongs on the nodeID field. If you want it on the promoPositionID field, then

[web2py] Re: variables to determine table columns from database

2012-08-07 Thread Larry Wapnitsky
damned periods! :) Thanks, Anthony On Tuesday, August 7, 2012 2:49:53 PM UTC-4, Anthony wrote: rows = db(db[request.args(0)][request.args(2)] == request.args(1)).select ( Anthony On Tuesday, August 7, 2012 2:15:09 PM UTC-4, Larry Wapnitsky wrote: from a web page, i'm able to

Re: [web2py] Re: web2py 2.0 almost done

2012-08-07 Thread Anthony
Nah, I'm pretty sure jQuery UI is a little too heavy for our needs. The required autocomplete code is 20KB minified (before gzipping), so not that bad, and it has a lot of functionality. Maybe just the bootstrap autocomplete plugin? Something like this may be OK too, though not quite

Re: [web2py] Re: Appengine CPU cycles

2012-08-07 Thread Anthony
The app I'm developing is highly dependent on auth. Does it mean that any request that uses auth won't be faster than 200ms on GAE? Note, if you're just checking for login, I don't think you need to call auth.define_tables() (that should only be needed for registration, login, and

Re: [web2py] Re: Appengine CPU cycles

2012-08-07 Thread Felipe Meirelles
Well, I'm still in the middle of tests but all points to a huge drop on cpu usage using a model less aproch. I've made, in a few days ill post numbers, but the cpu_ms is arround half of it was. I've set all db.define_table() in separete models, and just include them where i use them. Also, all

[web2py] Re: How to use formkey with forms defined in the view?

2012-08-07 Thread Yarin
Anthony- you're right on both counts- sloppy copy and pasting on my part- edited my previous post, everything works. Thanks!- On Tuesday, August 7, 2012 2:47:57 PM UTC-4, Anthony wrote: OK- figured this out, mostly. Anthony's answer worked, but only after I added session to the .accepts(...)

[web2py] Small bug?

2012-08-07 Thread lyn2py
Spotted a small bug in response.flash: Normally when we submit a form, response.flash will appear form accepted However if it is a form submitted within dialog box, response.flash will appear form%20accepted --

[web2py] Simple ? How to remove Form Name (form :) from FORM Helper

2012-08-07 Thread Rob_McC
I'm sure it is easy, but I couldn't figure it out. *Q:* *How do you remove the* *form :* *from the table generated with FORM() helper.* * * See red box on screen shot. *Reason*: I'm building a tutorial on how to do a simple Email form in web2py. Thanks! ~Rob def contactus():

[web2py] Re: Simple ? How to remove Form Name (form :) from FORM Helper

2012-08-07 Thread Anthony
I assume that's not the complete code, as your function doesn't return anything. Does it end with something like: return dict(form=form, ...) And are you using a generic view (i.e., have you defined a contactus.html view)? If you use a generic view and pass a dictionary with more than one

[web2py] Re: Small bug?

2012-08-07 Thread Anthony
Are you using trunk (if not, can you try it -- including the trunk version of web2py.js)? Can you show your code? Anthony On Tuesday, August 7, 2012 4:21:16 PM UTC-4, lyn2py wrote: Spotted a small bug in response.flash: Normally when we submit a form, response.flash will appear form

[web2py] webservice PySimpleSOAP howto get a table as result

2012-08-07 Thread Fabio Lugo
Hi all I need to create a webserivce with PySimpleSOAP for compatibility reasons, and need to return results in a table format with data from a survey. (My data is in a db and the result will be a query) I looked at the examples of implementation of both the manual and the cookbook that are very

[web2py] autocomplete help_fields

2012-08-07 Thread lyn2py
Hi, I noticed that autocomplete has help_fields = [], help_string may I know what it is used for? I tried it but it renders the autocomplete useless. Also, how can I search more than one field? (I suspect, maybe thru the use of virtual / computed fields?) Thanks! --

[web2py] in trunck - cannot access web2py site with IE when it's running under apache

2012-08-07 Thread Omi Chiba
I'm testing latest version in trunk (Version 2.0.0 (2012-08-07 14:30:28) dev). My web2py site is running under apache by thishttp://ochiba77.blogspot.com/2011/10/how-to-setup-web2py-apache-wsgi-uniform.htmlmethod on my PC (computer name: ochiba-183) It works fine when I access my test site

[web2py] Re: Small bug?

2012-08-07 Thread lyn2py
My code is simple form=SQLFORM(db.category) if form.process().accepted: response.flash = 'form accepted' elif form.errors: response.flash = 'form has errors' return dict(form=form) views is using generic.load to LOAD into a dialog via ajax. I'm using the latest

[web2py] Re: Simple ? How to remove Form Name (form :) from FORM Helper

2012-08-07 Thread Rob_McC
Thanks Anthony. Yes, my function ends in *RAM_Contact_Us/controllers/default.py* with... return dict(form=form) *RAM_Contact_Us/views/default/contactus.html* contains only this: {{extend 'layout.html'}} h3RAM_Contact_Form: Contact Us/h3 {{=BEAUTIFY(response._vars)}} Here is entire

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Massimo Di Pierro
can you reproduce. If this is a web2py problem, it needs to be fixed. On Tuesday, 7 August 2012 10:41:27 UTC-5, Yarin wrote: Think it actually does return a non-specific SQL syntax error that gets ticketed by web2py- but web2py never goes to an error screen and the browser just hangs- if i

Re: [web2py] Re: free search API | Zero-click Info API duckduckgo.com

2012-08-07 Thread Massimo Di Pierro
I am not sure duckduckgo has anything to do with full-text search of own data. perhaps we can integrate whoosh in DAL. perhaps we can add duckduckgo api search in contrib. On Tuesday, 7 August 2012 11:52:36 UTC-5, Michele Comitini wrote: Massimo has already integrated whoosh to some

[web2py] Re: boolean type in MySQL: CHAR(1) vs TINYINT(1)

2012-08-07 Thread Massimo Di Pierro
On can always do: db=DAL('mssql://...') db._adapter.types = copy.copy(db._adapter.types) db._adapter.types['boolean']='TINYINT(1)' It should work. Can you please check it? On Tuesday, 7 August 2012 11:56:59 UTC-5, Osman Masood wrote: However, web2py maintains the promise of backwards

[web2py] Re: Simple ? How to remove Form Name (form :) from FORM Helper

2012-08-07 Thread Rob_McC
My goal, is to have a simple email form that can be customized... What I have is working, except for the form: being displayed. I wonder if there is a simpler way to create a email form. Thanks Rob --

[web2py] Re: Upload error field *_newfilename does not belong to the table

2012-08-07 Thread Massimo Di Pierro
I think this is fixed in trunk, although fixing this may be a backward compatibility issues. When web2py uploads a file (in you case in field picture) the new file name is stored in both form.vars.picture form.vars.picture_newfilename (for backward compatibility) I see the latter is

Re: [web2py] Re: Appengine CPU cycles

2012-08-07 Thread Massimo Di Pierro
Please share you benchmarks when you think you are done. On Tuesday, 7 August 2012 14:29:51 UTC-5, Felipe Meirelles wrote: Well, I'm still in the middle of tests but all points to a huge drop on cpu usage using a model less aproch. I've made, in a few days ill post numbers, but the cpu_ms

[web2py] Re: in trunck - confirm navigation pop up

2012-08-07 Thread Massimo Di Pierro
I can confirm. This needs more work to be made conditional to not saving edits I hope to be done tonight but I could use some help. ;-) All relevant code is the JS in admin/views/default/edit.html On Tuesday, 7 August 2012 15:55:30 UTC-5, Omi Chiba wrote: On Tuesday, August 7, 2012

[web2py] Re: in trunck - cannot access web2py site with IE when it's running under apache

2012-08-07 Thread Massimo Di Pierro
It is probably because of this line in gluon/main.py if not is_valid_ip_address(request.client): raise HTTP(400,Bad Request) Can you log the request.client value for you when it fails? On Tuesday, 7 August 2012 16:02:51 UTC-5, Omi Chiba wrote: I'm testing latest version in trunk

Re: [web2py] Re: Simple ? How to remove Form Name (form :) from FORM Helper

2012-08-07 Thread Bruno Rocha
replace this: {{=BEAUTIFY(response._vars)}} with this: {{=form}} --

Re: [web2py] Re: free search API | Zero-click Info API duckduckgo.com

2012-08-07 Thread Michele Comitini
I am (quite) sure it does not. Just putting down some ideas... What would be nice is to have a search API that is consistent whether data is local, remote or the internet. One could set the scope of the search (internet|remote|local). A local search could have more optional parameters since the

Re: [web2py] Re: Simple ? How to remove Form Name (form :) from FORM Helper

2012-08-07 Thread Rob_McC
rochacbruno: * * Thanks! It worked, and email is sent, and form: is no longer there. I'm going to to a working sample - might be helpful to others. Rob {{extend 'layout.html'}} h3RAM_Contact_Form: Contact Us/h3 {{=form}} On Tuesday, August 7, 2012 6:30:01 PM UTC-4, rochacbruno wrote:

Re: [web2py] Re: free search API | Zero-click Info API duckduckgo.com

2012-08-07 Thread Massimo Di Pierro
This is an interesting idea. On Tuesday, 7 August 2012 17:35:07 UTC-5, Michele Comitini wrote: I am (quite) sure it does not. Just putting down some ideas... What would be nice is to have a search API that is consistent whether data is local, remote or the internet. One could set the

Re: [web2py] Re: web2py hangs while creating the mysql tables

2012-08-07 Thread Yarin
Massimo- steps to reproduce (using rocket/mysql/OSX): 1) In db.py pointing to MySQL: db.define_table('bad', Field('field_a', 'string'), Field('long', 'string') ) 2) Make a request. The app will error out and SQL syntax error will be ticketed. 3) Make another request. App requests now hang.

[web2py] Re: Small bug?

2012-08-07 Thread Anthony
I cannot reproduce the problem. Do you have the absolutely latest trunk, including the latest web2py.js? Anthony On Tuesday, August 7, 2012 5:16:06 PM UTC-4, lyn2py wrote: My code is simple form=SQLFORM(db.category) if form.process().accepted: response.flash = 'form

[web2py] Re: Simple ? How to remove Form Name (form :) from FORM Helper

2012-08-07 Thread Anthony
{{extend 'layout.html'}} h3RAM_Contact_Form: Contact Us/h3 {{=BEAUTIFY(response._vars)}} OK, I guess you lifted the BEAUTIFY() line from the generic.load example. That helper is only used to beautify complex Python objects, like nested lists and dictionaries (see

[web2py] google code issues

2012-08-07 Thread Massimo Di Pierro
Today we closed 48 issues on google code. There are 79 remaining. Some of them the are duplicates. Some of them are are requests for improvements that will probably not be addressed in web2py 2.0. Please check this to make sure your favorite issue was not prematurely closed. If you think an

[web2py] Re: Small bug?

2012-08-07 Thread Massimo Di Pierro
This raises an issue. If somebody is using web2py 2.0 with a legacy app and the old web2py.js there may be problems with flash. On Tuesday, 7 August 2012 20:22:23 UTC-5, Anthony wrote: I cannot reproduce the problem. Do you have the absolutely latest trunk, including the latest web2py.js?

[web2py] Re: google code issues

2012-08-07 Thread Anthony
Looks like a large number of the issues are actually enhancements, but they're all labeled as defects. I think it would be helpful to distinguish between the two so we can more easily target real defects. I don't mind changing some of the labels if you don't mind getting a bunch of

[web2py] Re: Small bug?

2012-08-07 Thread Anthony
On Tuesday, August 7, 2012 9:52:30 PM UTC-4, Massimo Di Pierro wrote: This raises an issue. If somebody is using web2py 2.0 with a legacy app and the old web2py.js there may be problems with flash. On Tuesday, 7 August 2012 20:22:23 UTC-5, Anthony wrote: I cannot reproduce the problem. Do

[web2py] Re: google code issues

2012-08-07 Thread Massimo Di Pierro
I'd appreciate if you could do it. On Tuesday, 7 August 2012 21:01:24 UTC-5, Anthony wrote: Looks like a large number of the issues are actually enhancements, but they're all labeled as defects. I think it would be helpful to distinguish between the two so we can more easily target real

[web2py] Re: Small bug?

2012-08-07 Thread Massimo Di Pierro
I agree this is not a big deal. It will not break apps but will only result in corrupted messages in some rare cases and it is easy to fix by upgrading web2py.js. On Tuesday, 7 August 2012 21:07:37 UTC-5, Anthony wrote: On Tuesday, August 7, 2012 9:52:30 PM UTC-4, Massimo Di Pierro wrote:

[web2py] Re: Small bug?

2012-08-07 Thread lyn2py
Ok, I found web2py.js. It is in the static folder of the app. I took the new one from welcome app and replaced the one in my app. Now my code wouldn't work (my form was not processed). I'm still trying to find out why. Any pointers will be helpful. Thanks. On Wednesday, August 8, 2012 9:22:23

[web2py] Re: google code issues

2012-08-07 Thread Anthony
OK, we now have 49 defects and 30 enhancements. Anthony On Tuesday, August 7, 2012 10:18:51 PM UTC-4, Massimo Di Pierro wrote: I'd appreciate if you could do it. On Tuesday, 7 August 2012 21:01:24 UTC-5, Anthony wrote: Looks like a large number of the issues are actually enhancements, but

[web2py] Re: Small bug?

2012-08-07 Thread lyn2py
I've discovered a difference between the previous and the new is the form submission. The old version post has parameters for application/x-www-form-urlencoded. The new version post has no parameters. So it seems that the form was not POSTed at all? On Wednesday, August 8, 2012 11:06:53 AM

[web2py] Re: google code issues

2012-08-07 Thread Massimo Di Pierro
:-) On Tuesday, 7 August 2012 22:16:21 UTC-5, Anthony wrote: OK, we now have 49 defects and 30 enhancements. Anthony On Tuesday, August 7, 2012 10:18:51 PM UTC-4, Massimo Di Pierro wrote: I'd appreciate if you could do it. On Tuesday, 7 August 2012 21:01:24 UTC-5, Anthony wrote: Looks

  1   2   >