[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-29 Thread Alan Etkin
OK, it seems that GAE isn't fond of floats, but is quite happy with doubles Good to know, but, how did you fix GAE?. Have you changed your model? This might be a bug in the DAL adapter -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-29 Thread Scott Hunter
Sorry - yes, I changed the model, replacing the floats with doubles. On Tuesday, January 29, 2013 4:33:12 AM UTC-5, Alan Etkin wrote: OK, it seems that GAE isn't fond of floats, but is quite happy with doubles Good to know, but, how did you fix GAE?. Have you changed your model? This

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Alan Etkin
To elaborate on title: I have a simple web2py app, from which I can insert records into a particular table (using a smart grid, o Could you please post the app engine error output? Also I belive that posting the involved model/controller code might help debugging. -- --- You

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Scott Hunter
As requested, here is the traceback: In FILE: /base/data/home/apps/s~sbhweb2py/1.364873083036857122/applications/ppt_demo/controllers/default.py Traceback (most recent call last): File /base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/restricted.py, line 212, in restricted

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Alan Etkin
As requested, here is the traceback: Looks like a non-float value is sent to the GAE adapter for datatastore insertion (without the proper type validation). otherwise the appengine sdk should not raise that exception. Maybe you can debug the form values on submission to check they are

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Scott Hunter
I entered 15.0 in the form, which sure looks like a float to me. If I had entered a non-float, automatic validation should have caught it before the appengine sdk was called to do a set. And when I used an insert statement myself using the DAL, I tried hard-coding a 10.0 for that field --

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Alan Etkin
I entered 15.0 in the form, which sure looks like a float to me. If I had entered a non-float, automatic validation should have Not the best solution I guess, but, maybe you could try to define the missing table/field objects in the datastore web interface to check if the adapter is

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Scott Hunter
OK, it seems that GAE isn't fond of floats, but is quite happy with doubles -- its now happy with inserting both from a smartgrid-created form and from DAL calls. (I couldn't define any fields directly b/c the table/entity no longer appeared.) Thanks. On Monday, January 28, 2013 7:37:52 PM