Re: [Phpgroupware-users] Hylafax

[Marco Gaiarin]

Mandi! Bob Crandell
  In chel di` si favelave...

> Am I missing something?

No. See the message attached, i've solved the problem making two views
(i'm using postgres) with the query attached.

That queries partially works, sometime list some address two time,
sometime miss some addresses... i've not debug that views very well
because our experimental hylafax server crashed and never go back. ;(

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

        Per favore, aiutate gli Stati Uniti a salvarsi dai brevetti sul
                 software, salvando innanzitutto voi stessi.
                http://punto-informatico.it/p.asp?i=52786&p=2

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

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''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  gaio(at)sv.lnf.it             tel +39-0434-842711    fax +39-0434-842797

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

                    http://www.peacelink.it/votantonio

whfc.sql
Description: Text document

_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/phpgroupware-users

--- End Message ---