Re: Re: fetching on joined table

2011-04-14 Thread naneon . raymond
ooking for ways and John gave me a way Message du : 13/04/2011 De : "John Huss " A : Copie à : naneon.raym...@neuf.fr, webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table IF your data is read-only and you really, really want

Re: fetching on joined table

2011-04-13 Thread John Huss
IF your data is read-only and you really, really want to use a custom SQL statement, then it's ok to fetch raw rows and set the SQL using a hint: String sqlQuery = ... NSMutableDictionary hints = new NSMutableDictionary(); hints.setObjectForKey( sqlQuery, EODatabaseConte

Re: fetching on joined table

2011-04-13 Thread Chuck Hill
>> >> >> Message du : 12/04/2011 >> De : "Chuck Hill " >> A : naneon.raym...@neuf.fr >> Copie à : webobjects-dev@lists.apple.com >> Sujet : Re: fetching on joined table >> >> >> Hi Ray, >>

Re: fetching on joined table

2011-04-13 Thread Chuck Hill
l " > A : naneon.raym...@neuf.fr > Copie à : webobjects-dev@lists.apple.com > Sujet : Re: fetching on joined table > > > Hi Ray, > > WebObjects is not going to generate SQL like that for you (maybe it is > possible, but it would be very difficult). I think that yo

Re: fetching on joined table

2011-04-13 Thread Joe Little
ton. > > Thanks > > Ray > > > > > Message du : 12/04/2011 > De : "Chuck Hill " > A : naneon.raym...@neuf.fr > Copie à : webobjects-dev@lists.apple.com > Sujet : Re: fetching on joined table > > > Hi Ray, > > W

Re: Re: fetching on joined table

2011-04-12 Thread naneon . raymond
" A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table Hi Ray, WebObjects is not going to generate SQL like that for you (maybe it is possible, but it would be very difficult).  I think  that you have two choices: 1. Use views 2. Think an

Re: fetching on joined table

2011-04-12 Thread Chuck Hill
n_univ >prd_univ=vtp.prd_fin > ),'N') as IS_STUDENT_TRANSFERED > FROM gest_uv.VUE_PROFIL_PARCOURS vtp, > gerry.diplome d > WHERE vtp.diplome_$c = d.diplome_$c > order by prd_debut, prd_fin; > > So I must fetch on view vue_profil_parcours, dip

Re: Re: fetching on joined table

2011-04-12 Thread naneon . raymond
tdent, teacher so on... I want a example code How to translate this sql request or what the best practice in WebObjects in this situation? To fast forward in my apps, I create view every time when I want to display this kind of information. This allows me to browse my data in an accurate in WebObjects.

Re: fetching on joined table

2011-04-11 Thread Chuck Hill
t; De : "Chuck Hill " > A : naneon.raym...@neuf.fr > Copie à : webobjects-dev@lists.apple.com > Sujet : Re: fetching on joined table > > > Hello Ray, > > > On Apr 8, 2011, at 5:16 PM, naneon.raym...@neuf.fr wrote: > >> Hi, >> >> I'm ne

Tr: Re: Re: fetching on joined table

2011-04-11 Thread naneon . raymond
sql request on database and fetching on view  in my model? Thanks for your help. Ray Message du : 11/04/2011 De : "Chuck Hill " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table Hello Ray, O

Re: Re: fetching on joined table

2011-04-11 Thread naneon . raymond
sql request on database and fetching on view  in my model? Thanks for your help. Ray Message du : 11/04/2011 De : "Chuck Hill " A : naneon.raym...@neuf.fr Copie à : webobjects-dev@lists.apple.com Sujet : Re: fetching on joined table Hello Ray, O

Re: fetching on joined table

2011-04-10 Thread Chuck Hill
Hello Ray, On Apr 8, 2011, at 5:16 PM, naneon.raym...@neuf.fr wrote: > Hi, > > I'm newbie on WebObjects and I have big problem to fetching on joined table. > Example : > I have my SQL like that : A good rule with WebObjects is "If you are thinking about SQL, you are

fetching on joined table

2011-04-08 Thread naneon . raymond
Hi, I'm newbie on WebObjects and I have big problem to fetching on joined table. Example : I have my SQL like that : select a.id b.id as ID, c.option as option, decode(d.no, 1, 'one', 2, 'two', 'unknow') as order from ta a, tb b, tc c, td d where c.op