To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69495 Issue #|69495 Summary|OOo2.0.3 Request + conditionned paragraph in mailing Component|Database access Version|OOo 2.0.3 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|claudinedec
------- Additional comments from [EMAIL PROTECTED] Wed Sep 13 00:29:54 -0700 2006 ------- OOo2.0.3 database + writer ( Mailing) in mailing, using a Request with (join) I tried to use conditioned paragraphe. The behavior was not the expected one. only one paragraph was displayed, always the same for any value of the field used for the condition. I created a View with exactly the same sql source, it works perfectly following the SQL, the field used is: "T_adherent"."civilite" AS "civiliteAdherent", it can have 3 values (0,1,2) Thanks for your help. Claudine SELECT "T_parrainage"."ID" AS "IDParrainage", "T_parrainage"."filleul", "T_parrainage"."parrain", "T_parrainage"."dateDebut", "T_parrainage"."dateFin", "T_parrainage"."etat" AS "etatParrainage", "Tp_etatParrainage"."libelle" AS "etatParrainageLib", "T_eleve"."ID" AS "IDEleve", "T_eleve"."nom" AS "nomEleve", "T_eleve"."prenom" AS "prenomEleve", "T_eleve"."datenaissance" AS "dateNaissEleve", "T_eleve"."adresseFamille1", "T_eleve"."adresseFamille2", "T_eleve"."sexe" AS "sexeEleve", "T_eleve"."nomPere", "T_eleve"."prenomPere", "T_eleve"."dateEntree6", "T_eleve"."note", "T_eleve"."villeFamille", "T_eleve"."paysFamille", "T_eleve"."adr1Hebergement", "T_eleve"."adr2Hebergement", "T_eleve"."villeHebergement", "T_eleve"."paysHebergement", "T_eleve"."prenomHebergement", "T_eleve"."nomHebergement", "T_eleve"."responsable", "T_eleve"."nomResponsable", "T_eleve"."prenomResponsable", "T_eleve"."civiliteResponsable", "T_eleve"."civiliteHeberg", "T_eleve"."paranteHebergement" AS "parenteHebergement", "Tp_parenteHebergeur"."libelle", "T_adherent"."ID" AS "IDAdherent", "T_adherent"."nom" AS "nomAdherent", "T_adherent"."prenom" AS "prenomAdherent", "T_adherent"."adresse1" AS "adr1Adherent", "T_adherent"."adresse2" AS "adr2Adherent", "T_adherent"."codePostal" AS "codePostalAdherent", "T_adherent"."ville" AS "villeAdherent", "T_adherent"."pays" AS "paysAdherent", "T_adherent"."telephone" AS "telephoneAdherent", "T_adherent"."mail" AS "mailAdherent", "T_adherent"."fax" AS "faxAdherent", "T_adherent"."participeEcole", "T_adherent"."participeCollege", "T_adherent"."personne" AS "persPhyMoAdh", "T_adherent"."courrierPrefere", "T_adherent"."envoiRecuMail", "T_adherent"."civilite" AS "civiliteAdherent", "T_adherent"."telephone2", "Tp_civilite"."libelle" AS "civiliteLib", "Tp_modeCommunication"."libelle" AS "modeComLib", "T_ecole"."ID" AS "IDEcole", "T_ecole"."adr1" AS "adr1Ecole", "T_ecole"."adr2" AS "adr2Ecole", "T_ecole"."codePostal" AS "codePostalEcole", "T_ecole"."ville" AS "villeEcole", "T_ecole"."pays" AS "paysEcole", "T_ecole"."nom" AS "nomEcole", "T_ecole"."type" AS "typeEcole", "Tp_typeEcole"."libelle" AS "typeEcoleLib", "Tp_sexe"."libelle" AS "sexeEleveLib", "Tp_responsable"."libelle" AS "responsableEleveLib", "Tp_personne"."libelle" AS "personneAdherLib" FROM "T_parrainage" "T_parrainage" JOIN "T_eleve" "T_eleve" ON "T_parrainage"."filleul" = "T_eleve"."ID" LEFT OUTER JOIN "T_scolarite" "T_scolarite" ON "T_eleve"."ID" = "T_scolarite"."filleul" LEFT OUTER JOIN "T_ecole" "T_ecole" ON "T_scolarite"."ecole" = "T_ecole"."ID" LEFT OUTER JOIN "Tp_typeEcole" "Tp_typeEcole" ON "T_ecole"."type" = "Tp_typeEcole"."code" LEFT OUTER JOIN "Tp_parenteHebergeur" "Tp_parenteHebergeur" ON "T_eleve"."paranteHebergement" = "Tp_parenteHebergeur"."code" LEFT OUTER JOIN "Tp_sexe" "Tp_sexe" ON "T_eleve"."sexe" = "Tp_sexe"."code" LEFT OUTER JOIN "Tp_responsable" "Tp_responsable" ON "T_eleve"."responsable" = "Tp_responsable"."code" JOIN "T_adherent" "T_adherent" ON "T_parrainage"."parrain" = "T_adherent"."ID" LEFT OUTER JOIN "Tp_civilite" "Tp_civilite" ON "T_adherent"."civilite" = "Tp_civilite"."code" LEFT OUTER JOIN "Tp_modeCommunication" "Tp_modeCommunication" ON "T_adherent"."courrierPrefere" = "Tp_modeCommunication"."code" LEFT OUTER JOIN "Tp_personne" "Tp_personne" ON "T_adherent"."personne" = "Tp_personne"."code" LEFT OUTER JOIN "Tp_etatParrainage" "Tp_etatParrainage" ON "T_parrainage"."etat" = "Tp_etatParrainage"."code" WHERE (("T_parrainage"."dateFin" >= NOW()) AND ("T_parrainage"."etat"=0) ) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]