You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by kVoid <vp...@gmail.com> on 2009/04/16 16:47:08 UTC

GenericDelegator How To - SELECT MAX(CAST (hospital_id AS int4)) FROM hospital

Hi,

Does anyone know how can I write an equivalent of this SQL Statement
(postgres):
SELECT MAX(CAST (hospital_id AS int4)) FROM hospital; 
using GenericDelegator java class of ofbiz?

Thanks,
Valentin
-- 
View this message in context: http://www.nabble.com/GenericDelegator-How-To---SELECT-MAX%28CAST-%28hospital_id-AS-int4%29%29-FROM-hospital-tp23079429p23079429.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: GenericDelegator How To - SELECT MAX(CAST (hospital_id AS int4)) FROM hospital

Posted by BJ Freeman <bj...@free-man.net>.

Look at the webtools code that pass sql.
https://demo.ofbiz.org/webtools/control/EntitySQLProcessor

kVoid sent the following on 4/16/2009 7:47 AM:
> Hi,
> 
> Does anyone know how can I write an equivalent of this SQL Statement
> (postgres):
> SELECT MAX(CAST (hospital_id AS int4)) FROM hospital; 
> using GenericDelegator java class of ofbiz?
> 
> Thanks,
> Valentin