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

Re: customers email list

here is the two line script I use to get the contact emails for my account ABC

#!/bin/bash

psql -c "select contact from eca_to_contact where contact_class_id=15;" ABC postgres


--
Regards,
Bill Ott

Cell: 919-434-7589
Email: Mailto:..hidden..
Website: http://www.theotts.org
Profile: http://www.linkedin.com/in/wbott
On 08/28/2013 05:11 AM, Pongrácz István wrote:

The problem that I think the developers punted on here is that one customer can have multiple phone numbers. How should the table present cases like that?

I agree that it might be practical to list contact details specifically in a search/ table.

Bye,

Erik.

 

Sure, I realized that the new contact storage uses several tables and the relation between could be very difficult to track.

Like Company - Credit account - Contacts, 1 - N - M, like a tree.

Bye,

István



------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk


_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users