it is a bug but an easy one to fix.
On Sep 21, 3:44 pm, mwolfe02 <michael.joseph.wo...@gmail.com> wrote:
> I'm using a legacy tables and trying to use the shortcut method of
> returning a row/record by passing the value of the ID field directly
> to the table. It appears that 'id' is still hardcoded into the logic
> at some level, though. This works:
>
> db.mytable(db.mytable.my_id==1)
>
> But this does not:
>
> db.mytable(1)
>
> # returns ProgrammingError: ('42S22', "[42S22] [Microsoft][ODBC SQL
> Server Driver][SQL Server]Invalid column name 'id'. (207)
> (SQLExecDirectW)")
> # for a table defined as follows:
>
> db.define_table('mytable',
> Field('my_id', 'id')
> )
>
> db.mytable(1)
>
> # returns KeyError: 'id'
> # for a table defined as follows:
>
> db.define_table('mytable',
> Field('my_id', 'id'),
> primarykey=['my_id']
> )
>
> I can understand the second case failing, as primarykey seems like it
> would be usually used to define a multi-field key. In such a case, a
> single value would not be enough to identify a record, anyway. I
> tried this simply as a workaround for the original problem, but with
> no success.
