Re: [SQLObject] Select queries based on "virtual" columns?

[Imri G. <lor...@gm...>]

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 <dom...@gm...>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
> sql...@li...
> 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 ----