From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 23, 2012, at 9:25 PM, Adam Heath wrote:
On 05/23/2012 01:13 PM, Jacopo Cappellato wrote:
Using count() was simply a trick to be sure to get a record back even if the entity is empty... but if we use an entity that we
are sure is
this is my sql query.. this answer i need to show in a drop down list..
select * from hello_hobby where hello_hobby_id NOT IN
(select hello_hobby_id from hello_person_hobby where
hello_person_id='1')
Am using the following code to display the query select hello_hobby_id from
On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote:
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 23, 2012, at 9:25 PM, Adam Heath wrote:
On 05/23/2012 01:13 PM, Jacopo Cappellato wrote:
Using count() was simply a trick to be sure to get a record back even if
the
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote:
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 23, 2012, at 9:25 PM, Adam Heath wrote:
On 05/23/2012 01:13 PM, Jacopo Cappellato wrote:
Using count() was simply a
On May 24, 2012, at 10:37 AM, Jacques Le Roux wrote:
select 1 works on Postgres
this is interesting, thanks for testing it.
Unfortunately it doesn't seem to work on Derby and I didn't test on other
dbs... but if we could find a similar solution that works everywhere it would
be great.
SELECT 1 FROM SYSIBM.SYSDUMMY1 works for Derby. If all others work with SELECT 1 we could set a property in entityengine.xml (by
DB)With SELECT 1 for all but Derby and SELECT 1 FROM SYSIBM.SYSDUMMY1 for Derby. We could also use the same trick for other DBs if
SELECT 1 does not work for them (eg
Thanks Jacques.
However values 1 works in Derby (but not from the Webtools, because of a
limitation in the data prep script).
Jacopo
On May 24, 2012, at 11:33 AM, Jacques Le Roux wrote:
SELECT 1 FROM SYSIBM.SYSDUMMY1 works for Derby. If all others work with
SELECT 1 we could set a property
Pravin,
Please do not use this list for learning how to do development in ofbiz.
This list is for developers of Ofbiz.
--Venkat
On Thu, May 24, 2012 at 12:25 PM, pravin pravin.ku...@venkatmangudi.comwrote:
this is my sql query.. this answer i need to show in a drop down list..
select * from
On 5/20/2012 10:01 AM, Jacques Le Roux wrote:
Quick questions (seems that there is a lack of internal documentation
to say the least), there are not only addressed to Adam...
About javacc dependency do we really need it *OOTB*?
Can't we use rather externally maintained ant targets like in
On 05/24/2012 03:22 AM, Jacopo Cappellato wrote:
On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote:
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 23, 2012, at 9:25 PM, Adam Heath wrote:
On 05/23/2012 01:13 PM, Jacopo Cappellato wrote:
Using count() was simply a trick
On May 24, 2012, at 5:06 PM, Adam Heath wrote:
On 05/24/2012 03:22 AM, Jacopo Cappellato wrote:
On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote:
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 23, 2012, at 9:25 PM, Adam Heath wrote:
On 05/23/2012 01:13 PM, Jacopo
On May 24, 2012, at 5:06 PM, Adam Heath wrote:
select 1 from entity_key_store where key_name = '' limit 1;
ouch, I am getting an error on Derby for the limit 1 syntax... since it is
currently used in the validation query based on Example I am now wondering if
it is actually used at all.
I
On 05/24/2012 08:15 AM, Adrian Crum wrote:
On 5/20/2012 10:01 AM, Jacques Le Roux wrote:
Quick questions (seems that there is a lack of internal
documentation to say the least), there are not only addressed to
Adam...
About javacc dependency do we really need it *OOTB*?
Can't we use rather
On 05/24/2012 10:18 AM, Adam Heath wrote:
On 05/24/2012 08:15 AM, Adrian Crum wrote:
On 5/20/2012 10:01 AM, Jacques Le Roux wrote:
Quick questions (seems that there is a lack of internal
documentation to say the least), there are not only addressed to
Adam...
About javacc dependency do we
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 24, 2012, at 5:06 PM, Adam Heath wrote:
On 05/24/2012 03:22 AM, Jacopo Cappellato wrote:
On May 24, 2012, at 9:04 AM, Jacques Le Roux wrote:
From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com
On May 23, 2012, at 9:25
How about defining a test sql statement in entityegine.xml which could
be specific to DBMS. For example 'select * from dual in oracle and
MySQL, Select 1 in PostgreSQL. Idea is to use the DBMS specific SQL
and make it configurable in the entityengine.xml so that it can be
configured while
The Buildbot has detected a new failure on builder ofbiz-trunk while building
ASF Buildbot.
Full details are available at:
http://ci.apache.org/builders/ofbiz-trunk/builds/3101
Buildbot URL: http://ci.apache.org/
Buildslave for this Build: portunus_ubuntu
Build Reason: scheduler
Build Source
I did the upgrade in rev. 1342326; tests pass and the system seems to work
properly (but I did a cursory review of applications).
Please let me know if you see/experience any issues and I will fix them.
Regards,
Jacopo
On May 23, 2012, at 6:12 PM, Jacopo Cappellato wrote:
Yeah
I got it
The Buildbot has detected a restored build on builder ofbiz-trunk while
building ASF Buildbot.
Full details are available at:
http://ci.apache.org/builders/ofbiz-trunk/builds/3102
Buildbot URL: http://ci.apache.org/
Buildslave for this Build: portunus_ubuntu
Build Reason: scheduler
Build
Hi Raj,
Good idea, I had the same, please re-read the thread ;o)
Cheers
Jacques
From: Rajbir Saini rajbsa...@yahoo.com
How about defining a test sql statement in entityegine.xml which could be specific to DBMS. For example 'select * from dual in
oracle and MySQL, Select 1 in PostgreSQL. Idea
Thanks Adrian
Jacques
From: Adrian Crum adrian.c...@sandglass-software.com
On 5/20/2012 10:01 AM, Jacques Le Roux wrote:
Quick questions (seems that there is a lack of internal documentation
to say the least), there are not only addressed to Adam...
About javacc dependency do we really need
From: Adam Heath doo...@brainfood.com
On 05/24/2012 10:18 AM, Adam Heath wrote:
On 05/24/2012 08:15 AM, Adrian Crum wrote:
On 5/20/2012 10:01 AM, Jacques Le Roux wrote:
Quick questions (seems that there is a lack of internal
documentation to say the least), there are not only addressed to
On 05/24/2012 04:05 PM, Jacques Le Roux wrote:
From: Adam Heath doo...@brainfood.com
On 05/24/2012 10:18 AM, Adam Heath wrote:
On 05/24/2012 08:15 AM, Adrian Crum wrote:
On 5/20/2012 10:01 AM, Jacques Le Roux wrote:
Quick questions (seems that there is a lack of internal
documentation to say
From: Adam Heath doo...@brainfood.com
On 05/24/2012 04:05 PM, Jacques Le Roux wrote:
From: Adam Heath doo...@brainfood.com
On 05/24/2012 10:18 AM, Adam Heath wrote:
On 05/24/2012 08:15 AM, Adrian Crum wrote:
On 5/20/2012 10:01 AM, Jacques Le Roux wrote:
Quick questions (seems that there is
From: Jacques Le Roux jacques.le.r...@les7arts.com
From: Adam Heath doo...@brainfood.com
On 05/24/2012 04:05 PM, Jacques Le Roux wrote:
From: Adam Heath doo...@brainfood.com
On 05/24/2012 10:18 AM, Adam Heath wrote:
On 05/24/2012 08:15 AM, Adrian Crum wrote:
On 5/20/2012 10:01 AM, Jacques
25 matches
Mail list logo