From: Jonathan E. <jon...@ca...> - 2008-06-26 16:42:50
|
It looks like you're seeing the sqlalchemy version distributed with Spyce, which is pretty old. rm that from your spyce directory and it should see the newer one you manually installed. (although you should definitely be usuing 0.4.6 now, not 0.4.0) -Jonathan On Tue, 24 Jun 2008 23:58:55 -0400, "Noel Quintos" <npq...@gm...> said: > Hi there! > > I already have a working Spyce web server running SqlAlchemy-0.4.0 on > Postgresql. Then, I decided to buy a new PC and develop it there but > my web displays that used to run on the old PC installation would not > run anymore. > > The following web page would display/run without any error: > > > <HTML> > <HEAD> > <TITLE></TITLE> > </HEAD> > <BODY> > This is a test whether it works on spy > <BR> > [[\ > li = db.customer.select() > ]] > <TABLE> > <TH>Name</TH><TH>Address</TH> > [[ for s in li: { ]] > <TR> > <TD>[[=s.customer]]</TD><TD>[[=s.address]]</TD> > </TR> > [[ } ]] > </TABLE> > </BODY> > </HTML> > > However, if I replace "db.customer.select()" with "db.customer.all()" > and call the file test3.spy, I have the following error message: > > File: /home/postgres/farmers/www/test3.spy > Message: AttributeError: all > > Stack: /home/postgres/spyce-2.1/sqlalchemy/orm/query.py:303, in > __getattr__: > raise AttributeError(key) > /home/postgres/spyce-2.1/sqlalchemy/ext/sqlsoup.py:313, in __getattr__: > return getattr(cls._query, attr) > test3.spy:9, in (main): > li = db.customer.all() > > > I also tried doing it manually on the interactive python shell and > db.customer.all() does not raise any error at all! Whats wrong? > Thanks! > > Noel > > > -- > Noel P. Quintos > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Spyce-users mailing list > Spy...@li... > https://lists.sourceforge.net/lists/listinfo/spyce-users |