db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Todd Carmichael <to...@concur.com>
Subject Problems with createOracleLimitOffsetQuery
Date Wed, 22 Oct 2003 04:45:05 GMT
Has anyone had problems with this method in torque 3.1 using Oracle 9.2?
This method is generating incorrect sql (does not get past sql compiler) for
us.  

Here is the query that this method generated and is causing an ambigous
column error:

SELECT B.* FROM ( SELECT A.*, rownum AS TORQUE$ROWNUM FROM 
( SELECT CT_LEDGER.LEDGER_KEY, CT_LEDGER.AC_HIER_KEY,
CT_LEDGER.REP_HIER_KEY, CT_LEDGER.LEDGER_CODE, CT_LEDGER_LANG.LEDGER_KEY,
CT_LEDGER_LANG.LANG_CODE, CT_LEDGER_LANG.IS_LOCALIZED, CT_LEDGER_LANG.NAME 
  		 FROM CT_LEDGER, CT_LEDGER_LANG WHERE
CT_LEDGER_LANG.LANG_CODE= 'en'  AND
CT_LEDGER.LEDGER_KEY=CT_LEDGER_LANG.LEDGER_KEY ) A
		   ) B WHERE  B.TORQUE$ROWNUM <= 500;

Any help would be appreciated.

Thanks
ToddC


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message