[web2py] Re: Weird form issue

2016-06-07 Thread Jeff Riley
Mark. Could you contact me at javajeff...@gmail.com. I would like to see if you could help me finish this out and what that might cost. On Monday, June 6, 2016 at 5:10:37 PM UTC-5, Mark Graves wrote: > > Hey Jeff, > > Most likely the date/time format. > > If you can post a sample sqlite file an

[web2py] Re: Weird form issue

2016-06-06 Thread Mark Graves
Hey Jeff, Most likely the date/time format. If you can post a sample sqlite file and SQLGRID code, happy to help. -Mark On Monday, June 6, 2016 at 12:42:16 PM UTC-7, Jeff Riley wrote: > > Sorry quick update. Rows is returning information, so I must have a > problem with my javascript. I st

[web2py] Re: Weird form issue

2016-06-06 Thread Jeff Riley
Sorry quick update. Rows is returning information, so I must have a problem with my javascript. I still however cannot delete the record from the SQLgrid view. On Monday, June 6, 2016 at 2:38:03 PM UTC-5, Jeff Riley wrote: > > Now I am truly confused. I am able to submit the form and create t

[web2py] Re: Weird form issue

2016-06-06 Thread Jeff Riley
Now I am truly confused. I am able to submit the form and create the record in the database, but now rows = db(db.training).select() is not returning anything and I cannot delete the record from the SQLGrid view. I have really wacked something up. On Sunday, June 5, 2016 at 2:34:16 PM UTC-

Re: [web2py] Re: Weird form issue

2016-06-05 Thread Mark Graves
=) You're welcome Happens all the time to me, I find that I learn the most by listening to others. I couldn't figure it out too, so I dove in. It caused me to rethink the web2py form and db logic =) -Mark On Sun, Jun 5, 2016 at 4:36 PM, Jeff Riley wrote: > Seriously. Well that is just emb

[web2py] Re: Weird form issue

2016-06-05 Thread Jeff Riley
Seriously. Well that is just embarrassing. Thank you so much Mark for your help with this. In looking back at the other 22 forms I have created, this is the first one where I was pre-populating any of the fields and not showing them. Thank you for this valuable insight. All my best. On Sun

[web2py] Re: Weird form issue

2016-06-05 Thread Mark Graves
Hey Jeff, It looks like you created a sqlform expecting all fields, then the form was expecting all fields back, but you only used some of them in the view, so they were not processed. Specifically, the status field. You could either set the type of the field to hidden and include it or only