please check your sintax...the use of '{' '}' is fundamental to allow NH
recognize it as OO reference and not a DDL2008/12/16 Gabriel Mancini de Campos <[email protected]> > > certainly tried something > > but when I make use of ILIST <Sala> > and I try to access the property should be zero, I think he's on base > and retrieves the data using the ID of the room. > > ahh I'm using HR > > > try > { > iQuery = new SimpleQuery<Sala>(QueryLanguage.Sql, > @" > select > sal.* > from Sala as sal > join Chat as cha on (sal.chat_id = > cha.id) > join StatusSala as sta on > (sal.statusSala_id = sta.id) > left outer join SalaTemp as salTmp on > (sal.id = salTmp.sala_id and salTmp.Hora > ?) > where > (sta.Id = ? or sta.Id = ?) > and cha.Id = ? > order by sal.Atendente_Id, salTmp.Hora > ", hora, StatusID.Ocupado, StatusID.Pausando, > chat.Id); > > iQuery.AddSqlReturnDefinition(typeof (Sala), "sala"); > } > catch (Exception ex) > { > throw ex; > } > return iQuery.Execute(); > > On 16 dez, 16:04, "Fabio Maulo" <[email protected]> wrote: > > aahh now is more clear; you don't need only a ON clause with FK, you want > > add an AND clause to the JOIN ON.It is an unsupported feature and we have > an > > open issue about ithttp://jira.nhibernate.org/browse/NH-514 > > > > BTW, as Gustavo said, you can use an SQL in NH-stylehttp:// > nhforge.org/doc/nh/en/index.html#manipulatingdata-nativesql > > until we don't have the HQL-AST working. > > > > 2008/12/16 Gabriel Mancini de Campos <[email protected]> > > > > > > > > > > > > > Hi Fabio > > > > > thanks for your answer, how to i put this explicit in my criteria ?? > > > this is the SQL generate from NH. > > > > > see in left outer join SalaTemp my problem.. > > > > > select > > > sala0_.Id as Id13_0_ > > > , salatemp3_.Id as Id20_1_ > > > , sala0_.Numero as Numero13_0_ > > > , sala0_.Digitando as Digitando13_0_ > > > , sala0_.Inicio as Inicio13_0_ > > > , sala0_.Fim as Fim13_0_ > > > , sala0_.Atendente_Id as Atendente6_13_0_ > > > , sala0_.Supervisor_Id as Supervisor7_13_0_ > > > , sala0_.Protocolo as Protocolo13_0_ > > > , sala0_.ProtocoloInterno as Protocol9_13_0_ > > > , sala0_.Comentario as Comentario13_0_ > > > , sala0_.chat_id as chat11_13_0_ > > > , sala0_.statusSala_id as statusSala12_13_0_ > > > , sala0_.atendido_id as atendido13_13_0_ > > > , sala0_.grauSatisfacao_id as grauSat14_13_0_ > > > , salatemp3_.Autor as Autor20_1_ > > > , salatemp3_.Frase as Frase20_1_ > > > , salatemp3_.Hora as Hora20_1_ > > > , salatemp3_.Reservado as Reservado20_1_ > > > , salatemp3_.sala_id as sala6_20_1_ > > > , salatemp3_.sala_id as sala6_0__ > > > , salatemp3_.Id as Id0__ > > > from > > > Sala sala0_ > > > inner join Chat chat1_ on sala0_.chat_id=chat1_.Id > > > inner join StatusSala statussala2_ on > > > sala0_.statusSala_id=statussala2_.Id > > > left outer join SalaTemp salatemp3_ on > sala0_.Id=salatemp3_.sala_id > > > [ and salatemp3_.hora < 63365027317266 ] <- i need put this in my > > > criteria > > > where > > > ((statussala2_.Id=3 )or(statussala2_.Id=2 )) > > > and(chat1_.Id=742 ) > > > > > On 16 dez, 15:33, "Fabio Maulo" <[email protected]> wrote: > > > > Limitation? I know some RDBMS where put the clause in the WHERE of an > > > > implicit JOIN or in the ON of an explicit JOIN don't cause any kind > of > > > > problems.BTW you can use an explicit join, in your query, if you want > the > > > ON > > > > clause for FKs. > > > > > > 2008/12/16 Gabriel Mancini de Campos <[email protected]> > > > > > > > Hello to all, I am new to list, and sorry if my question is very > > > > > primary. > > > > > > > Guys, I found something very bad. see this: > > > > > if you need to create a channel find a model to generate a > > > > > SQL type: LEFT > > > > > OUTER JOIN ON (AND A.pk B.fk Some Field == Valo) <- this field is > not > > > > > generated in the ON clause, but in WHERE, and I think this is a > > > > > limitation of NHibernate! > > > > > Does anyone have any idea how I can work around this problem? > > > > > > -- > > > > Fabio Maulo > > > > -- > > Fabio Maulo > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
