Re: svn commit: r835637 - in /ofbiz/trunk/framework/entity: build.xml src/org/ofbiz/entity/sql/ src/org/ofbiz/entity/sql/Parser.jjt src/org/ofbiz/entity/sql/SQLSelect.java

[Scott Gray]

I'd be careful with the limit/offset, support tends to vary among vendors, e.g. http://blogs.sun.com/kah/entry/derby_10_5_preview_fetch

Regards
Scott

On 13/11/2009, at 12:43 PM, Adam Heath wrote:

I like the concept, but to be honest I have to deal with raw sql so rarely these days that given the choice I probably wouldn't use it.

Scott Gray wrote:

Hi Adam,

What exactly does this do?

In a nutshell, and just to get you guys all excited and wet, here's
the string I've been testing this with:
==
select
       a.*,
       b.firstName,
       b.lastName
FROM
       Party a JOIN Person b ON a.partyId = b.partyId
WHERE
       a.partyId='foo'
OFFSET 5
LIMIT 10
;
==

ps: My previous versions of this were based on an oracle grammar, that
had no real license applied.  This new version I wrote completely from
scratch today, based on my knowledge of javacc/jjtree, and postgres
sql syntax.

smime.p7s
Description: S/MIME cryptographic signature