Re: [Ledger-smb-devel] Employee search question for 1.3

2011-06-22 Thread John Locke
On 06/22/2011 03:26 PM, Chris Travers wrote: > On Wed, Jun 22, 2011 at 10:12 AM, John Locke wrote: >> On 06/21/2011 04:02 PM, Chris Travers wrote: >>> Hi John; >>> >>> In terms of the duplication issue can you: >>> >>> SELECT p.id as person_id, e.id as entity_id >>> FROM person p >>> JOIN en

Re: [Ledger-smb-devel] Tax account creation: how to 'detect' tax accounts?

2011-06-22 Thread John Locke
On 06/22/2011 04:15 PM, Chris Travers wrote: >> At the moment, our customers actually pay via another system >> (Drupal/Ubercart) which already does the right thing for taxes -- it >> does a call to a web service run by the State of Washington which >> returns the appropriate location code and rate

Re: [Ledger-smb-devel] Tax account creation: how to 'detect' tax accounts?

2011-06-22 Thread Chris Travers
> > At the moment, our customers actually pay via another system > (Drupal/Ubercart) which already does the right thing for taxes -- it > does a call to a web service run by the State of Washington which > returns the appropriate location code and rate. > > Basically what I need from LedgerSMB is a

Re: [Ledger-smb-devel] Exception handling in Perl or rather: non-local goto's

2011-06-22 Thread Chris Travers
On Wed, Jun 22, 2011 at 12:42 PM, Erik Huelsmann wrote: >> Can you be specific here? > > Yes: studying the pages for Try::Tiny again, their discussion of the > $@ variable is really about Perl's general "behaviour", meaning I was > misunderstanding the discussion to be specifically about Try::Tin

Re: [Ledger-smb-devel] Employee search question for 1.3

2011-06-22 Thread Chris Travers
On Wed, Jun 22, 2011 at 10:12 AM, John Locke wrote: > On 06/21/2011 04:02 PM, Chris Travers wrote: >> Hi John; >> >> In terms of the duplication issue can you: >> >> SELECT p.id as person_id, e.id as entity_id >>   FROM person p >>   JOIN   entity e ON (e.id = p.entity_id) >>  order by p.id; >> >

Re: [Ledger-smb-devel] Deployment independent coding

2011-06-22 Thread Chris Bennett
Thinking about mod_perl, I would point out that using PerlRun would give a small performance improvement, and the code would run only once. Not having to reload the interpreter every time is somewhat snappier. Of course nothing like real mod_perl. I need to look at PSGI document, have heard of i

Re: [Ledger-smb-devel] Exception handling in Perl or rather: non-local goto's

2011-06-22 Thread Erik Huelsmann
Hi Chris, On Tue, Jun 21, 2011 at 12:21 AM, Chris Travers wrote: > On Mon, Jun 20, 2011 at 2:49 PM, Erik Huelsmann wrote: >> Last weekend, I added non-local gotos using exception handling to >> replace 'exit;' calls. >> >> Today, mst showed up on IRC (coincidentally), telling me about an >> issu

Re: [Ledger-smb-devel] Employee search question for 1.3

2011-06-22 Thread John Locke
On 06/21/2011 04:02 PM, Chris Travers wrote: > Hi John; > > In terms of the duplication issue can you: > > SELECT p.id as person_id, e.id as entity_id > FROM person p > JOIN entity e ON (e.id = p.entity_id) > order by p.id; > db=> SELECT p.id as person_id, e.id as entity_id db-> FROM pers