'cause there is.
Use
db.getValueExpr("foo");
like e.g.
cmd.select(db.getValueExpr("foo"));
or
cmd.where(db.getValueExpr("foo").is(EMPLOYEE.FIRSTNAME));
Regards
Rainer
> from: Harald Kirsch [mailto:[email protected]]
> to: [email protected]
> re: creating constant select statements
>
> Hi everyone,
>
> is there a way to generate constant selects, like in
>
> select "four", 5, "six";
>
> I need this to streamline some code which sometimes has a group by and
> sometimes does not have it. With the group by I naturally get
>
> result1 552
> result2 234
> result4 222
>
> but when there is no group by I get just one single number, but would rather
> like to have
>
> all 789
>
> Therefore I would like to create a command equivalent for
>
> select 'all', count(*) from ...
>
> Is this possible?
>
> Thanks,
> Harald.
>
> --
> Harald Kirsch
> Raytion GmbH
> Kaiser-Friedrich-Ring 74
> 40547 Duesseldorf
> Fon +49-211-550266-0
> Fax +49-211-550266-19
> http://www.raytion.com
