[sqlalchemy] Re: SQLError: ... invalid identifier

2007-05-07 Thread Michael Bayer
yeah also whats your mapper on that ? is there a string-based order_by in there somewhere (or in the query.selectfirst() call) ? i dont understand why that name wouldnt be truncated. On May 7, 2007, at 3:09 PM, shday wrote: The table is reflected here: study_request_table =

[sqlalchemy] Re: SQLError: ... invalid identifier

2007-05-07 Thread Michael Bayer
also is there a count() stuck in there somewhere ? the tbl_row_count identifier only comes into play when theres count(). On May 7, 2007, at 3:09 PM, shday wrote: The table is reflected here: study_request_table = Table('study_request',metadata,

[sqlalchemy] Re: SQLError: ... invalid identifier

2007-05-07 Thread shday
The mapper: mapper(StudyRequest,study_request_table,properties={'model':relation(Model, primaryjoin=model_table.c.model_id==study_request_table.c.model_id, foreign_keys=[study_request_table.c.model_id], lazy=False), #backref doesn't work in 3.6

[sqlalchemy] Re: SQLError: ... invalid identifier

2007-05-07 Thread shday
No count() anywhere. On May 7, 3:17 pm, Michael Bayer [EMAIL PROTECTED] wrote: also is there a count() stuck in there somewhere ? the tbl_row_count identifier only comes into play when theres count(). On May 7, 2007, at 3:09 PM, shday wrote: The table is reflected here:

[sqlalchemy] Re: SQLError: ... invalid identifier

2007-05-07 Thread Michael Bayer
k i got it, rev 2609. On May 7, 2007, at 3:44 PM, shday wrote: The mapper: mapper(StudyRequest,study_request_table,properties={'model':relation (Model, primaryjoin=model_table.c.model_id==study_request_table.c.model_id, foreign_keys=[study_request_table.c.model_id],