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.lobue@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 ----