[web2py] mysql problem after updating to 2.6.4

2013-09-26 Thread Wouter Pronk
Hello, I've updated web2py to version 2.6.4 and now I get a Mysql-error which I didn't have before: 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

[web2py] parse_as_rest limit

2013-05-24 Thread Wouter Pronk
Hello All, I'm trying out the pasrse_as_rest example from the book. One of the options is limit . I have 14 records in my table and I want to show the first 10 records. If I enter in http://localhost:8000/RT/default/api/entries?limit=10; the page returns too many records. I also tried using

[web2py] loading appadmin informix table

2013-04-15 Thread Wouter Pronk
Hello, I'm connected to a Informix-dynamic-server database and I have a problem loading the appadmin view for a table. I've tried if my model will run trough the web2py-shell and it does, but when I try in the web-interface web2py seems to be crashing. This is my model: db =

Re: [web2py] Re: loading appadmin informix table

2013-04-15 Thread Wouter Pronk
Hello Niphlod, nothing. The browsers just tries to keep loading (message: waiting on localhost) and the server-app is not responding (and blank). Op 15-04-13 14:07, Niphlod schreef: anything specific reported in the crashing page ? -- --- You received this message because you are subscribed

Re: [web2py] Re: loading appadmin informix table

2013-04-15 Thread Wouter Pronk
No, nothing. Already added migrate=False, but no change. Op 15-04-13 14:15, Niphlod schreef: something in the databases/sql.log file ? PS: try to specify migrate=False in the table definition too. Shouldn't be needed but it's always a nice check to do when debugging such locks -- --- You

Re: [web2py] Re: loading appadmin informix table

2013-04-15 Thread Wouter Pronk
Hello Niphlod, my initial information was not correct. In the shell I tried db.executesql('SELECT * FROM tl;') and this work but if I do things =db(db.tl.id0).select() than that's it. The prompt doesn't return and I have to kill the shell. Op 15-04-13 14:47, Niphlod schreef: any chance in

Re: [web2py] Re: loading appadmin informix table

2013-04-15 Thread Wouter Pronk
the version of informix is 12.10. Thanks for your help so far Niphlod. Op 15-04-13 17:09, Niphlod schreef: well, this helps to understand why the appadmin is failing if it fails in the shell, there's no way it works in the appadmin. Unfortunately I don't have an informix instance available,

[web2py] informix standard engine

2012-12-04 Thread Wouter Pronk
I'm trying to connect web2py to Informix SE (standard engine) with some succes. I've edited dal.py and removed the following dbms_version = int(self.connection.dbms_version.split('.')[0]) if lmin and (dbms_version = 10): # Requires Informix 10.0+ sql_s

Re: [web2py] Re: informix standard engine

2012-12-04 Thread Wouter Pronk
should be able to fix the problem just by tweaking the InformixSEAdapter and not the normal InformixAdapter. Let me know if this work for you. Massimo On Tuesday, 4 December 2012 05:08:37 UTC-6, Wouter Pronk wrote: I'm trying to connect web2py to Informix SE (standard engine) with some

[web2py] Re: informix standard engine

2012-11-27 Thread Wouter Pronk
, November 26, 2012 4:27:19 AM UTC-3, Wouter Pronk wrote:Hello All, I'm trying to connect to an external Informix Standard Enigine database. This works when I use Informixdb (python-module), but in web2py I get the following error when go to the database administration: The adapter

[web2py] informix standard engine

2012-11-25 Thread Wouter Pronk
Hello All, I'm trying to connect to an external Informix Standard Enigine database. This works when I use Informixdb (python-module), but in web2py I get the following error when go to the database administration: ValueError: invalid literal for int() with base 10: '| My db.py looks like

[web2py] SQLFORM.factory

2012-11-07 Thread Wouter Pronk
I have the following code: form = SQLFORM.factory( Field('relatie_id', writable=False, readable=False), Field('relatie_nummer', writable=False, readable=False), Field('direction', writable=False, readable=False), Field('protocol', writable=False,

[web2py] Re: SQLFORM.factory

2012-11-07 Thread Wouter Pronk
in your app, that piece of code works perfectly fine (the fact that you're declaring 5 fields to let display only one is quite not understandable but hey, it works nonetheless) On Wednesday, November 7, 2012 11:32:39 AM UTC+1, Wouter Pronk wrote: I have the following code: form

[web2py] Re: SQLFORM.factory

2012-11-07 Thread Wouter Pronk
, 2012 12:12:24 PM UTC+1, Wouter Pronk wrote: Hello Niphlod, this is the traceback: Traceback (most recent call last): File /home/wouter/Web2py/web2py/gluon/restricted.py, line 212, in restricted exec ccode in environment File /home/wouter/Web2py/web2py/applications/edirelaties

[web2py] Re: SQLFORM.factory

2012-11-07 Thread Wouter Pronk
' return dict(form=form) Any idea? Op woensdag 7 november 2012 12:42:58 UTC+1 schreef Niphlod het volgende: did you try with trunk ? On Wednesday, November 7, 2012 12:38:40 PM UTC+1, Wouter Pronk wrote: I just did and it did go in exception. Is my web2py corrupt? Op woensdag 7 november 2012 12

[web2py] Re: SQLFORM.factory

2012-11-07 Thread Wouter Pronk
where the errors pops up ? On Wednesday, November 7, 2012 2:58:10 PM UTC+1, Wouter Pronk wrote: Did some other testing and found simular error on this controler: def add_relatie(): adres = db.executesql('SELECT adressen.relatie_nummer, | , adressen.relatie_code

[web2py] validate table cell

2012-10-27 Thread Wouter Pronk
Hello All, I have a form that looks similar to this: form table trtdinput name=N value=123//td/tr trtdinput name=N value=//td/tr /table input type=submit /form On submit I would like web2py to validate all values for name=N and if one is empty then give a response.flash like line 2 is empty!.