sql-ledger-users — SQL-Ledger users

Fixing Inventory/Invoicing error

[Ray <mai...@so...>]

I managed to enter the wrong part # on a customer invoice and didn't notice
until after I had posted it.  I then went back to that invoice number and
changed the part to the correct one and posted it again however my inventory
didn't get adjusted acordingly.  What do I do now and how do I avoid this in
the future?

-- 
Ray

Re: DBD::Pg...what I need?

[Nicolas L. <nla...@pe...>]

The Zombie processes is exactly what happens. You seem to know a little more
about describing this problem than I. Could you let Dieter know of this
problem?

Thanks,
Nick
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Monday, August 06, 2001 2:55 PM
Subject: Re: DBD::Pg...what I need?


> On Mon, 6 Aug 2001, Nicolas Lafferty wrote:
>
> > Sounds good. Thanks. I'll be watching the list for a post from you then
> >
> > Thanks,
> >
> > Nick
>
> Nick -
>
> As you noted, admin.pl works fine and I created an account for myself.
> However, when I try to login in Netscape there is no stderr offered and
> the connection never happens...
>
> The story is different, in lynx.  Here is the stderror I get:
> Odd number of elements in hash list at ./fileio.pl line 142 <FD> chunk 12.
>
> I also get this:
> Processing request from 127.0.0.1:23672
>
> But the process never finishes.  In fact, dnhttpd spawns a legion of
> zombie processes.  Is this what you experienced?
>
> If so, we should report the problem to Dieter.
> I'll look at the scripts and see if there is a quick fix in the interim.
>
> Tom
>
> > ----- Original Message -----
> > From: "Thomas Good" <to...@ad...>
> > To: <sql...@li...>
> > Sent: Thursday, August 02, 2001 5:00 PM
> > Subject: Re: DBD::Pg...what I need?
> >
> >
> > > On Thu, 2 Aug 2001, Nicolas Lafferty wrote:
> > >
> > > > Yep, All the tables are in place. I'm using the included. dnhttpd
server
> > in
> > > > my home directory.
> > >
> > > Ok, I've never used this as I run apache.  So I'll have a look.
> > > Give me some time, I'll have to stick it on a test box and fire it
> > > up.  I'll get back to ya.
> > >
> > > --------------------------------------------------------------------
> > >                SVCMC - Center for Behavioral Health
> > > --------------------------------------------------------------------
> > > Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> > > Programmer/Analyst                              Phone:  718-354-5528
> > > Residential Services                            Mobile: 917-282-7359
> > > --------------------------------------------------------------------
> > > /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> > > --------------------------------------------------------------------
> > >
> > >
> >
> >
>
>
> --------------------------------------------------------------------
>                SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-354-5528
> Residential Services                            Mobile: 917-282-7359
> --------------------------------------------------------------------
> /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> --------------------------------------------------------------------
>
>

RE: SQL Errors on Trial Balance

[Wesley <wsh...@qx...>]

I want to clarify to Jijo and anyone else interested in fixing up the
SQL statments for PostgreSQL 7.1:  the change in behaviour with 7.1
affects the use of table identifiers with fields in the ORDER BY clause
of UNION SQL statements.  Outside of UNION statement ORDER BY clauses,
table identifiers are still perfectly fine, and often necessary.  

I think they're actually more compliant with the SQL standard now.  The
reason is that the ORDER BY has to be performed after all the tables
have been merged via UNION; field names in the ORDER BY clause should be
the field names that will be in the query's final output, as opposed to
table.fieldnames from any of the individual SELECT statements that got
merged together.

Hopefully this will help narrow the search for queries that need to be
adjusted.


-- 
Wes Sheldahl
wsh...@qx...

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Mon, 6 Aug 2001, Nicolas Lafferty wrote:

> Sounds good. Thanks. I'll be watching the list for a post from you then
> 
> Thanks,
> 
> Nick

Ok Nick, got this going on two boxes.  On the newer box (linux kernel
2.2.19) running Perl 5.6.1 I get no complaints at all and can access
the program both locally and remotely (http://999.999.999.999:8000)

On the older box I had to comment out a couple of calls to sub routines
that had syntax perl 5.004_03 found objectionable.  Once I did this
it started without complaint and ran fine.

Basically this guy (Doug Neal) is using syntax like:  
print $FH " blah "  foreach (keys %hash);
and my old version of perl barfs on this.

The other problem might be your config settings in nick.config.
This file creates the connect string to access Pg and if there are
any values that don't work for Pg we are out of luck.

Send me your output from 'perl -v' and the nick.config file from
sql-ledger/users.  We should have you on the road pretty quick.

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Mon, 6 Aug 2001, Nicolas Lafferty wrote:

> Sounds good. Thanks. I'll be watching the list for a post from you then
> 
> Thanks,
> 
> Nick

Nick - 

As you noted, admin.pl works fine and I created an account for myself.
However, when I try to login in Netscape there is no stderr offered and
the connection never happens...

The story is different, in lynx.  Here is the stderror I get:
Odd number of elements in hash list at ./fileio.pl line 142 <FD> chunk 12.

I also get this:
Processing request from 127.0.0.1:23672

But the process never finishes.  In fact, dnhttpd spawns a legion of
zombie processes.  Is this what you experienced?

If so, we should report the problem to Dieter.
I'll look at the scripts and see if there is a quick fix in the interim.

Tom 

> ----- Original Message -----
> From: "Thomas Good" <to...@ad...>
> To: <sql...@li...>
> Sent: Thursday, August 02, 2001 5:00 PM
> Subject: Re: DBD::Pg...what I need?
> 
> 
> > On Thu, 2 Aug 2001, Nicolas Lafferty wrote:
> >
> > > Yep, All the tables are in place. I'm using the included. dnhttpd server
> in
> > > my home directory.
> >
> > Ok, I've never used this as I run apache.  So I'll have a look.
> > Give me some time, I'll have to stick it on a test box and fire it
> > up.  I'll get back to ya.
> >
> > --------------------------------------------------------------------
> >                SVCMC - Center for Behavioral Health
> > --------------------------------------------------------------------
> > Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> > Programmer/Analyst                              Phone:  718-354-5528
> > Residential Services                            Mobile: 917-282-7359
> > --------------------------------------------------------------------
> > /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> > --------------------------------------------------------------------
> >
> >
> 
> 


--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Re: SQL errors on Trial Balance

[Dieter S. <dsi...@sq...>]

There are a few more of this type of statement in IR, IS and RP.pm

The code works on PostgreSQL 7.0 Looks like 7.1 is a bit more picky and
doesn't like table identifiers. It's logical though, there can only be one
column with one name so the table identifier is redundant, BUT, .......


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Mon, 6 Aug 2001, Federico Sevilla III wrote:

> On Mon, 6 Aug 2001 at 13:42, Federico Sevilla III wrote:
> > ERROR:  ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of
> > the result columns SELECT chart.accno, description, type, SUM(CASE
> > WHEN amount < 0 THEN -amount ELSE 0 END) AS debit, SUM(CASE WHEN
> > amount > 0 THEN amount ELSE 0 END) AS credit FROM chart, acc_trans
> > WHERE chart.accno = acc_trans.accno AND true GROUP BY chart.accno,
> > description, type UNION SELECT chart.accno, description, type, 0.0 as
> > debit, 0.0 as credit FROM chart, acc_trans WHERE chart.type = 'H'
> > ORDER BY chart.accno
> 
> I decided to stop crying (I cry too often) and give back to the community.
> Tried the above statement in psql without the ORDER BY and noted that at
> least on PostgreSQL 7.1.2 which I have the chart.accno will become accno.
> So the following SELECT statement will work as verified when run from
> psql:
> 
> SELECT chart.accno, description, type, SUM(CASE WHEN amount < 0 THEN
> -amount ELSE 0 END) AS debit, SUM(CASE WHEN amount > 0 THEN amount ELSE 0
> END) AS credit FROM chart, acc_trans WHERE chart.accno = acc_trans.accno
> AND true GROUP BY chart.accno, description, type UNION SELECT chart.accno,
> description, type, 0.0 as debit, 0.0 as credit FROM chart, acc_trans WHERE
> chart.type = 'H' ORDER BY accno;
> 
> Only the ORDER BY changed (chart.accno --> accno).
> 
> I'm digging through the Perl code to see what changes will be needed. I've
> never read the SQL Ledger code so this part may take awhile. If someone
> beats me to this please let me know what diffs to do. :)
> 
> In the meantime, grep is my friend. ;>
> 
>  --> Jijo
> 
> --
> Federico Sevilla III  :: ji...@le...
> Network Administrator :: The Leather Collection, Inc.
> GnuPG Key: <http://www.leathercollection.ph/jijo.gpg>
> 
> 
> 
> 

Re: DBD::Pg...what I need?

[Nicolas L. <nla...@pe...>]

Sounds good. Thanks. I'll be watching the list for a post from you then

Thanks,

Nick
----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Thursday, August 02, 2001 5:00 PM
Subject: Re: DBD::Pg...what I need?


> On Thu, 2 Aug 2001, Nicolas Lafferty wrote:
>
> > Yep, All the tables are in place. I'm using the included. dnhttpd server
in
> > my home directory.
>
> Ok, I've never used this as I run apache.  So I'll have a look.
> Give me some time, I'll have to stick it on a test box and fire it
> up.  I'll get back to ya.
>
> --------------------------------------------------------------------
>                SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-354-5528
> Residential Services                            Mobile: 917-282-7359
> --------------------------------------------------------------------
> /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> --------------------------------------------------------------------
>
>

Re: SQL errors on Trial Balance

[Federico S. I. <ji...@le...>]

On Mon, 6 Aug 2001 at 14:01, Federico Sevilla III wrote:
> I'm digging through the Perl code to see what changes will be needed.
> I've never read the SQL Ledger code so this part may take awhile. If
> someone beats me to this please let me know what diffs to do. :)

I did a quick and dirty hack to SL/RP.pm, changing "ORDER BY chart.accno"
to "ORDER BY accno" and it works. I noticed, though, that a number of
other functions use "ORDER BY chart.accno". I didn't change these. I just
changed the line that didn't work for me, lest I wreak more havoc with
code I'm not familiar with.

Has anyone done rigorous testing with PostgreSQL v7.1.x? This is an
interesting situation, I think.

 --> Jijo

--
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://www.leathercollection.ph/jijo.gpg>

Re: SQL errors on Trial Balance

[Federico S. I. <ji...@le...>]

On Mon, 6 Aug 2001 at 13:42, Federico Sevilla III wrote:
> ERROR:  ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of
> the result columns SELECT chart.accno, description, type, SUM(CASE
> WHEN amount < 0 THEN -amount ELSE 0 END) AS debit, SUM(CASE WHEN
> amount > 0 THEN amount ELSE 0 END) AS credit FROM chart, acc_trans
> WHERE chart.accno = acc_trans.accno AND true GROUP BY chart.accno,
> description, type UNION SELECT chart.accno, description, type, 0.0 as
> debit, 0.0 as credit FROM chart, acc_trans WHERE chart.type = 'H'
> ORDER BY chart.accno

I decided to stop crying (I cry too often) and give back to the community.
Tried the above statement in psql without the ORDER BY and noted that at
least on PostgreSQL 7.1.2 which I have the chart.accno will become accno.
So the following SELECT statement will work as verified when run from
psql:

SELECT chart.accno, description, type, SUM(CASE WHEN amount < 0 THEN
-amount ELSE 0 END) AS debit, SUM(CASE WHEN amount > 0 THEN amount ELSE 0
END) AS credit FROM chart, acc_trans WHERE chart.accno = acc_trans.accno
AND true GROUP BY chart.accno, description, type UNION SELECT chart.accno,
description, type, 0.0 as debit, 0.0 as credit FROM chart, acc_trans WHERE
chart.type = 'H' ORDER BY accno;

Only the ORDER BY changed (chart.accno --> accno).

I'm digging through the Perl code to see what changes will be needed. I've
never read the SQL Ledger code so this part may take awhile. If someone
beats me to this please let me know what diffs to do. :)

In the meantime, grep is my friend. ;>

 --> Jijo

--
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://www.leathercollection.ph/jijo.gpg>

SQL errors on Trial Balance

[Federico S. I. <ji...@le...>]

Hi everyone,

Attempting to do view the Trial Balance on an installation of SQL Ledger
1.4.13 results in the following error:

-----[ Error Message ]-----
Error!

ERROR:  ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the
result columns SELECT chart.accno, description, type, SUM(CASE WHEN amount
< 0 THEN -amount ELSE 0 END) AS debit, SUM(CASE WHEN amount > 0 THEN
amount ELSE 0 END) AS credit FROM chart, acc_trans WHERE chart.accno =
acc_trans.accno AND true GROUP BY chart.accno, description, type UNION
SELECT chart.accno, description, type, 0.0 as debit, 0.0 as credit FROM
chart, acc_trans WHERE chart.type = 'H' ORDER BY chart.accno
-----[ End Error Message]-----

This is a brand new setup that is being evaluated by our accounting
manager, with test information already in (at first I thought it was maybe
because we didn't have test info). All other reports work fine. The
database schema is supposed to be correct. I used the SQL "script"
provided. This error persists whether a date range is put or not.

Help, please. What could be wrong?

 --> Jijo

--
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://www.leathercollection.ph/jijo.gpg>

Re: (no subject)

[Dieter S. <dsi...@sq...>]

The taxes will only show up on an invoice if there is an amount.

You can't use <%if ...%> within a foreach block.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Fri, 3 Aug 2001, AJ Hettema wrote:

> Hi all,
> 
> I've been really busy lately, but I've managed to make a chart of accounts for 
> the Dutch market. I'va also translated the templates and used the Danish 
> translation as an example. the question is this, what should I do about the 
> taxes on the invoice-template. When I use the foreach string I get a tax 0% 
> and the 19% tax. When I look in the Danish templates I see they use if 
> strings. When I put those in the only thing I get is nothing at all. What did 
> they change in the underlying source to be able to use the if string.
> 
> Greetz
> Jouk
> 
> 
> 

Re: How to enter expenses and the General Ledger transections

[Steve D. <sd...@sw...>]

You enter a debit to the appropriate expense, and credit cash for the amount.

Dr.  Telephone exp.     50
Cr.  Cash(checking)             50

Wong Lian Wah wrote:

> Dear sql-ledger users,
>
> Can any one tell me how to enter expenses (like Insurance, Telephone etc.)
> and how to use the General Ledger transection part of the program?
>
> Thank You.
>
> L.W. Wong

How to enter expenses and the General Ledger transections

[Wong L. W. <won...@ya...>]

Dear sql-ledger users,

Can any one tell me how to enter expenses (like Insurance, Telephone etc.) 
and how to use the General Ledger transection part of the program?

Thank You.

L.W. Wong

Re: Calculation with more than two decimal places

[Volker H. <Vol...@av...>]

Thank you Dieter,

On Thu, 2 Aug 2001, Dieter Simader wrote:

> Your findings are correct, the prices are stored as entered and not
> rounded off.
>=20
> However when the items are listed or used on an invoice they are rounded
> off to two decimal places. There is no workaround other than changing the
> code and replacing all the sprintf("%.2f", ...) to the decimal places you
> need.
>=20
Yes - after a short look at the code we realised it and we'll change the
sprintf-formating. Perhaps this should be something conf=EDgurable in the
users settings in further sql-ledger-releases?!

Volker

--
         Uni Siegen . Medienzentrum ** Vol...@av...
          phone: +49(0)271/740 2282 ** fax: +49(0)271/740 2526
     http://www.avmz.uni-siegen.de/ ** http://www.online-h.de/

(no subject)

[AJ H. <Ig...@ec...>]

Hi all,

I've been really busy lately, but I've managed to make a chart of accounts for 
the Dutch market. I'va also translated the templates and used the Danish 
translation as an example. the question is this, what should I do about the 
taxes on the invoice-template. When I use the foreach string I get a tax 0% 
and the 19% tax. When I look in the Danish templates I see they use if 
strings. When I put those in the only thing I get is nothing at all. What did 
they change in the underlying source to be able to use the if string.

Greetz
Jouk

Re: Tracking the Australian GST

[David R. <ro...@sn...>]

We have used sql-ledger for many months. It takes a little thought in
configuring to make it suitable for Australian GST. We have even had a
government GST audit and the tax office saw no significant difficulties.
I demonstrated how I extracted then necessary data and they were
satisfied.

I will answer the specific question in a later message.

Adrian

Adrian Blake - ad...@sn...    http://www.snowy.net.au
Snowy Technology P/L Phone: 0407 232 978   Fax: 02 64524317
Cooma, NSW 2630, Australia

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Thu, 2 Aug 2001, Nicolas Lafferty wrote:

> Yep, All the tables are in place. I'm using the included. dnhttpd server in
> my home directory.

Ok, I've never used this as I run apache.  So I'll have a look.
Give me some time, I'll have to stick it on a test box and fire it
up.  I'll get back to ya.

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Re: DBD::Pg...what I need?

[Nicolas L. <nla...@pe...>]

Yep, All the tables are in place. I'm using the included. dnhttpd server in
my home directory.

----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Thursday, August 02, 2001 7:54 AM
Subject: Re: DBD::Pg...what I need?


> On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
>
> > Well. I ran the nifty lil script. I gave me the feedback "posgres" Does
that
> > mean that it's working fine?
>
> Roger that!  So that means that the problem lies in the web server
> itself - most likely.
>
> If you run this from a shell prompt:
>
> psql -c "\d" DBNAME
>
> where DBNAME is the name of the database into which you installed
> sql ledger, you will see table names like:  ar ap tax
> and so on.  If these tables are present then we have ruled out
> Pg and Perl DBI being the problem and we zoom in on the web server.
>
> > ----- Original Message -----
> > From: "Thomas Good" <to...@ad...>
> > To: <sql...@li...>
> > Sent: Wednesday, August 01, 2001 4:02 PM
> > Subject: Re: DBD::Pg...what I need?
> >
> >
> > > On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> > >
> > > > Well. I have DBI installed. And Pg. Still no dice. See my just
posted
> > > > Subject "Pg not the problem" on the list. Hrmph. This is driving me
> > nuts.
> > >
> > > So, I'm unclear.  Can you connect to Pg using DBI at all?
> > > If not sure save the following as test.pl, make executable (chmod 755
> > test.pl)
> > > and run it from the shell prompt: ./test.pl
> > >
> > > #!/usr/bin/perl
> > > use DBI;
> > >
> > > $dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die
> > "$DBI::errstr";
> > > $query = qq |select usename from pg_user|;
> > > $sth=$dbh->prepare($query);
> > > $sth->execute || die "$DBI::errstr";
> > > @row=$sth->fetchrow_array;
> > > $sth->finish;
> > > $dbh->disconnect;
> > >
> > > print "\n@row\n\n";
> > >
> > >
> > >
> >
> >
>
>
> --------------------------------------------------------------------
>                SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-354-5528
> Residential Services                            Mobile: 917-282-7359
> --------------------------------------------------------------------
> /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> --------------------------------------------------------------------
>
>

Re: Calculation with more than two decimal places

[Dieter S. <dsi...@sq...>]

Your findings are correct, the prices are stored as entered and not
rounded off.

However when the items are listed or used on an invoice they are rounded
off to two decimal places. There is no workaround other than changing the
code and replacing all the sprintf("%.2f", ...) to the decimal places you
need.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Thu, 2 Aug 2001, Volker Hess wrote:

> Hello,
> 
> we've done just a short test with sql-ledger and found that it accepts and
> stores product/service prices with more than two decimal places which we
> need in any case but it seems to calculate only with the first two. Is
> this right and is it possible to do some workaround?!
> 
> Thanx in advance!
> 
> Volker
> 
> 

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Wed, 1 Aug 2001, Nicolas Lafferty wrote:

> Well. I ran the nifty lil script. I gave me the feedback "posgres" Does that
> mean that it's working fine?

Roger that!  So that means that the problem lies in the web server
itself - most likely.

If you run this from a shell prompt:

psql -c "\d" DBNAME

where DBNAME is the name of the database into which you installed
sql ledger, you will see table names like:  ar ap tax
and so on.  If these tables are present then we have ruled out
Pg and Perl DBI being the problem and we zoom in on the web server.

> ----- Original Message -----
> From: "Thomas Good" <to...@ad...>
> To: <sql...@li...>
> Sent: Wednesday, August 01, 2001 4:02 PM
> Subject: Re: DBD::Pg...what I need?
> 
> 
> > On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> >
> > > Well. I have DBI installed. And Pg. Still no dice. See my just posted
> > > Subject "Pg not the problem" on the list. Hrmph. This is driving me
> nuts.
> >
> > So, I'm unclear.  Can you connect to Pg using DBI at all?
> > If not sure save the following as test.pl, make executable (chmod 755
> test.pl)
> > and run it from the shell prompt: ./test.pl
> >
> > #!/usr/bin/perl
> > use DBI;
> >
> > $dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die
> "$DBI::errstr";
> > $query = qq |select usename from pg_user|;
> > $sth=$dbh->prepare($query);
> > $sth->execute || die "$DBI::errstr";
> > @row=$sth->fetchrow_array;
> > $sth->finish;
> > $dbh->disconnect;
> >
> > print "\n@row\n\n";
> >
> >
> >
> 
> 


--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Calculation with more than two decimal places

[Volker H. <Vol...@av...>]

Hello,

we've done just a short test with sql-ledger and found that it accepts and
stores product/service prices with more than two decimal places which we
need in any case but it seems to calculate only with the first two. Is
this right and is it possible to do some workaround?!

Thanx in advance!

Volker

-- 
         Uni Siegen . Medienzentrum  **  Vol...@av...
          phone: +49(0)271/740 2282  **  fax: +49(0)271/740 2526
     http://www.avmz.uni-siegen.de/  **  http://www.online-h.de/

Re: DBD::Pg...what I need?

[Nicolas L. <nla...@pe...>]

Well. I ran the nifty lil script. I gave me the feedback "posgres" Does that
mean that it's working fine?


----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Sent: Wednesday, August 01, 2001 4:02 PM
Subject: Re: DBD::Pg...what I need?


> On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
>
> > Well. I have DBI installed. And Pg. Still no dice. See my just posted
> > Subject "Pg not the problem" on the list. Hrmph. This is driving me
nuts.
>
> So, I'm unclear.  Can you connect to Pg using DBI at all?
> If not sure save the following as test.pl, make executable (chmod 755
test.pl)
> and run it from the shell prompt: ./test.pl
>
> #!/usr/bin/perl
> use DBI;
>
> $dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die
"$DBI::errstr";
> $query = qq |select usename from pg_user|;
> $sth=$dbh->prepare($query);
> $sth->execute || die "$DBI::errstr";
> @row=$sth->fetchrow_array;
> $sth->finish;
> $dbh->disconnect;
>
> print "\n@row\n\n";
>
>
>

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Wed, 1 Aug 2001, Nicolas Lafferty wrote:

> Well. I have DBI installed. And Pg. Still no dice. See my just posted
> Subject "Pg not the problem" on the list. Hrmph. This is driving me nuts.

So, I'm unclear.  Can you connect to Pg using DBI at all?
If not sure save the following as test.pl, make executable (chmod 755 test.pl) 
and run it from the shell prompt: ./test.pl

#!/usr/bin/perl
use DBI;

$dbh = DBI->connect("dbi:Pg:dbname=template1", '', '') || die "$DBI::errstr";
$query = qq |select usename from pg_user|;
$sth=$dbh->prepare($query);
$sth->execute || die "$DBI::errstr";
@row=$sth->fetchrow_array;
$sth->finish;
$dbh->disconnect;

print "\n@row\n\n";

=?iso-8859-1?Q?Re:_DBD::Pg...what_I_need=3F?=

[<ro...@su...>]

> Well. I have DBI installed. And Pg. Still no dice. See my just posted
> Subject "Pg not the problem" on the list. Hrmph. This is driving me
> nuts.

Did you upgrade PostgreSQL?  If so you may also need to rebuild DBD-Pg.

-- Rod
http://www.sunsetsystems.com/

Re: DBD::Pg...what I need?

[Oscar B. <os...@el...>]

Nicolas,

Your issues remind me of those that I had installing SQL-ledger.
You may want to consider looking for my name (oscar buijten) in the history
of posts.
I have published all problems and solutions I found.

Good luck!

PS: be carefull with your nuts...

----- Message d'origine -----
De : "Nicolas Lafferty" <nla...@pe...>
À : <sql...@li...>
Envoyé : mercredi 1 août 2001 20:58
Objet : Re: DBD::Pg...what I need?


> Well. I have DBI installed. And Pg. Still no dice. See my just posted
> Subject "Pg not the problem" on the list. Hrmph. This is driving me nuts.
>
>
> ----- Original Message -----
> From: "Thomas Good" <to...@ad...>
> To: <sql...@li...>
> Sent: Wednesday, August 01, 2001 2:03 PM
> Subject: Re: DBD::Pg...what I need?
>
>
> > On Wed, 1 Aug 2001, Nicolas Lafferty wrote:
> >
> > > Is there a difference between DBD-Pg and DBD::Pg. I thought that they
> where
> > > the same. But if not, that's why i can't get the program working.
> > >
> > > Nick Lafferty
> >
> > Hey Nick,
> >
> > DBD::Pg looks like a fully qualified package::variable...
> >
> > DBI is the toplevel perl module for database access, it is generic.
> > Into it you plug 'drivers' that are specific to the various SQL
> > implementations.  So to run sql-ledger you'd need the DBI module
> > which is available from CPAN as:  DBI-version_number.tar.gz
> >
> > You'd also need DBD-Pg:
> > DBD-Pg is the driver used in accessing Pg from perl routines that
> > use a type of syntax similar to ESQL/C.  Not to muddy the waters
> > but Edmund Mergl has two different modules to access Pg databases
> > and DBD-Pg is the one designed for DBI that has more familiar
> > syntax...at least more familiar to me!  ;-)
> >
> > DBD::Pg is a Package Name::variable so it does not refer to a
> > downloadable module.  I expect you want a module that looks like:
> > DBD-Pg-0.95.tar.gz or something similar (newer version number perhaps).
> >
> > Cheers,
> > Tom
> >
> > --------------------------------------------------------------------
> >                SVCMC - Center for Behavioral Health
> > --------------------------------------------------------------------
> > Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> > Programmer/Analyst                              Phone:  718-354-5528
> > Residential Services                            Mobile: 917-282-7359
> > --------------------------------------------------------------------
> > /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> > --------------------------------------------------------------------
> >
> >
> >
>