[web2py] Re: Key error in controller db select

2011-05-11 Thread james c.
Thanks Anthony. This works and the creation, read/write must be from within the same function (as you said). thanks again for your help. James On May 10, 7:37 pm, Anthony wrote: > On Tuesday, May 10, 2011 10:32:34 PM UTC-4, Anthony wrote: > > > To keep things DRY, you can define a template table

[web2py] Re: Key error in controller db select

2011-05-10 Thread Anthony
On Tuesday, May 10, 2011 10:32:34 PM UTC-4, Anthony wrote: > > To keep things DRY, you can define a template table in a model file and use > table inheritance to define the specific tables where needed (see > http://web2py.com/book/default/chapter/06#Table-Inheritance). For example, > in a mode

[web2py] Re: Key error in controller db select

2011-05-10 Thread Anthony
On Tuesday, May 10, 2011 6:58:05 PM UTC-4, james c. wrote: > > Prior to the select I defined and created a user named table by using > the variable company_accounts_db. User_id 8 enters a company name > within a form. The form input is used to define the variable db name > by: company_accounts

[web2py] Re: Key error in controller db select

2011-05-10 Thread villas
> company_name = 'BIGkittyBIG' Try it with a lowercase name. I know that either case should work, but this has been an issue in the past and worth considering/trying. In this instance, I suppose it would be 'smallkittysmall' :)

[web2py] Re: Key error in controller db select

2011-05-10 Thread james c.
Thanks Anthony, I'm trying to create a user named table, using company_accounts_db as a variable. Prior to the select I defined and created a user named table by using the variable company_accounts_db. User_id 8 enters a company name within a form. The form input is used to define the variable db

[web2py] Re: Key error in controller db select

2011-05-10 Thread Anthony
On Tuesday, May 10, 2011 4:01:34 PM UTC-4, james c. wrote: > > I am having trouble with a key exception error. The problem is > occuring when the controller tries to read a database defined earlier > in the controller. The Error Message is occurring here: > > company_name = 'BIGkittyBIG'