[web2py] Re: How to code efficiently for multiple database engines with Exceptions

2016-09-08 Thread Joe Barnhart
Hi Massimo -- Two issues... 1. I use a Mac. For whatever reason, psycopg2 does not "pip install" on a Mac. I researched it for a day or so -- even AFTER having had it WORKING on my system until I "upgraded" to El Capitan and it all quit. I am so done with psycopg2 because its installation

[web2py] Re: Is it risky to smuggle variables into a Row object?

2016-09-08 Thread Joe Barnhart
Nobody is answering your question, so I'll take a crack at it. Mind you, I'm not a contrib or anything, just an enthusiastic user so caveat emptor... Rows objects are just a form of BasicStorage object, which makes accessing dictionary items easier with the attribute ("dot") syntax. I've

[web2py] Re: Preserving objects sort order between controller and view

2016-09-08 Thread Peter
Some times you just have to laugh! I have totally screwed things up (I have a backup but was hoping not to use it) I dropped the invoice table and started getting this... table invoice already exists on investigation the error, I discovered I had not included a db.commit() after the drop

[web2py] Re: scheduler task_id assigned to multiple workers

2016-09-08 Thread Niphlod
what driver are you using to connect to mssql ? and what are the properties of the database ? (sp_helpdb dbname). seems rather strange that a box that handles "over 20k a second" can't stand the pressure of an additional 20 (without the "k"). On Tuesday, September 6, 2016 at 5:19:30 PM UTC+2,

[web2py] Re: queue_task :: trouble with quoted json strings for pvars and args

2016-09-08 Thread Niphlod
queue_task just does json.dumps(vars) https://github.com/web2py/web2py/blob/master/gluon/scheduler.py#L1483 the field is defined as 'text' https://github.com/web2py/web2py/blob/master/gluon/scheduler.py#L813 IMHO it's an issue with the oracle driver. On Thursday, September 8, 2016 at 8:14:49

[web2py] Re: queue_task :: trouble with quoted json strings for pvars and args

2016-09-08 Thread Dave S
On Thursday, September 8, 2016 at 6:27:15 AM UTC-7, Erwn Ltmann wrote: > > Hi Dave, > > thx for your response. I'm sorry, but it doesn't helps me. My problem > concerning the usage of scheduler_task queueing. The web2py scheduler > transforms automatically the dictionary parameter 'pvars' into

[web2py] Re: crud.delete and record versioning error

2016-09-08 Thread Dave S
On Thursday, September 8, 2016 at 2:50:54 AM UTC-7, Kirill Shatalaev wrote: > > So, is CRUD going to be deprecated? > That's been discussed in this forum. The changelog doesn't discuss it, but way back in 1.99.1-1.99.2, "- new SQLFORM.grid and SQLFORM.smartgrid (should replace crud.search and

[web2py] Re: queue_task :: trouble with quoted json strings for pvars and args

2016-09-08 Thread Erwn Ltmann
Hi Dave, thx for your response. I'm sorry, but it doesn't helps me. My problem concerning the usage of scheduler_task queueing. The web2py scheduler transforms automatically the dictionary parameter 'pvars' into a string represented JSON in order to save this value as VARCHAR2(512) into the

[web2py] Re: crud.delete and record versioning error

2016-09-08 Thread Kirill Shatalaev
So, is CRUD going to be deprecated? вторник, 6 сентября 2016 г., 18:39:03 UTC+4 пользователь Massimo Di Pierro написал: > > please do not use crud. it has not been supported in long time. just use > db(...).delete() > > > -- Resources: - http://web2py.com - http://web2py.com/book

Re: [web2py] st_within example

2016-09-08 Thread Manuele Pesenti
Il 08/09/16 10:57, Gael Princivalle ha scritto: > Hello. > > Could someone give me an example of the postgis st_within function? > > http://postgis.org/docs/ST_DWithin.html > > Model > | > db.define_table('places',Field('loc','geometry()')) > | > Where I insert 3 geoPoints: > | >

[web2py] st_within example

2016-09-08 Thread Gael Princivalle
Hello. Could someone give me an example of the postgis st_within function? http://postgis.org/docs/ST_DWithin.html Model db.define_table('places', Field('loc', 'geometry()')) Where I insert 3 geoPoints: geoPoint(1, 1) geoPoint(3, 2) geoPoint(6, 5) query = db.places.loc.st_within(geoPoint(0,

[web2py] Re: Preserving objects sort order between controller and view

2016-09-08 Thread Dave S
On Wednesday, September 7, 2016 at 10:00:05 PM UTC-7, Peter wrote: > > > Thanks for the response Dave, > > I haven't got the hang of this editor yet so I hope this doesn't appear as > a total mess... > > My view code... > > {{ line=0 }} > {{=inv_lines }} >