Hi Try (a simplified example): Select((agtAgent.q.name, agtAgent.q.level + agtAgent.q.quality), where = agtAgent.q.reqStanding > 5)
I didn't try this specific query, but I tried one similar to it on my own db. Cheers, Imri On Sat, Aug 7, 2010 at 5:57 AM, Dominic LoBue <dominic.lo...@gmail.com>wrote: > Hello, > > Is it possible to create a "virtual" column in SQLObject? > > To give you an example of what I mean by a virtual column, given a > table named "agtAgent" with a StringCol() named "name", and two > IntCol()'s named "level" and "quality", consider this SQL statement: > select name, level, quality, (((level -1)*2) + (quality/20)) as > reqStanding from agtAgent where reqStanding > %i > > Is it possible to do something like this in SQLObject without having > to drop down to writing the sql queries manually? > > -- > Dominic LoBue > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by > > Make an app they can't live without > Enter the BlackBerry Developer Challenge > http://p.sf.net/sfu/RIM-dev2dev > _______________________________________________ > sqlobject-discuss mailing list > sqlobject-discuss@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > -- Imri Goldberg -------------------------------------- http://plnnr.com/ - automatic trip planning http://www.algorithm.co.il/blogs/ -------------------------------------- -- insert signature here ----
------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
