Nevermind. Misconfigured table names. Sorry to bother.
On 22 מרץ, 01:44, Rotem Tamir <[email protected]> wrote: > hi > > trying to build a new app on top of our accounting software. building > with turbogears 1.1. > > managed to connect to database properly. > > this is my model (narrowed down to minimum columns just to see if > works) > > class ZoomFncItem(Entity): > using_options(tablename='dbo.FNCITEMS') > trans = Field(Integer,colname='FNCTRANS',primary_key=True) > udate = Field(Integer,colname='UDATE') > > I try: > > ZoomFncItem.query.all() > > and get ugly error message: > > ProgrammingError: (ProgrammingError) ('42S02', "[42S02] [Microsoft] > [ODBC SQL Ser > ver Driver][SQL Server]Invalid object name 'dbo.FNCITEMS'. (208) > (SQLExecDirectW > )") u'SELECT [dbo.FNCITEMS].[FNCTRANS] AS [dbo.FNCITEMS_FNCTRANS], > [dbo.FNCITEMS > ].[UDATE] AS [dbo.FNCITEMS_UDATE] \nFROM [dbo.FNCITEMS] ORDER BY > [dbo.FNCITEMS]. > [FNCTRANS]' [] > > I try the query directly to the database and get a similar error. > > I try editing the query and if there is no period('.' sign) after the > AS, it works.. is there a way to make sqlalchemy ask for the columns > like > select [dbo.FNCITEMS].[FNCTRANS] AS FNCITEMS_FNCTRANS (i.e without the > period) ? > > i do not control the database and i have no way to change the table > names.. > > thanks in advance > > Rotem Tamir -- You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en.
