You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Truyen Vu <tv...@seattle.telecomsys.com> on 2003/12/20 00:13:34 UTC
test posting only
test posting only
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Dynamic bean in Torque
Posted by "Frans Thamura, Intercitra" <ja...@intercitra.com>.
Hi All,
Is it possible to make a dynamic bean, so the set/get method is
different in every action?
1 schema, multiple dynamix beans,
Frans
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Source Code Tutorial for Torque
Posted by "Frans Thamura, Intercitra" <ja...@intercitra.com>.
I use TDK now, will try use Torque only in the future.
got some issue, but I send an email outside this email.
Sonu Vijay wrote:
>If you are just want to learn the basics, check out
>the article in the References sections. It gives you
>the full source code to work with MySQL.
>
>--- "Frans Thamura, Intercitra" <ja...@intercitra.com>
>wrote:
>
>
>>Hi All,
>>
>>I need a full source code of tutorial in torque
>>website. Using MySQL.
>>
>>Anyone have it?
>>
>>Frans
>>
>>
>>
>>
>---------------------------------------------------------------------
>
>
>>To unsubscribe, e-mail:
>>torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail:
>>torque-user-help@db.apache.org
>>
>>
>>
>
>
>__________________________________
>Do you Yahoo!?
>Free Pop-Up Blocker - Get it now
>http://companion.yahoo.com/
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>
>
>
--
Regards,
Frans Thamura <fr...@intercitra.com>
Chief Technology Officer
Intercitra Innovation Center
We help you manage and control
http://www.intercitra.com
HP: +62 - 855 - 7888 - 699
Address:
Cempaka Putih Tengah II Blok C No. 21
Jakarta Utara - Indonesia
Telp: +62 21 4260933
Welcome to Emotional Transformation Century.
---------- www.jug.or.id -----------
-------------------------------------
Bergabunglah dengan 3 juta Programmer Java diseluruh dunia dengan
berbergabung ke JUG Indonesia.
Untuk subscribe email aja ke jug-indonesia-subscribe@yahoogroups.com
atau kunjungi http://www.jug.or.id
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Complex SQL
Posted by Sonu Vijay <so...@yahoo.com>.
Hi,
Is any one here using Torque Criteria to make or
replace Complex SQL queries like the following one. Is
it suggested to convert such complex queries to
Criteria or should that be run just as an SQL using
Torque generated classes:
Thanks
Vijay
------------------------------------------------------
select
m.*,d.SIEBEL_ERROR_CODE
from
ASDAT1.MDL1 m join ASDAT1.ADDRMST a
on m.COMPANY_CODE = a.COMPANY_CODE
and m.DLR_NO = a.DLR_NO
left outer join SIEBELSOAP.DEALERSHIP d
on m.COMPANY_CODE = d.COMPANY_CODE
and m.DLR_NO = d.DLR_NO
left outer join ASODBC.DLRLGL l
on m.COMPANY_CODE = l.COMPANY_CODE
and m.DLR_NO = l.DLR_NO
where
a.ADDRESS_TYPE = ' '
and a.ADDRESS_TYPE_SEQ = 1
and
(
d.SIEBEL_ERROR_CODE <> ' '
or d.LAST_TRANSMISSION_TIMESTAMP <
m.LAST_UPDATED_TIMESTAMP
and (
d.STATUS_CODE <> m.STATUS_CODE
or d.RECORD_TYPE <> m.RECORD_TYPE
or d.LEVEL_2 <> m.LEVEL_2
or d.LEVEL_3 <> m.LEVEL_3
or d.B_S_DLR <> m.B_S_DLR
or d.ORG_7 <> m.ORG_7
or d.ORG_10 <> m.ORG_10
or d.USER_GROUP_CODE <> m.USER_GROUP_CODE
or d.LABOR_RATE <> m.LABOR_RATE
or d.CANCEL_DATE <> m.CANCEL_DATE
or l.LEGAL_NAME is null
and d.NAME_ADDRESS_1 <> a.NAME_ADDRESS_1
or l.LEGAL_NAME is not null
and d.LEGAL_NAME <> l.LEGAL_NAME
or l.DBA is null
and d.NAME_ADDRESS_2 <> a.NAME_ADDRESS_2
or l.DBA is not null
and d.DBA <> l.DBA
or d.NAME_ADDRESS_3 <> a.NAME_ADDRESS_3
or d.CITY <> a.CITY
or d.STATE_NAME <> a.STATE_NAME
or d.ZIP_CODE <> a.ZIP_CODE
or d.COUNTRY_CODE <> a.COUNTRY_CODE
or d.PHONE_NO <> a.PHONE_NO
or d.FAX_NO <> a.FAX_NO
or d.EMAIL_ADDRESS <> a.EMAIL_ADDRESS
)
) or (
d.LAST_TRANSMISSION_TIMESTAMP is null
and m.RECORD_TYPE in ( ' ', 'I', 'E' )
and m.COMPANY_CODE || substring( m.DLR_NO, 1, 1 ) in
( '101','102','105','109','151','154','159' )
and ( m.STATUS_CODE <> '2'
or exists (
select *
from SIEBELSOAP.CANCELLEDD c
where c.COMPANY_CODE = m.COMPANY_CODE
and c.cancelled_dealer = m.dlr_no
)
)
)
order by
m.COMPANY_CODE,
m.DLR_NO
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Source Code Tutorial for Torque
Posted by Sonu Vijay <so...@yahoo.com>.
If you are just want to learn the basics, check out
the article in the References sections. It gives you
the full source code to work with MySQL.
--- "Frans Thamura, Intercitra" <ja...@intercitra.com>
wrote:
> Hi All,
>
> I need a full source code of tutorial in torque
> website. Using MySQL.
>
> Anyone have it?
>
> Frans
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
>
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Source Code Tutorial for Torque
Posted by "Frans Thamura, Intercitra" <ja...@intercitra.com>.
Hi All,
I need a full source code of tutorial in torque website. Using MySQL.
Anyone have it?
Frans
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org