Re: [web2py] Key Error when try to access records in DB tables

2017-01-25 Thread Richard Vézina
Hmm... Is "table_name" what you exactly use in your code or does it stand for a table name that you actually keep from us to know (it ok we don't know the name of your entity if you want ot keep it secret)? Because I thinking that you use litterally 'table_name' in your code and that would be amuzi

Re: [web2py] Key Error when try to access records in DB tables

2016-06-15 Thread Joe
Hi Dave, Thanks for your reply. I am using the SQLITE on localhost offline on my PC. Basically, I have all the web2py default settings in my app. I just created a grid to check if I can view the records that way. The records are displayed in the grid but when I click view to select a row in t

Re: [web2py] Key Error when try to access records in DB tables

2016-06-15 Thread Dave S
On Wednesday, June 15, 2016 at 3:41:21 PM UTC-7, Joe wrote: > > [...] > > To be more clear, in the database administration, in db.table_name, in > column db.table_name.id, when I click to select a row by ID I get this > error. > >> >> You have multiple rows shown in the admin display, I take

Re: [web2py] Key Error when try to access records in DB tables

2016-06-15 Thread Joe
Hello Anthony, Thanks very much for your reply. I posted more info including the traceback in my reply to Richard. Please kindly take a look. Thanks again. Cheers, Joe On Thursday, June 16, 2016 at 3:36:31 AM UTC+8, Anthony wrote: > > And full traceback. > > On Wednesday, June 15, 2016 at 2:

Re: [web2py] Key Error when try to access records in DB tables

2016-06-15 Thread Joe
Hello Richard and Anthony, Thanks very much for your reply. Here is the traceback: Traceback (most recent call last): File "C:\Users\Acer\Desktop\web2py_new\web2py_win\web2py\gluon\restricted.py", line 227, in restricted exec ccode in environment File "C:/Users/Acer/Desktop/web2py_new

Re: [web2py] Key Error when try to access records in DB tables

2016-06-15 Thread Anthony
And full traceback. On Wednesday, June 15, 2016 at 2:53:20 PM UTC-4, Richard wrote: > > I think we would need more details, web2py version, more code, click on ID > number?? in grid? > > Richard > > On Wed, Jun 15, 2016 at 1:36 AM, Joe wrote: > >> I can't understand what could possibly cause thi

Re: [web2py] Key Error when try to access records in DB tables

2016-06-15 Thread Richard Vézina
I think we would need more details, web2py version, more code, click on ID number?? in grid? Richard On Wed, Jun 15, 2016 at 1:36 AM, Joe wrote: > I can't understand what could possibly cause this. When I submit the form, > the form is processed, the page is redirected, email sent and the recor

[web2py] Key Error when try to access records in DB tables

2016-06-14 Thread Joe
I can't understand what could possibly cause this. When I submit the form, the form is processed, the page is redirected, email sent and the records stored in the DB table as expected. But, when I click on the ID number of the row in the table, trying to access the records, as I always do, I get