sql-ledger-users — SQL-Ledger users

Re: [SQL-Ledger-users] Internal error?

[Thomas S. <ps...@on...>]

First off, what Distribution of Linux are you using? I had the worst
time trying to get mine to work under Mandrake 7.1 (99% Red Hat) and
fianlly gave it up. I switched to Debian. Thank God for APT! Now installing
new packages is as easy as pie. (well almost).

Secondly, make sure you've specified a driver in the users record. In
.../sql-ledger/admin/setup.cgi when editing or adding a user, at the
bottom of the screen where it asks you for the Driver, Login, Password,
etc. Pg is the driver for Postgresql. And you have to put a login name
and password for database access. (Ie. your Linux's Postgres user)

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Richard Eicher II <win...@ya...> wrote:
> When I try to log in I get this in my apache
> error log:
> 
> [Mon Feb 12 19:40:53 2001] [notice] Apache/1.3.12
> (Unix)  (Red Hat/Linux) configured -- resuming
> normal operations
> Can't connect(dbi::dbname=;host=;port=  ), no
> database driver specified and DBI_DSN env var not
> set at /home/httpd/sql-ledger/login.cgi line 66
> [Mon Feb 12 20:33:54 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
> Can't connect(dbi::dbname=;host=;port=  ), no
> database driver specified and DBI_DSN env var not
> set at /home/httpd/sql-ledger/login.cgi line 66
> [Mon Feb 12 20:38:20 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
> 
> 
> Any one run into this or know how to fix?
> I installed the DBI. But maybe I did it wrong?
> 
> Rick
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Internal error?

[Richard E. II <win...@ya...>]

no I guess I have not. I will look into that. Are
there any efforts to a how to on this? If not any
one interested it working on one?

Rick

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] Internal error?

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

Hi Richard.

This looks like you haven't set anything up yet.

Did you point your browser to http://"your
URL"/cgi-bin/sql-ledger/admin/setup.cgi so you can enter your driver,
db, host, port, etc?

You might take a look at that.
Hope that helps.
Steve

Richard Eicher II wrote:

> When I try to log in I get this in my apache
> error log:
>
> [Mon Feb 12 19:40:53 2001] [notice] Apache/1.3.12
> (Unix)  (Red Hat/Linux) configured -- resuming
> normal operations
> Can't connect(dbi::dbname=;host=;port=  ), no
> database driver specified and DBI_DSN env var not
> set at /home/httpd/sql-ledger/login.cgi line 66
> [Mon Feb 12 20:33:54 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
> Can't connect(dbi::dbname=;host=;port=  ), no
> database driver specified and DBI_DSN env var not
> set at /home/httpd/sql-ledger/login.cgi line 66
> [Mon Feb 12 20:38:20 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
>
> Any one run into this or know how to fix?
> I installed the DBI. But maybe I did it wrong?
>
> Rick
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] Internal error?

[Richard E. II <win...@ya...>]

where should this dirs be on a redhat 7.0
machine?

thanks for the help,
rick

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] Internal error?

[Wes W. <ufo...@ea...>]

Check to be sure that DBI and DBD went into the right dirs.  I had this
problem once too.  There should be an i386 dir in your perl dir and also a
site_perl/1386 dir.  I had the modules install to the site_perl one and so I
copied them to the regular 1386 one, and all was good.  If you have any
questions feel free to email.

			Good Luck,
			      Wes

On Mon, Feb 12, 2001 at 06:42:46PM -0800, Richard Eicher II wrote:
> When I try to log in I get this in my apache
> error log:
> 
> [Mon Feb 12 19:40:53 2001] [notice] Apache/1.3.12
> (Unix)  (Red Hat/Linux) configured -- resuming
> normal operations
> Can't connect(dbi::dbname=;host=;port=  ), no
> database driver specified and DBI_DSN env var not
> set at /home/httpd/sql-ledger/login.cgi line 66
> [Mon Feb 12 20:33:54 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
> Can't connect(dbi::dbname=;host=;port=  ), no
> database driver specified and DBI_DSN env var not
> set at /home/httpd/sql-ledger/login.cgi line 66
> [Mon Feb 12 20:38:20 2001] [error] [client
> 192.168.10.2] Premature end of script headers:
> /home/httpd/sql-ledger/login.cgi
> 
> 
> Any one run into this or know how to fix?
> I installed the DBI. But maybe I did it wrong?
> 
> Rick
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> 

-- 
________________________________________________________________________________
From a different solar system, many many galaxies away...

[SQL-Ledger-users] Internal error?

[Richard E. II <win...@ya...>]

When I try to log in I get this in my apache
error log:

[Mon Feb 12 19:40:53 2001] [notice] Apache/1.3.12
(Unix)  (Red Hat/Linux) configured -- resuming
normal operations
Can't connect(dbi::dbname=;host=;port=  ), no
database driver specified and DBI_DSN env var not
set at /home/httpd/sql-ledger/login.cgi line 66
[Mon Feb 12 20:33:54 2001] [error] [client
192.168.10.2] Premature end of script headers:
/home/httpd/sql-ledger/login.cgi
Can't connect(dbi::dbname=;host=;port=  ), no
database driver specified and DBI_DSN env var not
set at /home/httpd/sql-ledger/login.cgi line 66
[Mon Feb 12 20:38:20 2001] [error] [client
192.168.10.2] Premature end of script headers:
/home/httpd/sql-ledger/login.cgi


Any one run into this or know how to fix?
I installed the DBI. But maybe I did it wrong?

Rick

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] what is the change log of new 1.2.8 ?

[Thomas S. <ps...@on...>]

I just found a bug with one of the delete routines. I don't know where
it is exactly, but I went back and deleted all my dummy transactions
in the A/R and the Accounts List got out of balance. Very bad :( Then
I went and deleted all my A/P transaction so there should be nothing
in the Accounts List at all (I did not enter any G/L) and what was left
was some money in the tax account and in the A/R account. So this needs
to be fixed real bad like.

-- 
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] what is the change log of new 1.2.8 ?

[Thomas S. <ps...@on...>]

Hi again,

This time I have a question about the AR and AP concerning the difference
between adding a transaction and adding an invoice. It seems that the
only difference is that the invoices are itemized, compared to the transactions
which are just entered in total. Right? But I noticed that on the Invoice
there is no where to specify where the Amount (i.e. the subtotal) will
be posted, like there is on the Transaction. So everytime I post an invoice
it appears to be posted to the first income or expense account in the
accounts list. Shouldn't we be able to choose? This came up b/c my client
posts to different income accounts depending on whether the invoice is
taxable on not.

Thanks,
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] what is the change log of new 1.2.8 ?

[Thomas S. <ps...@on...>]

Dieter,

Just downloaded 1.2.8 and I'm wonderering if there is anything I'll need
to worry about in integrating it into my changes. The scripts I've changed
so far are the login.cgi and, slightly, the admin.cgi. Does the new version
effect these in any way?

Here are my changes, in summary, they are mostly asthetic changes, but
they do make the program a little easier to navigate. Please try out
these changes (in a dummy setup) and see what you think. I don't know
where these might conflict with 1.4 but I you could integrate these changes
I think SQL-Ledger will be well served. Thanks.

Images:

I changed the Login screen to be cleaner looking. I made a new graphic
(sql-ledger-2.png) that's curretnly a bit U.S.A. oriented but I would
like to change other characters in it to be different currency symbols
as well (currently the S in SQL is a dollar sign, but I would like a
pound symbol for the L, etc.) Unfortunately I couldn't find those symbols
in the Gimp. But its a start and I think it makes a good logo. I also
took your origonal graphic and touched it up (sql-ledger-1b.png), and
kept it on the old Version page of login.cgi. I renamed you original
graphic sql-ledger-1a.gif, but its not being used now. Also I MOVED THESE
THREE GRAPHIC FILES TO AN "images" DIRECTORY instead of having them in
the main directory, keeping in mind that in the future more graphic images
may be added and it would be good to keep them seperate. Finally, on
images, I used .png instead of .gif because .gif is not an open-source
format. And this is an open-source project! :)

Login:

You will see that I rearranged the login window a bit to bring the login
prompts closer to the top of the page. I think they are more readily
available in that position.

Menus:

I also rearranged the menus a little by taking the links in the bottom
section and moving them to the side section under a heading of Administration.
I increased the size of the side bar a little. I also renamed Version
to About, since it contains more than just the version. Rather than Accounting
at the top of the menu I put Main Menu and increased the font size one.
There were a number of places where I put in absolute font sizes instead
or relative + or - sizes, since realtive make it difficult to know what
the size will be just from the code. On the admin.cgi menu I put a "Back
to Main Menu" link under the Setup Menu header, which I increased in
size by one too. The bottom section now just contains the User's Name,
and is a little bigger to remove the scroll bar that appears to the right.
I would like to Add the current date and time to the right side of this
section, but hadn't gotten to it yet.

Finally:

For the wording changes I made I did not correct any of the translation
files. And I forgot to wrap the "locate" around a couple of place in
the login screen. These will obviously need to be done. 

Also you will notice two new main menu options, one for Sales Orders
and the other for Search Sales Orders. I'm working on the scripts for
these, and I'm fairly well along actually. For now just ignore them and
I will send them to you when I'm done.

-- 
Thomas Sawyer
ps...@on... - email



---- Dieter Simader <dsi...@sq...> wrote:
> It includes the Brazilien Portugese translation and an option to include
> fields of your choice in the AR/AP reports.
> 
> All listed in the 'what's new file'.
> http://www.sql-ledger.org/news.html
> 
> 
> 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, 9 Feb 2001, Andre Felipe Machado wrote:
> 
> > Hello,
> > Please, what is the change log of the new sql-ledger release 1.2.8
> from
> > the 1.2.7?
> > Thanks.
> > Andre Felipe Machado
> > www.techforce.com.br
> > 
> > 
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] problems again

[Thomas S. <ps...@on...>]

Check the logs in /var/log for your web server host. Probably a DBD or
DBI error. 

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Richard Eicher II <win...@ya...> wrote:
> Hello
> 
> Well I have got the permissions correct now but
> when I try to login I get an internal error check
> server logs?
> 
> What stupid thing have I done now?
> 
> thanks
> rick
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] what is the change log of new 1.2.8 ?

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

It includes the Brazilien Portugese translation and an option to include
fields of your choice in the AR/AP reports.

All listed in the 'what's new file'.
http://www.sql-ledger.org/news.html


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, 9 Feb 2001, Andre Felipe Machado wrote:

> Hello,
> Please, what is the change log of the new sql-ledger release 1.2.8 from
> the 1.2.7?
> Thanks.
> Andre Felipe Machado
> www.techforce.com.br
> 
> 

[SQL-Ledger-users] what is the change log of new 1.2.8 ?

[Andre F. M. <and...@te...>]

Hello,
Please, what is the change log of the new sql-ledger release 1.2.8 from
the 1.2.7?
Thanks.
Andre Felipe Machado
www.techforce.com.br

[SQL-Ledger-users] perl DBI 1.14 and DBD 0.95 up to date rpm

[Andre F. M. <and...@te...>]

Hello:
I found perl DBI and DBD up to date rpms at my own linux distribution=20
site:

ftp://ftp.conectiva.com.br/pub/conectiva/6.0/cd2/conectiva/RPMS/perl-DBI=
-1.14-3cl.i386.rpm

ftp://ftp.conectiva.com.br/pub/conectiva/6.0/cd2/conectiva/RPMS/perl-DBD=
-Pg-0.95-2cl.i386.rpm
They should help newbies to install the packages.... at least on rpm=20
based distributios.
I suggest to Dieter include these links at www.sql-ledger.org site. Newe=
r=20
versions will be at OTHER subdirectories. Conectiva have a special url=20
for updates ftp://atualizacoes.conectiva.com.br if I can remember. Check=
 w
ww.conectiva.com or www.conectiva.com.br=20
Good luck.
How do I unistall completely a manually installed dbd? Make unistall=20
works?
Thanks for the compreensive answers to my questions about accounting=20
standards.
Andre Felipe Machado

[SQL-Ledger-users] problems again

[Richard E. II <win...@ya...>]

Hello

Well I have got the permissions correct now but
when I try to login I get an internal error check
server logs?

What stupid thing have I done now?

thanks
rick

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

[SQL-Ledger-users] Re: sql-ledger and international accounting standards

[Andre F. M. <and...@te...>]

Hello,
I read a bit more at both aforementione sites, and www.iasc.org.uk is=20
human practice standards. Supported by big players.
And www.compassgl.org is the computer implementation standards specs=20
(derived from OMG/Corba specs) for the www.iasc.org.uk human practice=20
specs.
It is backed by IBM, Xerox, EDS and other big players at bussiness sw.
Are there other accounting standards? I think the www.iasc.org.uk is THE=
=20
standard.... Is it not?
If it is, www.compassgl.org is the computer implementation spec for it.
Sorry for these newbie questions.
Andre Felipe Machado



>>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<

No dia 08/02/01, 16:18:49, "Thomas Sawyer" <ps...@on...> escreveu o =

seguinte sobre o tema Re: [SQL-Ledger-users] sql-ledger and internationa=
l=20
accounting standards / documentation:

RE: [SQL-Ledger-users] Documentation?

[Thomas S. <ps...@on...>]

> Appologies for burdening the list with my ignorance :)

Knowledge unburdened by Ignorance is shallow; Ignorance ungiven to Knowledge
is the only kind for which to apologize.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- "Mark Tiramani" <ma...@fr...> wrote:
> Got it!!
> 
> Many thanks to Leo, Thomas, Terry and Dieter.
> 
> Appologies for burdening the list with my ignorance :)
> 
> > What you have to realize is that Debits and Credits are relative.
>  When you
> > view a bank statement, the bank uses the terms from their perspective:
>  a
> 
> Mark
> 
> Mark Tiramani
> FREDO Internet Services
> ma...@fr...
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] sql-ledger and international accounting standards / documentation

[Thomas S. <ps...@on...>]

Surly we want to comply, as best we can with International Accounting
Standards and Generally Accepted Accouting Principles. But various standards
committies have varying standards, yet most of these standards are about
Human Practice rather then to how an accounting program works. SQL-Ledger
has an A/R, A/P and a G/L, does Income Statements and Balance Sheets,
with those in place its pretty much up to you to follow standards. But
like I said, if SQL-Ledger can be improved to help facilitate standard
practices then we should do so.

-- 
Thomas Sawyer
ps...@on... - email


---- Andre Felipe Machado <and...@te...> wrote:
> Hello,
> As I am a newbie at this, what is the positioning, or compliance of
> 
> sql-ledger to COMPASS  General Ledger Facility specification ( 
> http://www.compassgl.org/newhometest/990305fr1.html , see 
> www.compassgl.org ) and the more international broad one International
> 
> Accounting Standards  Committee ® (http://www.iasc.org.uk/frame/cen2.htm
> 
> ) see www.iasc.org.uk ?
> I realized that www.compassgl.org is a subset and computational focused
> team from www.iasc.org.uk. Is it right?
> Maybe these are irrelevant questions, but it "seems" that compliance
> will 
> allow fully integration with other sw (crm, hr, pos, etc, etc) and
> or 
> attract more and more developers to help. The www.gnuenterprise.org
> is a 
> bold attempt (pre alpha stage now) to create a big enterprise package,
> 
> and MAYBE sql-ledger could integrate well with it.
> Please, some patience with these questions, as I am a newbie.....
> Thanks.
> Andre Felipe Machado
> PS: if I can remember some people is starting a documentation effort.
> Why 
> not use sourceforge resources for documentation at 
> http://sourceforge.net/projects/sql-ledger ?
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] sql-ledger and international accounting standards /documentation

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

Hi Andre.

Andre Felipe Machado wrote:

> Hello,
> As I am a newbie at this, what is the positioning, or compliance of
> sql-ledger to COMPASS  General Ledger Facility specification (
> http://www.compassgl.org/newhometest/990305fr1.html , see
> www.compassgl.org ) and the more international broad one Internatio=
nal
> Accounting Standards  Committee =AE (http://www.iasc.org.uk/frame/c=
en2.htm
> ) see www.iasc.org.uk ?

I've looked at this before and COMPASS seems to be a comprehensive li=
st of
function prototypes in C/C++ (see
http://www.compassgl.org/papers/0305x8.htm#_Toc438810673) for  accoun=
ting
software.  It would be a big project to code everything in around the=
se
prototypes.

Sql-ledger doesn't follow this spec, but I don't see why you couldn't=
 use
sql-ledger data with an application like this if it existed.

> I realized that www.compassgl.org is a subset and computational foc=
used
> team from www.iasc.org.uk. Is it right?

The EU commissioned the COMPASS project to comply with IASC accountin=
g
rules, but I don't think they are affiliated.

> Maybe these are irrelevant questions, but it "seems" that complianc=
e will
> allow fully integration with other sw (crm, hr, pos, etc, etc) and =
or
> attract more and more developers to help. The www.gnuenterprise.org=
 is a
> bold attempt (pre alpha stage now) to create a big enterprise packa=
ge,
> and MAYBE sql-ledger could integrate well with it.
> Please, some patience with these questions, as I am a newbie.....
> Thanks.

COMPASS and Gnue are great ideas, but I see very little activity on e=
ither
one.  With COMPASS, I think the idea was to get companies like People=
soft,
SAP, and Oracle, etc. to follow the spec, but I also think they faile=
d to
realize that interoperability is not conducive to the proprietary sof=
tware
business model.

Having witnessed a Peoplesoft implementation at a large US corporatio=
n, I
saw that once they get you, it would cost millions of dollars to chan=
ge to
something else.  I don't think they are going to want to make it easi=
er to
change from their software by adopting a spec like COMPASS with the o=
ther
ERP/accounting vendors.

As far as Gnue goes,  I think you drastically reduce the number of pe=
ople
who have the skills to contribute when you get into that level of
complexity.  Following the COMPASS g/l spec. could actually have the =
effect
of scaring people off because this is going to be such a huge project=
, and
so little is currently done.

I like Sql-ledger's simplicity, and the fact that you just set up the=
 server
and let people visit it with their browser vs. installing a client ap=
p on
every accountant's desktop.

I think your questions are relevant, but I don't see much value in fo=
llowing
the COMPASS spec. for Sql-ledger now.

Just my opinion.
Steve

>
> Andre Felipe Machado
> PS: if I can remember some people is starting a documentation effor=
t. Why
> not use sourceforge resources for documentation at
> http://sourceforge.net/projects/sql-ledger ?

[SQL-Ledger-users] sql-ledger and international accounting standards / documentation

[Andre F. M. <and...@te...>]

Hello,
As I am a newbie at this, what is the positioning, or compliance of=20
sql-ledger to COMPASS  General Ledger Facility specification (=20
http://www.compassgl.org/newhometest/990305fr1.html , see=20
www.compassgl.org ) and the more international broad one International=20
Accounting Standards  Committee =AE (http://www.iasc.org.uk/frame/cen2.h=
tm=20
) see www.iasc.org.uk ?
I realized that www.compassgl.org is a subset and computational focused =

team from www.iasc.org.uk. Is it right?
Maybe these are irrelevant questions, but it "seems" that compliance wil=
l=20
allow fully integration with other sw (crm, hr, pos, etc, etc) and or=20
attract more and more developers to help. The www.gnuenterprise.org is a=
=20
bold attempt (pre alpha stage now) to create a big enterprise package,=20
and MAYBE sql-ledger could integrate well with it.
Please, some patience with these questions, as I am a newbie.....
Thanks.
Andre Felipe Machado
PS: if I can remember some people is starting a documentation effort. Wh=
y=20
not use sourceforge resources for documentation at=20
http://sourceforge.net/projects/sql-ledger ?

Re: [SQL-Ledger-users] LARGE INVENTORY

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

You get the source code and you can modify it to your liking. If you want
to see some features added or want to make a contribution submit your
additions/modifications for inclusion in the distribution. Others have
done so in the past.

Having said that, there is, however, no guarantee that your changes will
be included.  Some code makes it, some does not and some shows up in a
revised form. It's your call.


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 Wed, 7 Feb 2001, Thomas Sawyer wrote:

> Well, I think we've really put this one to rest, and I think Dieter will
> have to be duely impressed enough to develop the search code portions
> of sql-ledger in the direction of record count limits on navigational
> pages. i.e. n pages of m records each. And like I said the 'offset' method
> seems most appropriate esspecially since it encodes in a like fashion
> with an offset and count. That is to say:
>  
> SELECT * FROM table OFFSET current-pg-number * recs-per-page LIMIT recs-per-page;
> 
> Agreed? Of course I bet Matt Benjamin is nearly done with coding this
> already. Right? Else, do you want to go ahead? Let me know.
> 
> P.S. FYI I'm nealy done with a Sales Order module, simply based after
> the invoice module but with accounting activities removed. More soon...
> 
> 

Re: [SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Well, I think we've really put this one to rest, and I think Dieter will
have to be duely impressed enough to develop the search code portions
of sql-ledger in the direction of record count limits on navigational
pages. i.e. n pages of m records each. And like I said the 'offset' method
seems most appropriate esspecially since it encodes in a like fashion
with an offset and count. That is to say:
 
SELECT * FROM table OFFSET current-pg-number * recs-per-page LIMIT recs-per-page;

Agreed? Of course I bet Matt Benjamin is nearly done with coding this
already. Right? Else, do you want to go ahead? Let me know.

P.S. FYI I'm nealy done with a Sales Order module, simply based after
the invoice module but with accounting activities removed. More soon...

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Scott Taylor <gst...@te...> wrote:
> dr...@ss... wrote:
> > 
> > In message <Pin...@ti...>,
> "Roderick A.
> >  Anderson" writes:
> > > On Tue, 6 Feb 2001, Andrew Sharp wrote:
> > >
> > > >     if($CONFIG{sqllimit} == 1) {
> > > >         # this presuposes a limit statement in postgresql, but
> > > >         # I think it has them.  If it doesn't it can be coded
> > > >         # around anyway.
> > >
> > > PostgreSQL does have the limit clause which I believe is in the
> SQL92 and
> > > SQL99 standards.  It's easy to get into the MySQL (choose your
> own
> > > database) has this feature or that thingy but for the most part
> PostgreSQL
> > > follows the standands better than the other databases.
> > >
> > >    The problem with the limit statement is it is 'stateless'. 
> It picks
> > > the first 'n' records that meet the rest of the selection criteria.
> > > There is no easy way to remember the current 'n' items at the database
> > > level so the the next SELECT statement can pick the next 'n' items.
> > 
> > There is a way to pick the next set.  Use the offset keyword.
> > 
> > select * from table where criteria offset START limit LENGTH
> > 
> 
> Hi, 
> 
> phpGroupWare does this with the todo list (and other apps) using PHP
> and
> MySQL or PostgreSQL.  Converting to CGI/Perl input shouldn't be too
> difficult. 
> Check it out at http://www.phpgroupware.org/  it's still very much
> in
> the developement stage, I would suggest rel 0.9.1 or 0.9.2, the newer
> ones seem to be more buggy. :o(
> 
> Regards.
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] LARGE INVENTORY

[Scott T. <gst...@te...>]

dr...@ss... wrote:
> 
> In message <Pin...@ti...>, "Roderick A.
>  Anderson" writes:
> > On Tue, 6 Feb 2001, Andrew Sharp wrote:
> >
> > >     if($CONFIG{sqllimit} == 1) {
> > >         # this presuposes a limit statement in postgresql, but
> > >         # I think it has them.  If it doesn't it can be coded
> > >         # around anyway.
> >
> > PostgreSQL does have the limit clause which I believe is in the SQL92 and
> > SQL99 standards.  It's easy to get into the MySQL (choose your own
> > database) has this feature or that thingy but for the most part PostgreSQL
> > follows the standands better than the other databases.
> >
> >    The problem with the limit statement is it is 'stateless'.  It picks
> > the first 'n' records that meet the rest of the selection criteria.
> > There is no easy way to remember the current 'n' items at the database
> > level so the the next SELECT statement can pick the next 'n' items.
> 
> There is a way to pick the next set.  Use the offset keyword.
> 
> select * from table where criteria offset START limit LENGTH
> 

Hi, 

phpGroupWare does this with the todo list (and other apps) using PHP and
MySQL or PostgreSQL.  Converting to CGI/Perl input shouldn't be too
difficult. 
Check it out at http://www.phpgroupware.org/  it's still very much in
the developement stage, I would suggest rel 0.9.1 or 0.9.2, the newer
ones seem to be more buggy. :o(

Regards.

Re: [SQL-Ledger-users] LARGE INVENTORY

[Roderick A. A. <raa...@ti...>]

On Wed, 7 Feb 2001, Thomas Sawyer wrote:

> Well what do you know, three way to do it!

And being wrong helped get an answer. :-)


Well I usually use LIMIT to test queries that would normally return a HUGE
set.  Plus I'm just getting back to using SQL.  My last major experience
was three years ago and it was with Oracle.  So wrong is what I do good!

> If the offset works for both Postgres and MySQl then maybe that's the
> best way to go.

Learn something new all the time.


Rod

Re: [SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Well what do you know, three way to do it!

If the offset works for both Postgres and MySQl then maybe that's the
best way to go.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Matt Benjamin <ma...@li...> wrote:
> 
> Seems like this works for MySQL or Postgres.  With Oracle, you can
> do
> things with ROWNUM to similar effect.
> 
> Matt
> 
> 
> Matt Benjamin President/CTO
> 
> The Linux Box
> 206 South Fifth Ave. Suite 150
> Ann Arbor, MI  48104
> 
> tel. 734-761-4689
> fax. 734-769-8938
> pgr. 734-431-0118
> 
> On Wed, 7 Feb 2001 dr...@ss... wrote:
> 
> 
> >
> > There is a way to pick the next set.  Use the offset keyword.
> >
> > select * from table where criteria offset START limit LENGTH
> >
> > --
> >   -- Drew Sullivan, <dr...@ss...> -- Toronto, Canada,  +1-416-512-2311
> >      Copyleft--all rights reversed
> >
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Postgresql does have a limit clause. It is different from MySQL in that
it uses reversed order. Ex. Lets say you have a large inventory, like
I do, then query:

SELECT * FROM parts LIMIT 1000, 0;

This will return records 0 (the first) through the 1,000th.

For the next set of records we would query:

SELECT * FROM parts LIMIT 2000, 1000;

and get the 1000th though the 2000th records. There would only ever be
a descrepency in the returned records if someone added or deleted records
between these queries.

I have already placed this limiting code in to sql-ledger's ic.cgi script
without any errors being reported, though I have yet to fully test it.
I'll let you know.

Given that this limit clause works okay then this is probably a bit better
than script proccessing the top n returned records, and the next n records,
because each time you'd still have to query all the records. Not that
much more overhead for such a capable database as postgresql but still
more overhead.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- "Roderick A. Anderson" <raa...@ti...> wrote:
> On Tue, 6 Feb 2001, Andrew Sharp wrote:
> 
> >     if($CONFIG{sqllimit} == 1) {
> >         # this presuposes a limit statement in postgresql, but
> >         # I think it has them.  If it doesn't it can be coded
> >         # around anyway.
> 
> PostgreSQL does have the limit clause which I believe is in the SQL92
> and
> SQL99 standards.  It's easy to get into the MySQL (choose your own
> database) has this feature or that thingy but for the most part PostgreSQL
> follows the standands better than the other databases.
> 
>    The problem with the limit statement is it is 'stateless'.  It picks
> the first 'n' records that meet the rest of the selection criteria.
>  
> There is no easy way to remember the current 'n' items at the database
> level so the the next SELECT statement can pick the next 'n' items.
> 
>    The better choice is to select all the records that meet the criteria
> -
> using the DBI - and break them up into groups/bunches to display using
> a
> display limit.
> 
> Since I've only been half following the discussion (subscribed to too
> many
> other mailing lists - including two of the PostgreSQL lists) I'm not
> sure
> where the 'convince Dieter' discussion is at currently.  I was mostly
> concerned over the repeated question about PostgreSQL having the LIMIT
> clause but then realized the LIMIT discussion could be going down the
> wrong road.
> 
> I hope that we convince Dieter to add some method of limiting the
> selection and displayed list so please don't take this as a rebuke.
> 
> 
> Good Computing,
> Rod
> -- 
> I really need a signature block!
> 
> 
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com