And in this case you can still use createSQL to create the VIEW if your database supports it and querySQL can SELECT FROM your VIEW or just be an arbitray query.
On Mon, 7 Aug 2006, Rick Flosi wrote: > The query doesn't necessarily have to exist as a database view either. > Maybe we can have: > class sqlmeta: > querySQL = """SELECT id, COUNT(number) FROM foo""" > instead of using an actual database view. > > -- > Rick > > On Mon, 7 Aug 2006, Rick Flosi wrote: > >> On Mon, 7 Aug 2006, Oleg Broytmann wrote: >> >>> On Mon, Aug 07, 2006 at 11:00:39AM -0500, Rick Flosi wrote: >>>> Could we handle this problem by creating a database view >>> >>> Do all the backends supported by SQLObject support VIEWs? >> >> Postgres does. I don't know about any of the others off hand. >> >> Can anyone that knows comment? >> >> -- >> Rick >> > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sqlobject-discuss mailing list > sqlobject-discuss@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
