[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: FW: [Phpgroupware-users] ``flat'' addressbook table...

From: Marco Gaiarin
Subject: Re: FW: [Phpgroupware-users] ``flat'' addressbook table...
Date: Fri, 18 Jun 2004 12:19:22 +0200
User-agent: Mutt/

Mandi! Marco Gaiarin
  In chel di` si favelave...

> Oh, good idea, i'm using postgres so views are supported... but is not
> viable, at least for my SQL/PG knowledge...
> I can make some correlation (join) between people and addresses, but
> when i try to join the comm infos, they are organized very different
> for a flat table, so i can extract only one information (eg, the work
> fax) for addresses.

Ok, at least for what i've to do (make the phpgw adressbook usable from
whfc HylaFax client) i've solved my problem.
I'm lucky, whfc support two tables, so i've done two view, one to
extract addresses and phone number, another to extract fax number.

I'm very happy, i attach the query in hope to be usefoul...

dott. Marco Gaiarin                                 GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''      
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  gaio(at)             tel +39-0434-842711    fax +39-0434-842797

    ... votantoniovotantoniovotantoniovotantoniovotantoniovotantonio ...
             resistenza arcobaleno contro la politica grigia


Attachment: whfc.sql
Description: Text document

reply via email to

[Prev in Thread] Current Thread [Next in Thread]