Oops...I thought I had copied the traceback in, but I forgot it...my
bad. Here's the error:
Traceback (most recent call last):
File "main.py", line 1461, in <module>
app = Main(flag)
File "main.py", line 81, in __init__
self.createCtrls()
File "main.py", line 431, in createCtrls
self.zsession)
File "/home/jcbailey/Desktop/Timesheet/ts_info.py", line 366, in
getUserInfo
userInfo = query.first()
File "/usr/lib/python2.5/site-packages/sqlalchemy/orm/query.py",
line 1219, in first
ret = list(self[0:1])
File "/usr/lib/python2.5/site-packages/sqlalchemy/orm/query.py",
line 1140, in __getitem__
return list(res)
File "/usr/lib/python2.5/site-packages/sqlalchemy/orm/query.py",
line 1344, in instances
for row in fetch]
File "/usr/lib/python2.5/site-packages/sqlalchemy/orm/query.py",
line 1343, in <genexpr>
rows = [rowtuple(proc(context, row) for proc in process)
File "/usr/lib/python2.5/site-packages/sqlalchemy/orm/query.py",
line 2062, in proc
return row[column]
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1348, in __getitem__
return self.__parent._get_col(self.__row, key)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1609, in _get_col
type_, processor, index = self._props[key]
File "/usr/lib/python2.5/site-packages/sqlalchemy/util.py", line 71,
in __missing__
self[key] = val = self.creator(key)
File "/usr/lib/python2.5/site-packages/sqlalchemy/engine/base.py",
line 1507, in fallback
raise exc.NoSuchColumnError("Could not locate column in row for
column '%s'" % (str(key)))
sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for
column 'GEOverview.SALVAR'"
I'll try to get pyodbc installed too. Thanks!
Mike
On Mar 23, 1:06 pm, "Michael Bayer" <[email protected]> wrote:
> we'd need to know what "stopped working" means, and also note that our
> MSSQL support is strongest with pyodbc and not so much with adodbapi.
>
> Mike wrote:
>
> > Hi,
>
> > I was using SqlAlchemy 0.5.0rc4 (and Python 2.5) on Ubuntu 8.10 and it
> > was working great. Then one of my users upgraded to SA 0.5.2 and now
> > one of my queries stopped working. Here's what my query looks like:
>
> > <code>
> > query = session.query(GE.ID, GE.FNAME, GE.LNAME,
> > GE.DATE, GE.SALVAR).filter_by
> > (NETNAME=str(username))
> > userInfo = query.first()
> > </code>
>
> > I have the adodb module installed and I think that is what SA is
> > using. The database is on Microsoft SQL Server 2000. I am using the
> > autoload functionality to create the Table object:
>
> > overview_tbl = Table('GEOverview', metadata,
> > Column('id', Integer, primary_key=True),
> > autoload=True)
>
> > Any ideas on what's different between the two versions that would
> > cause this? I have a feeling this will probably effect my Windows
> > users too if I upgrade them.
>
> > Thanks,
>
> > Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
