> Glauco, can you send a small test script reproducing the error ?
>
> I'll gladly take a look at that...
>
> Cheers,
>
> Roger
>
>
Yes...
this is the example
session.query( UnitaAziendale ).order_by(Anagrafica.c.nome)
(ProgrammingError) invalid reference to FROM-clause entry for table
"anagrafica"
*HINT: Perhaps you meant to reference the table alias "anon_b3be".*
'SELECT unita_aziendale.ts_ultima_modifica AS
unita_aziendale_ts_ultima_modifica, unita_aziendale.id AS
unita_aziendale_id, unita_aziendale.id_anagrafica AS
unita_aziendale_id_anagrafica, unita_aziendale.id_operatore AS
unita_aziendale_id_operatore, unita_aziendale.data_inizio AS
unita_aziendale_data_inizio, unita_aziendale.bdn_data_ultima_modifica AS
unita_aziendale_bdn_data_ultima_modifica, unita_aziendale.bdn_id AS
unita_aziendale_bdn_id, unita_aziendale.codice_struttura AS
unita_aziendale_codice_struttura, unita_aziendale.id_azienda AS
unita_aziendale_id_azienda, anon_b406.peso AS anon_b406_peso,
anon_b406.tempo AS anon_b406_tempo, anon_b406.id_unita_aziendale AS
anon_b406_id_unita_aziendale, anon_b406.data_aggiornamento AS
anon_b406_data_aggiornamento, unita_aziendale.bdn_specie AS
unita_aziendale_bdn_specie, unita_aziendale.id_precedente AS
unita_aziendale_id_precedente, unita_aziendale.bdn_flag_carne_latte AS
unita_aziendale_bdn_flag_carne_latte, unita_aziendale.data_fine AS
unita_aziendale_data_fine, unita_aziendale.stato_record AS
unita_aziendale_stato_record, anon_b3be.cod_nazionalita AS
anon_b3be_cod_nazionalita, anon_b3be.id AS anon_b3be_id,
anon_b3be.id_comune AS anon_b3be_id_comune, anon_b3be.cod_professione AS
anon_b3be_cod_professione, anon_b3be.dato_fiscale AS
anon_b3be_dato_fiscale, anon_b3be.localita AS anon_b3be_localita,
anon_b3be.telefono AS anon_b3be_telefono, anon_b3be.email AS
anon_b3be_email, anon_b3be.nome AS anon_b3be_nome, anon_b3be.tipo AS
anon_b3be_tipo, anon_b3be.cod_titolo_studio AS
anon_b3be_cod_titolo_studio, anon_b3be.indirizzo AS anon_b3be_indirizzo,
anon_b3be.id_precedente AS anon_b3be_id_precedente,
anon_b3be.cod_nazione_nascita AS anon_b3be_cod_nazione_nascita,
anon_b3be.id_comune_nascita AS anon_b3be_id_comune_nascita,
anon_b3be.stato_record AS anon_b3be_stato_record, anon_b3be.id_operatore
AS anon_b3be_id_operatore, anon_b3be.cap AS anon_b3be_cap,
anon_b3be.ts_ultima_modifica AS anon_b3be_ts_ultima_modifica,
anon_b3be.data_nascita AS anon_b3be_data_nascita \nFROM unita_aziendale
LEFT OUTER JOIN scheda_totali AS anon_b406 ON unita_aziendale.id =
anon_b406.id_unita_aziendale LEFT OUTER JOIN anagrafica AS anon_b3be ON
anon_b3be.id = unita_aziendale.id_anagrafica ORDER BY anagrafica.nome,
anon_b406.id_unita_aziendale, anon_b3be.id' {}
Anagrafica is a table implicated in the mapper UnitaAziendale, so i
expect a correct ordering, but seems SA don't consider to have aliased
during the select anagrafica as anon_b3be. When compiler add order_by
condition he use "ORDER BY anagrafica.nome" as indicated in the function.
But i'm confused now... SA tell me that he have renamed this table but
create a wrong qry...why this appens?
Thank's
Glauco
--
+------------------------------------------------------------+
Glauco Uri - Programmatore
glauco(at)allevatori.com
Sfera Carta Software(R) [EMAIL PROTECTED]
Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054
+------------------------------------------------------------+
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
